How to Troubleshoot Login Issues After Changing APPS Password Using FNDCPASS Utility
Last updated on SEPTEMBER 01, 2017
Applies to:Oracle Application Object Library - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Oracle E-Business Suite Technology Stack - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
This document has been consolidated into <Document 1306938.1>.
When attempting to start application services after changing APPS password using FNDCPASS utility the following error can be seen.
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 password did not change correctly. Sometimes when you change APPS password using FNDCPASS utility and with new APPS password if you are able to login in SQLPLUS then you think that APPS password has changed correctly. But in every scenario, this is not true. If you are able to connect SQLPLUS with new APPS password then it doesn't verify new APPS password completely. It is just one test for new APPS password. If you are able to start application services successfully then only we can confirm that APPS password has changed successfully. You should not get above error if APPS password has changed successfully while starting application services.
You need to keep below points in your mind if you are changing APPS password using FNDCPASS utility:
1. Changing APPS password using "alter user" command is not supported and you should not use alter command to change apps password in any case.
2. Always use FNDCPASS to change APPS password.
3. Before changing APPS 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms