BEGIN
FND_USER_PKG.ADDRESP(
USERNAME =>
UPPER('AMOHSIN'), -- username
RESP_APP =>
'SYSADMIN',
RESP_KEY =>
'SYSTEM_ADMINISTRATOR',
SECURITY_GROUP => 'STANDARD',
DESCRIPTION =>
'DESCRIPTION',
START_DATE =>
SYSDATE,
END_DATE =>
NULL);
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;
Helping Oracle community with Technical and Functional helps on Oracle Applications R12
Nov 17, 2022
Add System Admin responsibility to a user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment