APP-FND-0156 Cause: AFPCOA failed due to ORA-28000: the account is locked

APP-FND-01564: ORACLE error 28000 in AFPCOA

Cause: AFPCOA failed due to ORA-28000: the account is locked

Solution:
Apps account is locked please unlock the apps account and if needed increase the profile option FAILED_LOGIN_ATTEMPTS in the database if/to appropriate.

conn system/passwd
select username,status from dba_users where username='APPS'

APPS  locked

SQL> Alter username apps account unlock;

change failed_login_attempts:

SQL> alter profile default limit failed_login_attempts 10;

Profile altered.

SQL> exit