How to Troubleshoot Login Issues After Changing <APPS_user> Password Using FNDCPASS Utility (Doc ID 809155.1)

Last updated on SEPTEMBER 10, 2023

Applies to:

Goal

This document has been consolidated into <Document 1306938.1>.

When attempting to start application services after changing <APPS_user> password using FNDCPASS utility the following error can be seen.

Error:
Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

From above error we can confirm that <APPS_user> password did not change correctly. Sometimes when you change <APPS_user> password using FNDCPASS utility and with new <APPS_user> password if you are able to login in SQLPLUS then you think that <APPS_user> password has changed correctly. But in every scenario, this is not true. If you are able to connect SQLPLUS with new <APPS_user> password then it doesn't verify new <APPS_user> password completely. It is just one test for new <APPS_user> password. If you are able to start application services successfully then only we can confirm that <APPS_user> password has changed successfully. You should not get above error if <APPS_user> password has changed successfully while starting application services.

You need to keep below points in your mind if you are changing <APPS_user> password using FNDCPASS utility:

1. Changing <APPS_user> password using "alter user" command is not supported and you should not use alter command to change <APPS_user> password in any case.

2. Always use FNDCPASS to change <APPS_user> password.

3. Before changing <APPS_user> password, it is strongly recommended to take a backup of FND_USER and FND_ORACLE_USERID.

4. Always check FNDCPASS log for any kind of error. If there is any error in FNDCPASS log then DONOT run autoconfig or try to change configuration file manually. Until and unless FNDCPASS log has no error please do not run autoconfig as you will get problem while logging in oracle application.

5. If you are getting any error in FNDCPASS log then either replace original backup with FND_USER and FND_ORACLE_USERID and then you can log in oracle application or raise a SR with FNDCPASS log.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.