Oracle Fusion : Deleting the User
Is it possible to delete the user in Fusion?
One can't delete user completely unless you are deleting just after creating user and before running the LDAP request. Once the LDAP process runs, no chance of deleting it.
update usr set usr_login = usr_login || '-deleted' , usr_first_name = usr_first_name || '-deleted', usr_last_name = usr_last_name || '-deleted' , usr_ldap_dn = usr_ldap_dn || '-deleted' , usr_ldap_guid = usr_ldap_guid || '-deleted', usr_common_name = usr_common_name || '-deleted' , usr_email = usr_email || '-deleted' where USR_STATUS='Deleted';
'
commit;
Run scheduled process in Fusion Application to synchronize the deletion to Fusion Application Database
1) Log to Fusion Application
2) Click Navigator -> Tools : Scheduled Process
3) Click Schedule New Process
4) Search for process retrieve latest LDAP changes and run it.
. After running the scheduled process in (above) all the deleted user records will become inactive in the Fusion Database.
1) Log in to Fusion Application Database2) Run following sql commands
delete from per_users where active_flag = 'N'
delete from per_user_roles pur where not exists (select null from per_users pu where pu.user_id = pur.user_id)
delete from per_user_history pur where not exists (select null from per_users pu where pu.user_id = pur.user_id)
delete from per_user_roles pur where not exists (select null from per_users pu where pu.user_id = pur.user_id)
delete from per_user_history pur where not exists (select null from per_users pu where pu.user_id = pur.user_id)
