This script below will get the list of all inactive users and end date all the responsibilities assigned to them.<\/p>\n
Declare BEGIN <\/p>\n FOR rec_inactive_user IN cur_inactive_user --checking if the responsibility is assigned to the user<\/p>\n IF (fnd_user_resp_groups_api.assignment_exists -- Call API to End date the responsibility<\/p>\n fnd_user_resp_groups_api.update_assignment<\/p>\n (user_id => rec_inactive_user.user_id, COMMIT; <\/p>\n END IF; This script below will get the list of all inactive users and end date all the responsibilities assigned to them. Declare –cursor to get all inactive users CURSOR cur_inactive_user IS select fu.user_id, fd.responsibility_id, fd.responsibility_application_id, fd.security_group_id, fd.start_date, fd.end_date from fnd_user fu, fnd_user_resp_groups_direct fd where fu.user_id = fd.user_id and (fu.end_date <= sysdate or fu.end_date is NOT NULL) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1827","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n<\/p>\n
\n --cursor to get all inactive users
\n CURSOR cur_inactive_user
\n IS
\n select
\n fu.user_id,
\n fd.responsibility_id,
\n fd.responsibility_application_id,
\n fd.security_group_id,
\n fd.start_date,
\n fd.end_date
\n from
\n fnd_user fu,
\n fnd_user_resp_groups_direct fd
\n where
\n fu.user_id = fd.user_id
\n and (fu.end_date <= sysdate or fu.end_date is NOT NULL)
\n and fd.end_date is null;<\/p>\n
\nLOOP<\/p>\n
\n (rec_inactive_user.user_id,
\n rec_inactive_user.responsibility_id,
\n rec_inactive_user.responsibility_application_id,
\n rec_inactive_user.security_group_id)) then <\/p>\n
\n responsibility_id => rec_inactive_user.responsibility_id,
\n responsibility_application_id => rec_inactive_user.responsibility_application_id,
\n security_group_id => rec_inactive_user.security_group_id ,
\n start_date => rec_inactive_user.start_date ,
\n end_date => rec_inactive_user.end_date,
\n description => NULL); <\/p>\n
\nEND LOOP;
\nEND;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"