-
-
-
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 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....
-
-
-
-
-
Difference between Key and Descriptive Flexfield?
Key Flexfield Descriptive Flefield1. Unique Identifier 1.To capture extra information2. Key Flexfield are stored in segment 2.Stored in attributes3.For key flexfield there are flexfield Qualifier and segment Qualifier 3. Context-sensitive flexfield is a feature of DFF. (descriptive flexfield)
-
-
Do you have to register feeder programs of interface to AOL ?
Yes ! you have to register the feeder programs as concurrent programs to Apps.
Oracle Apps Basics Interview Questions
Ans