-
-
-
What are Autonomous transactions ? Give a scenario where you have used Autonomous transaction in your reports ?
An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction....
-
-
-
-
What is record group ?
Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables thru sql queries.
-
-
-
-
-
-
What is the use of Temp tables in Interface programs ?
Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.
-
-
-
-
-
What are APIs? Can you name a few APIs?
API - Application Program Interface is a PL/SQL call made to the application to create business transactions or events. This is an alternative to using the interface tables in applications to insert and process transactions. You can find the APIs from the database by querying the all_objects table for name like '%_PUB'eg: AR_ADJUST_PUB in AR to create adjustments
-
-
How to pass parameters to a report ? Do you have to register them with AOL?
You can define parameters in the define concurrent program form. There is no need to register the parameters with AOL. But you may have to register the value sets for those parameters.
Oracle Apps Basics Interview Questions
Ans