-
-
-
-
-
-
-
-
-
-
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 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 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 is Key and Descriptive Flexfield?
Key Flexfield: #unique identifier, storing key information# Used for entering and displaying key information.For example Oracle General uses a key Flexfield called Accounting Flexfield to uniquely identifies a general account.Descriptive Flexfield: # To Capture additional information. # to provide expansion space on your form With the help of [] . [] Represents descriptive Flexfield.
-
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
-
-
-
-
-
-
Oracle Apps Basics Interview Questions
Ans