Oracle Apps Interview Questions

MD 50 is nothing but the functional flow document which is designed by the Functional Consultant

MD50 is Oracle apps functional specification document.

1.Create the RDF using Report Builder
2.Register the concurrent program and select Output format as XML and Style A4.
3.Go through XML Publisher responsibility
Create Data Definition & Template
attach the RTF in Template .

Hi , to generate an XML report u can create an RDF reprot from report builder and then while registering it as a concurrent program choose output type as XML...this way you can create an XML report

Thanks,

Brajesh

1.Requisition 2.RFQ 3.Quotation 4.Purchase Orders 5.Receipts 6.Invoices 7.Transfer to GL Journal Entries: 1. Receive Receiving Material To Accrual 2. Deliver Inventory Material Cost ...

1) When ever we receive the material to staging area receiving inventory a/c Dr To Ap accrual a/c 2)staging area to sub inventory inventory a/c Dr To rece...

Multi -Org Flow for R12:
---------------------------------

1. Business Group
2. Ledger
3. Legal Entity
4. Operating Unit
5. Inventory Organization
6. HR Organization

Multiorg is implementing multiple organisations under single oracle implementation.

SECURITY RULE: Control Access to ranges of Accounting Flex-field Segment values by defining Security Rules and assigning them to responsibilities Prohibit invalid combinations of ...

Security Rule: By using the security rule we can give the access permission to the user for specific segment values and the security rule works at Responsibility Level. Cross Validation Rule: By usin...

3 types of testing is performed 1. System integration test (SIT/developer testing): To check configuration of system providing desired output from system. 2. Quality Assurance Testing (QAT): if some...

The functional consultant has to understand the modules they are implementing and the set up and configuration options available, the key skill is being able to map the requirements of the customer to...

Key Flexfield: it used to capture the organization mandatory information.

Descriptive KFF: It is used to capture the organization additional information

Thanks for the Answers.. There are Two Key Flexfiled in Gl..1.Accounting key flexfield 2Reporting Attributes Accounting FF.

We have 3 KFF in gl module those are 1. accounting key flexfeild: By using accounting key flexfiled we can design our organization structure 2.reporting attribute key flexfield: this key flexfild is ...

now in GL 3 KFFS are there

1) Accounting Flexfield
2) Repeating attributes Flex field
3)gl ledger flex field(this is used for mass allocation purpose whenever we are run the mass allocation generate report that time added one more segment that is gl leder flex filed.

This profile groups Operating Units allows us to access to more than one organization from the same responsibility. When the profile SLA: ENABLE SUBLEDGER TRANSACTION SECURITY is set to Yes, drill-dow...

If you are executing from SQLPlus then

SQL> execute procedurename(paramters); -- You can also use short format EXEC

If you are using PL-SQL then

BEGIN

procedurename(parameters); -- no need to use Execute keyword in PL-SQL block

END;

Thanks

There are two ways to execute the stored procedure
1. EXEC
2. Create anonymous block
EX:
BEGIN

END;

IF procedure is declared in package then we have to call this procedure in following way:

.

Jaya is correct. But Party could be the super type that has all the data the other three share in common. All the common data goes in Party, the individually specific data goes in the other three.

supplier_id - is the party referred as, in payables AP
Vendor_id - is the party refereed as, in PO
customer_id and party_id is party referred as, in AR

GO WITH TC:
SE11

Through se16 we can see all the tables

Contract purchase agreements are created for suppliers to agree on specific terms and conditions without indicating the goods and services that u will be purchasing,

You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standar...

1) Log on to System Administrator.

2) Go to Security > User > Query the User Name.

3) Remove the Date Effective To( i.e which is end dated as open).

You can be able to view the System Administrator Responsibility.

The system administrator responsibility got disabled. We can still use application developer responsibility and add "Define Responsibility" function / screen to existing any responsibility. ...

1) Log on to System Administrator Responsibility.

2) Define Concurrent Program Executable.

3) Define Concurrent Program by giving Short name, Application Name, Description & also choose the concurrent program executable.

IF YOU ARE REGISTERING A REPORT IN CONCURRENT PROGRAMING THEN FOLLOW:UPLOAD U R REPORT.rdf TO THE SERVER ACCORDING TO THE PATHapps/test/peilappl/gl/11.5.0/reports/USCREATE AN EXECUTABLE ------ WHERE T...

Apps Developer needs to request Apps DBA to extend the disk space, so that Apps DBA Can add the space which would solve the problem.

Printer Style is the style of the printer , in other words style is nothing but the definition of the combination of Rows and Columns ( Ex:- Landscape, Land Wide or Portrait).

Oracle Application Architecture is 3 Tier Architecture.

1) Database Tier ( Ex:- Oracle )/ Server/ Back End.

2) Client/ Front End ( Ex:- Forms ).

3) Application Tier ( New Tier ).

Hi,Did they ask you about the Apps Architecture (or) the Hierarchy? Generally they ask you about the Apps Hierarchy i.e, how Apps implemenations are done.As per what he/she has mentioned it, it is 3 t...

This is one of the Profile option, if fnd: diagnostics = yes then we can examine any record information from the Form.

Form> Tools> Examine ( we can able to view the record history ).

Self Service has a similar profile option. If the profile option FND: Diagnostics is set to Yes, then anyone can use the Diagnostics Examine function which allows users to change database records.rela...

Recurring Invoice is one of the invoice type which can be used for paying to the customer periodically the best example of RI is for paying the Rent.

Recurring invoice is one of the type of invoice in ap module.After receiving the material from the supplier and will pay the amount against the material. for that we will raise the invoice document. a...