We use OIM only for managing external users.
Users often call the call center and due to issues with the user profile on OIM, rep needs to delete the user id so that user can sign up for the same user id again.
This throws an error that says user already exists in the database. Upon querying the database it is seen the record is not deleted, only its status has been changed to 'Deleted', thus preventing the user from signing up with the same user id again.
Is there a permanent fix to this situation? Why does Oracle not allow to delete and re create records at will?