Below query can be used to add (any)responsibility from backend database:
BEGIN
FND_USER_PKG.ADDRESP (
'XX_USERNAME', — Username
'SYSADMIN', –application short name
'SYSTEM_ADMINISTRATOR', — Responsibility Key
'STANDARD', — Security Group Key
'Sysadmin Responsibility added due to work', –Description
sysdate, –Start date
null –End date
);
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;
