APPS User Locks After Manually Altering Password (Doc ID 566127.1)

SYMPTOMS

On 12.0.4 Changed APPS password and cannot login.

The issue can be reproduced at will with the following steps:
Changed the apps pwd using

alter user command instead of FNDCPASS

CAUSE

Apps password was manually changed. Changing the password manually is a security breach and will corrupt the passwords.

SOLUTION

To implement the solution, please execute the following steps:

1. Backup the FND_USER, FND_ORACLE_USERID tables.
2. Change the password in the following sequence.

SQL> alter user applsys identified by apps;
SQL> alter user apps identified by apps;
SQL> alter user apps account unlock;