begin fnd_user_pkg.addresp( ‘&User_Name’, /*Application User Name */ ‘&Responsablity_Application_Short_Name’, /*get from Query Below */ ‘&Responsibility_Key’,/*get from Query Below */ ‘&Security_Group’, /* Most of cases it is ‘STANDARD’ so you can hard code it */ ‘&Description’, /* Any comments you want */ ‘&Start_Date’, /* Sysdate From Today */ ‘&End_Date’ ); /* Sysdate + 365 Rights for Next One Year*/ 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; /
Sample:add Responsibility of “Receivables Manager” to User Jiltin
BEGIN fnd_user_pkg.addresp (‘JILTIN’,‘AR’,‘RECEIVABLES_MANAGER’,‘STANDARD’,‘Add Responsibility to 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;
Related:Oracle Apps Script to create a new User Login Account