Tuesday, September 13, 2011

Locked User in EBS R12

Today one of users complaining about failed login. Using user administration I found that the user's status is 'LOCKED'. It was the first time I met this problem. The question was how to unlock the user?
After searching Oracle Support with no result, I opened the FND_USERS table and found that the value for ENCRYPTED_FOUNDATION_PASSWORD and ENCRYPTED_USER_PASSWORD for locked users are INVALID.
So I changed the password from the applications and then LOCKED status disappeared.