This content has been marked as final. Show 18 replies
You cannot delete a responsibility. You can only end -date a responsibility.Goto System Administrator responsibility>user>define>query the user and end-date the system administrator responsibility.
There is no way to delete the responsibility. Either you set "End Date" as posted above by Anmol, or use the following API to end date it:
if (fnd_user_resp_groups_api.assignment_exists( x.user_id, x.responsibility_id, x.RESPONSIBILITY_APPLICATION_ID)) then fnd_user_resp_groups_api.update_assignment( user_id => x.user_id, responsibility_id => x.responsibility_id, responsibility_application_id => x.RESPONSIBILITY_APPLICATION_ID, start_date => x.start_date, end_date => sysdate, description => null); end if;
Thanks to all. Can I delete (drop) user ?
Can I delete (drop) user ?No. Instead, set "End Date" for that user.
so astonished by the limites of Oracle Applications !!!
so astonished by the limites of Oracle Applications!!!Applications users cannot be deleted since records belonging to users are kept for security and monitoring purposes. In addition, the user is recorded in Who columns, so deleting would cause foreign table data integrity problems.
Yes, it is possible to delete an user as well as a responsibility.
You have to do this from backend ,from fnd_user and fnd_responsibilty tables.
BUT IT IS NOT RECOMMENDED BY ORACLE AS EXPLAINED BY HUSSEIN.
so astonished by the limites of Oracle Applications !!!I know it seems like a limitation but it's actually a good thing as hsawwan describes. For auditing/security purposes you would not want to be able to delete users or responsibilities in a production system.
You can drop a custom database user, but not an apps user...at least legally. :-)
Kevin, it is nice to hear from you again :)
Thanks! I've been busy with a large implementation we have going on and have been neglecting the forums.
You sure do a great job with answering these questions!!
Cheers - Kevin
Thanks Kevin :)
Since oracle is maintaining id based records ,
Whether renaming a user is recommended or not ?
Whether renaming a user is recommended or not ?It should be ok since FND_USER.USER_ID would be the same.
Is it possible to end date an indirect responsibility? I have been trying to this but receive the below error?
ERROR at line 1:
ORA-20001: Oracle error -20002: ORA-20002: 4016: User/Role relationship for
user 'JBLOGGS' and role 'FND_RESP|PER|XX_FEX_RESP_02|STANDARD' already exists.
has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 29
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 841
ORA-06512: at line 48