Adding Responsibility

Using following Script you can Add required responsibilities yourself At APPS Schema.

DECLARE

v_session_id INTEGER := userenv('sessionid');
v_user_name VARCHAR2(30) ;
l_resp_key varchar2(200);
l_resp_app varchar2(2000);
BEGIN
v_user_name :=UPPER('&user_name');
l_resp_key :=UPPER('&resp_key');
l_resp_app :=UPPER('&resp_short_name');

--SELECT
--fa.APPLICATION_SHORT_NAME,
--fr.RESPONSIBILITY_KEY,
--fr.RESPONSIBILITY_NAME
--FROM
--FND_APPLICATION_vl fa,
--fnd_responsibility_vl fr
--WHERE
--fa.application_id=fr.application_id
--AND fr.RESPONSIBILITY_NAME like 'MRC, USD Payables%Reporting%'

---Using Above Query Get Application Shot name and Responsibility Key

fnd_user_pkg.addresp
(username => v_user_name
,resp_app => l_resp_app
,resp_key => l_resp_key
,security_group => 'STANDARD'
,description => 'Auto Assignment'
,start_date => SYSDATE - 10
,end_date => SYSDATE + 1000);

COMMIT;

dbms_output.put_line('Responsibily Added Successfully');

exception
when others then

dbms_output.put_line('Error While adding Responsibily'' 'SQLCODE' 'substr(SQLERRM, 1, 200));

Rollback;

END;

/

SHOW ERRORS;