Sol 1:
APPS User Locks After Manually Altering Password [ID 566127.1] for 12.0.4
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;
Sol 2:
APP-FND-01496 Error After Changing Apps And Applsys Users Using Alter User [ID 445153.1] for Release: 11.5.10 to 11.5.10 1.
Restore the FND_ORACLE_USERID and FND_USER tables from a backup.
2. Then run FNDCPASS to change the APPLSYS password.
FNDCPASS apps/apps 0 Y system/ SYSTEM APPLSYS WELCOME
Troubleshooting Guide For Login and Changing Applications Passwords [ID 1306938.1]
APPS User Locks After Manually Altering Password [ID 566127.1] for 12.0.4
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;
Sol 2:
APP-FND-01496 Error After Changing Apps And Applsys Users Using Alter User [ID 445153.1] for Release: 11.5.10 to 11.5.10 1.
Restore the FND_ORACLE_USERID and FND_USER tables from a backup.
2. Then run FNDCPASS to change the APPLSYS password.
FNDCPASS apps/apps 0 Y system/ SYSTEM APPLSYS WELCOME
Troubleshooting Guide For Login and Changing Applications Passwords [ID 1306938.1]
I am facing the same problem now in my test instance. I have restored FND tables from PROD instance, but still it is not working. in the second solution, while executing FNDCPASS which apps pwd should be used? I am not able to connect sql using restored FNDUSER pwd, but old apps pwd is working. Also clarify we need to execute autoconfig after FNDCPASS.
ReplyDeleteThanks
Good luck!
ReplyDelete