How To Add System Administrator Responsibility To A User from backend
Most of the time oracle apps developers are given only limited access to the front end application for development, in such cases you would like to add a responsibility from back end.
By using the below PL/SQL script/code you can add any responsibility to a user.
Syntax:
fnd_user_pkg.addresp(username => v_user_name
,resp_app => 'SYSADMIN'
,resp_key => 'SYSTEM_ADMINISTRATOR'
,security_group => 'STANDARD'
,description => 'Auto Assignment'
,start_date => SYSDATE - 10
,end_date => SYSDATE + 1000);
,resp_app => 'SYSADMIN'
,resp_key => 'SYSTEM_ADMINISTRATOR'
,security_group => 'STANDARD'
,description => 'Auto Assignment'
,start_date => SYSDATE - 10
,end_date => SYSDATE + 1000);
Usage:
BEGIN
fnd_user_pkg.addresp ('OPERATIONS','SYSADMIN','SYSTEM_ADMINISTRATOR','STANDARD',
'Add Sysadmin Responsibility to OPERATIONS user using pl/sql', SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ' Responsibility is not added due to ' || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;
Most Frequently Used PLSQL Scripts In Oracle Apps:
- How To Call A Standard Interface Program From Sql or pl/sql Code
- How To Copy Files Using a PL/SQL Script
- How To Delete A Concurrent Program And Executable From Back End In Oracle Apps
- How To Dump Data From Pl/SQL Block To Flat Files
- How To Get All The View That Are Referring To A Particular Table
- How To Get RESPONSIBILITY_ID, APPLICATION_ID & USER_ID
- How To Send An SMS Using PL/SQL Code/Script
- PL/SQL Script To Change/Reset The Oracle Applications Password From Back End
- PL/SQL Script To Create A User In Oracle Applications
- PL/SQL Script To Remove End Date From Responsibilities Assigned To A User
COMMENTS