Below is the script that can be used to assign responsibility for a user.
DECLARE
l_user_id NUMBER;
l_resp_id NUMBER;
l_appl_id NUMBER;
CURSOR cur_resp
IS
SELECT responsibility_id, application_id -- INTO l_resp_id, l_appl_id
FROM fnd_responsibility_vl
WHERE UPPER (responsibility_name) LIKE UPPER ('XXXXX');
BEGIN
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = 'UUUU';
FOR rec_cur IN cur_resp
LOOP
fnd_user_resp_groups_api.insert_assignment (
user_id => l_user_id,
responsibility_id => rec_cur.responsibility_id,
responsibility_application_id => rec_cur.application_id,
security_group_id => 0,
start_date => SYSDATE - 1,
end_date => NULL,
description => NULL
);
COMMIT;
END LOOP;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.Put_Line ('Exception in the Main');
END;
***Please leave a comment***
This is very useful script.... Thanks Kalyan.
ReplyDelete