Oracle Script to Copy Responsibilities of one user account to another user account
fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Please find below the pl/sql block using fnd_user_pkg.addresp API /******************************************************************************* *PURPOSE: To copy responsibilities of one oracle user account to another oracle user account * *AUTHOR: Oracle Apps Pie * *******************************************************************************/ -- -- DECLARE -- resp_count NUMBER := 0; CURSOR src_user_resp_details IS SELECT DISTINCT fa.application_short_name, fr.responsibility_key , fsg.security_group_key, furga.end_date FROM apps.fnd_application fa , apps.fnd_responsibility fr , apps.fnd_user fu , apps.fnd_user_resp_groups_all furga, apps.fnd_security_groups fsg WHERE 1 = 1