Oracle Apps Interview Questions

USER EXITS

            We build user exits when we want to pass control from report builder to a program we have written, which performs some function, and then returns control to report builder.

            SRW.USER_EXIT (‘FND RSWINIT’) (Before report trigger)

            Fetches concurrent request information and setup profile options.

            SRW.USER_EXIT (‘FND SRWEXIT’) (after report trigger)

            Frees all the memory allocation done in other oracle applications user exits.

            SRW.USER_EXIT (‘FND FLEXSQL’) (Before report)

            CODE =”flex field code”

            APPL_SHORT_NAME =”application short name”

            OUTPUT =”: out put lexical parameter name”

            MODE =” {select | where | having| order by}”

            DISPLAY = {all | flex filed qualifier | segment no “}

            This user exit populates the lexical parameter that we specify with the appropriate column names/sql fragment at runtime.

            This enables the report itself to retrieve the concatenated flex field segment values

Out put: - specify the name of the lexical parameter to store the sql fragments.

            SRW.USER_EXIT (‘FND FLEXIDVAL CODE =”FLEX FIELD CODE”                                  APPL_SHORT_NAME = “Application short name” DATA =”: source column name” [NUM = “: structure defining source column [lexical]”

            Call this user exit to populate fields for display we pass the key flex field’s data retrieved by the query into this exit from the formula column

            SRW.USER_EXIT (‘FND_FORMAT_CURRENCY CODE   =”: column containing currency code’ DISPLAY_WIDTH =” field width for display” AMOUNT =”: source column name DISPLAY =”: display column name”

            This user exit format the currency amount dynamically depending upon the precision of the actual currency value

PL/SQL stored procedure parameters?  Or

What are the two parameters that are mandatory for pl/sql type concurrent program?

Procedure/function (ERRBUF OUT RETCODE OUT ………………….)

            ERRBUF: - Used to write the error message to log or request file.

            RETCODE: - Populate log request file with program submission details info.

What is Value Set?

            The value set is a collection (or) container of values.

           

            When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.

      

            If the list of values needed to be dynamic and ever changing and define a table based values set.

The table name to store value set values?

            FND_FLEX_VALUE_SETS