Tuesday, December 21, 2010

Responsibilities

To achieve security in Oracle Applications, related functions are organized in the form of a responsibility. For example, AR Super User responsibility will have all the functions required for Receivable super user. This responsibility is then assigned to users. A responsibility can be assigned to many users and a user can be assigned many responsibilities.


Responsibility is assigned to user in the user definition screen. Oracle comes with many pre-defined responsibilities. During implementation, often we need many custom responsibilities to be defined. The following figure shows the responsibility definition screen.

Important fields in this screen are described below:

Responsibility Name:  Name of responsibility. It can be any user understandable name.

Application:  Application Associated with the responsibility. If it is a custom responsibility, we usually associate custom application.

Responsibility Key:  It is a short name for responsibility

Available From:  Default value is ‘Oracle Applications’. In case a responsibility invokes HTML based forms, then one can choose ‘Oracle Self Service Web Applications.

Data Group:  Choose ‘Standard’.

Data Group Application: Application associated with the data group. In case of custom responsibilities, we choose custom application.

Menu:  Top menu which will be shown when user goes to the responsibility. In case we have a custom menu that can also be assigned here.

Request Group Name:  Name of the request group (Discussed in Concurrent program section).
Request Group Application: This is defaulted based on request Group.


Technical Details on Responsibility
Responsibility is stored in the following tables:

FND_RESPONSIBILITY
FND_RESPONSIBILITY_TL

Important fields in FND_RESPONSIBILITY table are as follows:
Application ID Application ID of the Application chosen
Responsibility ID Unique ID generated automatically
Menu ID Menu ID of the top menu chosen
Data Group ID ID of the Data group chosen
Request Group ID ID of the request group chosen
Responsibility Key Short unique name of responsibility entered

Name and Description of the responsibility is stored in FND_RESPONSIBILITY_TL table.

A view FND_RESPONSIBILITY_VL is available which a join between FND_RESPONSIBILITY and FND_RESPONSIBILITY_TL table. This view can be used to get responsibility name and description based on responsibility ID.
  
User - Responsibility Association

A view FND_USER_RESP_GROUPS_ALL can be used to find out the association of the user with the responsibility. This view contains user id and responsibility id. This view can be joined with FND_USER and FND_RESPONSIBILITY_TL table to select all the responsibilities assigned to an user.

No comments:

Post a Comment