-
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)
-
-
-
-
-
-
Interview Questions for Oracle 11i Apps (Manufacturing)?
Item Setup FAQs Once an item is assigned to an organization, is it possible to remove this association at a later time? A. If you have assigned an item to an organization, it can only be deleted from that organization if the item has NOT been transacted. If it has been transacted against you cannot delete the item from the organization. See the Oracle Inventory User's Guide. You can, however,...
-
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.
-
Oracle Apps Basics Interview Questions
Ans