Oracle Apps Interview Questions

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

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:

.

Begin

execute BNR;

end;

Note:- "BNR" is the stored procedure name.

GO WITH TC:
SE11

Through se16 we can see all the tables

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.

Only one Key Flex filed is in General Ledger i.e Accounting Flexfield.

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...

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...

Functional guys are needed to provide the necessary information taken from clients or from the legacy system to the techies and rest. They will take care to provide necessary guidance and information given to them.

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...

Cross Validation Rules does not allow invalid code combinations.

Security Rules restrict the data by responsibilities.

When we are implementing the General Ledger at that time we need to freeze the account codes or define the Cross Validation Rules, whereas Security Rules, will be defined to restrict the user of choosing the wrong code combinations.

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...

DRM-Customer raise the DRM to reduce the liability. CRM-Supplier raise the CRM and also we can use for refunds. Example: case1 PO is 100 items. Suppler sent 100 Items We re...

The "Payables Invoice Import" is designed to import expense reports. The sources are: XpenseXpress SelfService Oracle Project Accounting The "Payables Invoice Import" should be used to import exp...

It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...

The 2 mandatory parameters are:
1). RetCode.
2). Errbuff.

3.How are Deferred Activities started again? - The process can be restarted by the Notification System, such as when a user responds to a notification; by the background engine, such as when a deferre...

2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..? Each user of Oracle Workflow Builder operates the system at a certain access level. The access...

profile is nothing but changeable option it will change the way of application execution,when we create in oracle applications we will design the profile values for every user

you can see the profile levels:

>>>user level
>>>application level
>>>responsibility level
>>>user level

Profile is a changable option which will change the Application Execution.

Blanket Purchase order can be used when - Duration of contract is fixed- Buyer knows which items to be purchased (fixed set of items)- Quantity of items is unknown- Price given by supplier is fix...

Blanket Purchase Agreement is raised for long term contract with the supplier. We have price breaks in this. We can create BPA for the item to be supplier by the supplier though we do not know quantit...