GUEST user and all other front end users password are not working at the same time
Hi All,
We had issue in our PROD instances that all users were not able to login into instance and getting below error messages. Not even taking to Login page and getting error.
ajp12: Servlet Error: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_LOGIN_FAILED
here are the actions we have taken to solve the issue.
------------------------------------------------------------------------------
- First we have checked DBC files and password is correct as we have default password.
- conext file also have same default password
- then tried to validate the password in Database as below and result was "N"