How To Add Any Responsibility To A User From Back End

 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);

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:

1. How To Call A Standard Interface Program From Sql or pl/sql Code
2. How To Copy Files Using a PL/SQL Script
3. How To Delete A Concurrent Program And Executable From Back End In Oracle Apps
4. How To Dump Data From Pl/SQL Block To Flat Files
5. How To Get All The View That Are Referring To A Particular Table
6. How To Get RESPONSIBILITY_ID, APPLICATION_ID & USER_ID
7. How To Send An SMS Using PL/SQL Code/Script
8. PL/SQL Script To Change/Reset The Oracle Applications Password From Back End
9. PL/SQL Script To Create A User In Oracle Applications
10. PL/SQL Script To Remove End Date From Responsibilities Assigned To A User