Query to add responsibility from back end
beginfnd_user_pkg.addres( 'user_name',
'sysadmin',
'system_administrator',
'standard',
'add responsibility to user using pl/sql',
sysdate-1,
sysdate + 100);
commit;
dbms_output.put_line('responsibility added successfully to the user ');
exception
when others then
dbms_output.put_line(' responsibility adding failed due to' || "sqlcode" || substr(sqlerrm, 1, 100));
rollback;
end;
Explanation:
--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*/