PL-SQL code to add responsibility to application user

•By Amol Jadhav
PL-SQL code to add responsibility to application user
Oracle apps EBS add responsibility to user from backend
Script to add responsibility to user

SQL Querysql
1--
2--
3BEGIN
4   fnd_user_pkg.AddResp ('<User Name>',
5                         '<Resp Appl Short Name>',
6                         '<Responsibility Key>',
7                         '<Security Group>',
8                         NULL,
9                         NULL,
10                         NULL);
11
12   COMMIT;
13END;
14
15
16--Example:
17
18BEGIN
19fnd_user_pkg.AddResp ('AMOL',
20                      'SYSADMIN',
21                      'SYSTEM_ADMINISTRATOR',
22                      'STANDARD',
23                      NULL,
24                      NULL,
25                      NULL);
26
27COMMIT;
28END;
29/

Related posts: