Oracle Apps Top 10 Interview Questions Answers

The article "Oracle Apps Top 10 Interview Questions Answers" are helpful for the job seekers who are searching for interview questions with answers on Oracle Apps. 

1.  Define Oracle Apps (ERP)?

Ans: ERP stands for Enterprise Resource Planning. Hence in short to assist big businesses, companies Oracle Corporation have created huge software known in the category of ERP  as Oracle Applications.

2.  What is the main purpose of FORUPDATE?  

Ans: Selecting in FOR UPDATE mode locks the deleted until a commit or rollback is subjected to which will release the row. If you plan on updating or deleting records that have been referenced by a select For Update statement you can use the Where Current of statement.

3.  What is multi node system?

Ans: Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. 

4.  Explain about rule based optimization in Oracle Apps?

Ans: An oracle database is now called rule-based optimization, which uses a fixed strategy to optimize a query's results.

5.  Does oracle support partitioning of tables in Oracle Apps?

Ans: Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. To avoid the cost of licensing you may suggest the consumers may decide to permanently close their older GL Periods, such that historical records can be archived.

6.  What are the different report triggers?

Ans:  There are mainly five report trigger:

1. Before Report
2. After Report
3. Before Parameter Form          
4. After Parameter Form

7.  What are the benefits of using Substitution in OA Framework?

Ans: The benefits of using Substitution are to expand the OA Framework without customization of the basic code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. 

8.  Define FlexField?

Ans: An Oracle Applications field made up of sections. Each section has a given name and a set of valid values. Oracle Applications uses flexfields to confine information about your business.

9. What is Concurrent Programming?

Ans: Concurrent Programming in Oracle Apps all together execute the programs running in the Background with online operations to fully make use of your hardware capacity.

10. What are the different types of executable available in Concurrent Programming?

Ans: The different types of executables:

1. Host
2. Oracle Reports
3. PL/SQL Stored Procedures
4. SQL*LOADER
5. SQL*PLUS
6. Spawned
7. JSP