To create a user with the same UserID of a deleted User in OIM

Steps to Follow

1.Login to the OIM Design Console
2.Goto the Administration - System Configuration form
3.Search for the Keyword "XL.UserIDReuse" and set the value to TRUE(by default it will be false)

Login to database Machine which has User

Login to SQLPrompt and Execute the query

DROP INDEX UDX_USR_LOGIN;
create unique index UDX_USR_LOGIN_UNQ ON USR (USR_LOGIN, ACT_KEY, DECODE(USR_STATUS,'Active',USR_STATUS,TO_CHAR(USR_KEY)));