Trade Community Architecture JOIN TABLES

Procure to Pay Life Cycle in Oracle Apps R12

Interview Question

    1. Pseudo columns

     Automatically filled by Oracle.

     Ex: sysdate, nextval, currval, rowid, rownum, level, sqlcode, sqlerrm, new, old.

2. What are the Parameters for raise_application_errror ()?

    The parameters are Error Code and an Error Message.

    The Syntax: raise_application_errror (Error Code, Error Message);

3. What are the User PARAMETERS in the Reports?

           P_CONC_REQUEST_ID

       P_FLEX_VALUE

What is a Responsibility in Oracle Apps?

Responsibility is a collection of different modules that the user is to access.

OR

Responsibility is the collection of menus, request security groups, and data groups.

  Menus: a collection of forms is nothing but menus (Mandatory)

  Request security groups: a collection of programs. (Optional)

  Data groups: a group of modules to be made accessible by the user through (Mandatory)

  Function & Menu: Exclusion (Optional)

          

Define a new Responsibility:

           System admin-> Security: Responsibility -> define

                                        Security: user-> define

What are the common values passed by a procedure in variables ERRBUFF, RETCODE?

ERRBUFF It is used to return the error messages and sent them to the log file.

RETCODE It is used to show the status of the Procedure with 0,1,2.

There are 3 types of RETCODE they are:-

# 0: Success

# 1: Warning

# 2: Error