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;
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.
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.