Oracle apps interview questions and answers1

1.What is Oracle Apps (ERP)?

                  ERP stands for Enterprise Resource Planning. A product of Oracle India Pvt. Ltd. As the name suggests Enterprise Resource Planning. Enterprise means a firm/organization. Resource means available source of wealth in firm and Planning means how you can maintain day to day resource. Hence in short to facilitate big businesses, companies Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications.

2. What are cycles of GL, AP, and AR?

In general GL AP and AR consist of:

• Structure Phase - defines the process flows and configuration for the system and Conduct business process and data mapping workshops.
• Construct Phase - contains all of the configuration activities
• Transition Phase - executes system test
• Deploy Phase - migrates database to customer environment

3.What is FlexField? Explain types of flexfields?

We can assume FlexField as a collection of segments or sub-fields which can be added or removed to modify the structure of the FlexField and does not require any levels of programming. It is just a pop-up window which has a cause for each segment. There are two types:

• Key FlexFields
• Descriptive FlexFiled

Key FlexField is used for creating unique identifiers or constraints. It is the building block which defines the structure of objects. Key flexfields are flexible enough to let any organization use the code scheme they want, without programming. With the help of Key Fields an organization can define rules to specify which segment values can be combined to make a valid complete code (also called a combination).

Descriptive FlexField is used to create new fields on screen and capture other information. Also provides customizable”expansion space” on your forms. Descriptive flexfields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.

4. What are the businesses needs satisfy by the Oracle Applications flexfields?

The following businesses needs are served by FlexField:

• You can query the key fields.
• Helps in customization of data fields without programming.
• Helps in validating the values.
• Customize your applications to capture data that is not been tracked by your application.
• Consist of intelligent fields which comprised of one or more segments, where each segment has both a value and a meaning.

5. What are different types of invoices and what is a recurring invoice?

             Types of Invoice: Standard Invoice, CreditMemo Invoice, DebitMemo Invoice, Expense Invoice, Recurring Invoice With-hold tax Quick Match and Pre-Payment Invoice.

Recurring Invoice: As the name suggests the invoice that occurs at regular interval of time is known as the Recurring Invoice.

Differentiate between cross-validation rules and security-rules.

• Cross validation rules: Restricting the user for entering an invalid value in the segment. For e.g.: if user is providing an alphanumeric value in numeric segment, where just numbers are allowed. On the other hand security-rules checks upto what extent the changes could be done.
• Cross validation rules are applied as a whole but security-rules is valid upto a particular segment.
• Cross validation we can say checks probability for maximum combinations of segment values a user can enter. Whereas Security-rules determines the level upto which a user can view transaction. 

6.What is FSG? Explain its uses.

FSG stands for financial statement generator. It is powerful reporting engine for clearly define our reporting requirement. Helps in keeping the reporting simple by the use of Row Set, Reports, Content set and Column set. It uses ADI request set to publish standard reports.

Uses:

• Can produce a specific report when needed.
• Produce financial report without programming.
• Asynchronous printing of reports.
• Ability to print single reports for multiple firms.

7. What is MRC? Explain its uses?

         MRC stands for Multiple Reporting Currencies. It has default currency as US $. And if any organization books with some other currency there comes the requirement of MRC. Hence through MRC we can use currency as per our wish.

Uses:

• Transaction-Level Conversion.
• Inquiry and Reporting in Multiple Currencies.
• Euro Support. MRC allows Oracle Applications to support organizations that are transitioning from their national currency to the Euro.

8. Explain how to handle errors in Customer interface

            We can handle errors by using SQL*Loader, or other import program, to load customer information into the interface tables.

When you import customer information, the Customer Interface program validates the global attribute columns in the interface tables and transfers those values into the customer tables.

Before the Customer Interface program can properly validate your data file, you must:

1. Assign the appropriate context code for your country to the appropriate global attribute category column.
2. Map your global attribute columns from the interface tables to the corresponding global flexfield segment columns in the customer tables.

Or else act on the error code accordingly.

9.  What is the use of CUSTOM Library in Oracle Apps?

           The main beneficial use of the custom library is allowing extension to Oracle Application without modification of Oracle Application code. We can do the customization such as Zoom, enforcing business rules and disabling fields that do not apply for your site. Also used to validate the base application without modifying the Custom.pll.

10. What are User Exits? What are different types of User Exits in Oracle Apps? Explain the types.

             A user exit is a C subroutine written by user and called by Oracle Forms to do special-purpose processing. Helps the User to exit from the current working environment. Types of User exit:

FND SRWINIT: Sets your profile option values and allows Oracle AOL user exits to detect that they have been called by an Oracle Reports program

FND SRWEXIT: Ensures that all the memory allocated for Oracle AOL user exits has been freed up properly.

FND FORMAT_CURRENCY: Is used for MULTIPLE CURRNECY REPORTING.FND FLEXIDVAL: This API is used for get descriptions from flexfields get input from FND FLEXSQL.

FND FLEXSQL: this API is used for get ELECT/WHERE/HAVING/ORDER BY/GROUP BY from flex field tables.