Interview with Arowana Consulting

Hi

While my interview with Arowana, i was interviewed with my company & than with the client also.

Arowana Interview:
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 Workflow?
A. It is a process, which in turn runs internally while using a notification for approval process.

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.

Interview with Arowana Consulting

Post Comment:

Subscribe to Email

Online Members