Arowana Interview Questions and Answers

Round: Technical Interview
Experience: He asked me around 10 questions in Oracle Applications.

1. What is DFF & KFF?

A. DFF stores additional information in the database using attribute columns whereas KFF is a primary data or identical data or intelligent key has information in segments.

2. 5 Parameters of RDF & execution heirarchy?

A. Before Report

After Report

Before Parameter

After Parameter

Between Pages

Execution Heirarchy:

Before Parameter

After Parameter

Before Report

Between Pages

After Report

3. What is token in Oracle Apps?

A. Token is nothing but the parameter which is being used in report.

4. What is the mandatory parameter used in Report?

A. P_CONC_REQUEST_ID is the mandatory parameter used in report.

5. Flow of AR Module?

A. Transaction Creation --> Transfer to GL --> Receipt Creation --> Post to GL.

6. Apps Architecture?

A. It is a managed ERP system, which work in any kind of industry.

It has centrally managed module like Financials which has module like AR - Accounts Receivable, AP - Accounts Payable, FA - Fixed Assets, CM - Cash Management, GL - General Ledger.

likewise for Distribution modules are like OM - Order Management, PO - Purchasing, INV - Inventory, over the top it has HRMS & CRM.

7. How to enable a DFF?

A. To enable a DFF, need to know the DFFs which are available for application, for ex. if we need to enable a DFF in transactions then need to find out which DFF has to be enabled whether for Transaction Header & from Transaction Line, depends on the scenario.

8. How to create a report in XML Publisher?

A. To create a report in XML, need to create a Query in DataModel of Report Builder without having Layout. Than register a concurrent program having report output as XML. once you run the report..u can see the output in XML tags..now save those contents in xml file, now open Winword where we have ad-on menu of XML Publisher now use this data of xml, import the data & create a RTF template using this data. once it is done save it in RTF format then create a Data Definition in XML Publisher reponsibility using Oracle Apps & attach this Data Definition to the Template while creating a Template & use this .RTF template attached to it. & Then run the report u can see the output in PDF format.

9. What is Alert?

A. It is an action, which performs an action on specific time or on event.

10.What is Alert? A. It is a process, which in turn runs internally while using a notification for approval process.

College Name: Vjti