DCP

Wednesday 9 April 2014

Access control to a function/report using RBAC in r12

Giving access of a report to a particular user using RBAC

Assign Transfer Journal Entries to GL to a specific user
Author: Faraz Anwar
Dated: 03/07/2014

Step 1) Create Function
System Administrator > Application > Function
Function Code
XXGL_APGL_TRXFR
User Function Name
XX Transfer Journal Entries to GL
Type
Form
Form
Run Reports
Application
Application Object Library
Parameters
REQUEST_GROUP_CODE="XXGL_APGL_TRXFR" REQUEST_GROUP_APPL_SHORT_NAME="SQLAP" TITLE="AP:TRANSFER_TO_GL" USE_ORG="N"





Step 2: Add a Function to Menu
System Administrator > Application > Menu
Query Menu AP_NAVIGATE_GUI12
Add a menu item “XX Transfer Journal Entries to GL” at the end of the menu as shown in the figure.

Sequence
180
Prompt
Submit AP to GL Transfer
Submenu

Function
XX Transfer Journal Entries to GL
Grant
Uncheck Grant





3) Create a Permission Set
System Administrator > Application > Menu
Menu
XXGL_APGL_TRXFR
User Menu Name
XX Transfer Journal Entries to GL
Menu Type
Permission Set

Seq
Prompt
Submenu
Function

1


XX Transfer Journal Entries to GL




Step 4) Create a new Request Group
System Administrator > Security > Responsibility > Request
Group
XXGL_APGL_TRXFR
Application
Payables
Code
XXGL_APGL_TRXFR
In Requests Section Add:
Type
Name
Application
Program
Transfer Journal Entries to GL
Subledger Accounting




Step 5: Create Grant
Functional Administrator > Secuirty:Grants (Tab) > Create Grant (Button)


Name
XX Transfer Journal Entries to GL
Description

Grantee Type
Specific User
Grantee
XX
Responsibility
XX AP Inquiry






Set
XX Transfer Journal Entries to GL



Click Finish