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

Application Object Library (AOL) in Oracle Apps R12

AOL mainly contains three things:

• Operating profiles (System Profiles)
• Application security (User, Function, and Responsibility Security)
• Concurrent Processing (Concurrent manager, request, program, process)

AOL is a powerful library having components of code (objects) used in one or more applications. 

AOL contains the following components:

• Users
• Responsibilities
• Request Group
• Request Sets
• Concurrent Programs
• Concurrent Managers
• Concurrent Program Executables
• Value Sets
• Flex Fields
• Form and Functions
• Menus
• Messages
• Table Registration
• Profiles
• Data Group

Responsibility

• It is nothing but a collection of three things – menu, data group, and request group which is attached to a specific user as per his/her level of access.

Request Group

• A request group is a collection of concurrent programs or request sets. It is attached to a responsibility to control the user’s access to concurrent programs/requests.

Request Set

• A request set is a collection of reports and/or programs that you group together. You can submit the reports and/or programs in a request set all at once using a single transaction.

Concurrent Program

• A concurrent program is a program that does not require continued interaction on your part to perform a specific task. In Oracle Applications, for example, the concurrent program may be a program written to create a report or to post a batch of general ledger journal entries.

Concurrent Manager

• The concurrent manager is a component of concurrent processing that monitors and runs tasks without tying up your computer.

Concurrent Process

• The concurrent process is an instance of a running concurrent program. Each time a concurrent manager receives a request and runs a concurrent program, it creates a new concurrent process. A concurrent process can run simultaneously with other concurrent processes

Concurrent Request

• The concurrent request is a request that you submit to run a concurrent program as a concurrent process.

Value Set

• A set of predefined or validated values assigned to a field (parameter) that restricts the user to enter from entering invalidated data.

Menu

• A  menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator.
• A  menu entry is a menu component that identifies a function or a menu of functions.
• Each responsibility has a menu assigned to it.

Functions

• A function is a set of Oracle Applications that is executed only if the name of the function is present in a list maintained within a responsibility.
• Because all users should not have access to every business function in a form, Oracle Applications provide the ability to identify pieces of applications logic as functions.
• Function security lets you restrict application functionality to authorized users.

Data Group

• The data group is a collection of pairings of Applications with Oracle ID.
• An Oracle ID is a username and password that allows access to application tables in an Oracle database.
• Concurrent managers use a data group to match the application that owns a report or concurrent program with a unique Oracle ID.