Introduction:-
Being Oracle Database administrator, we are using various API to end date responsibility to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing ‘how to end date responsibility in oracle apps from backend‘ using API to end date responsibility.
Copy below API to end date responsibility in oracle apps from backend.
-- -----------------------------------------------------------------
-- API to end date user responsibility in oracle apps
-- -----------------------------------------------------------------
DECLARE
v_user_name VARCHAR2 (100) := '&Enter_FND_LOGIN';
v_responsibility_name VARCHAR2 (100) := '&Enter_Responsibility_name';
v_application_name VARCHAR2 (100) := NULL;
v_responsibility_key VARCHAR2 (100) := NULL;
v_security_group VARCHAR2 (100) := NULL;
BEGIN
SELECT fa.application_short_name,
fr.responsibility_key,
frg.security_group_key
INTO v_application_name,
v_responsibility_key,
v_security_group
FROM fnd_responsibility fr,
fnd_application fa,
fnd_security_groups frg,
fnd_responsibility_tl frt
WHERE fr.application_id = fa.application_id
AND fr.data_group_id = frg.security_group_id
AND fr.responsibility_id = frt.responsibility_id
AND frt.LANGUAGE = USERENV ('LANG')
AND frt.responsibility_name = v_responsibility_name;
fnd_user_pkg.delresp
( username => v_user_name,
resp_app => v_application_name,
resp_key => v_responsibility_key,
security_group => v_security_group
);
COMMIT;
DBMS_OUTPUT.put_line ( 'Responsiblity '
|| v_responsibility_name
|| ' is removed from the user '
|| v_user_name
|| ' Successfully'
);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line
( 'Error encountered while deleting responsibilty from the user and the error is
|| SQLERRM
);
END;
/In case of reset password from API from back-end, you may click here.
Similarly, you may check another article to improve your knowledge, click here.