Oracle apps interview questions and answers 3

21. How do we enable tracing for the document managers?

             This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.

22. Difference between running Gather Stats and “Program – Optimizer [RGOPTM]” in Oracle General Ledger

              Former cannot create any indexes but Stats will simply gather the stats against existing tables. But latter can create indexes on GL_CODE_COMBINATIONS, only if accounting segment has the indexed flag enabled.

23.  Use FND Logging. At back Oracles FND Logging uses self reliant transaction to insert records in a table of name fnd_log_messages.

For example
DECLARE
BEGIN
        fnd_log.STRING(log_level => fnd_log.level_statement
                     ,module => 'xxxx ' || 'pkg/procedurename '.
                     ,message => 'your debug message here');
END ;
Three profile options effecting FND Logging are
FND: Debug Log Mode
FND: Debug Log Enabled
FND: Debug Log Module

24. How does substitution work in OA Framework?

             The base of working of Substitution in OA framework depends on the user that has logged into OA Framework. After the user has logged MDS defines the context of the logged in user. Depending the logged context, all applicable personalization is applied by MDS.For e.g.: substitutions are loaded as site level personalization; MDS applies the substituted BC4J objects along with the personalization. Hence the above listed steps would occur as soon as Root Application module has been loaded. 

25. Benefits of using Substitution in OA Framework

• To extend the OA Framework without customization of the underlying code.
• Helps in Up gradation.
• Entity Objects as well as Validation Objects can be substituted.

26. How can you import invoices into Oracle Receivables?

         This can be done in two ways defines below:

We can either use AutoInvoice. Which can be possible by populating following table name RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL and RA_INTERFACE_SALESCREDITS_ALL.

Alternately by using API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.

27.  How do you setup a context sensitive flexfield?

To setup a context sensitive flexfield follow these steps:

• Create a reference field first
• Second use the created reference field inside Context Field section of DFF Segment screen.
• Then for each possible value of the context field, you will need to create one record in section named Context Field Value which should be beneath the global data elements.