My Oracle Support Banner

FNDSECURITY_APPL_LOGIN_FAILED Error and Cannot Login Since RUP5 (Doc ID 458064.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Applications Framework - Version to [Release 11.5.10]
Oracle Self-Service Web Applications - Version to [Release 11.5.10]
Information in this document applies to any platform. (RUP 5)
Checked for relevance on 01-JUL-2012


Have recently upgraded to (RUP 5) (<Patch 5473858>) and now get an error when you try to navigate to the login page:

Request URI: /OA_HTML/AppsLocalLogin.jsp

If you run the "Verify DBC Settings" test in AOL/J Diagnostic Tests
(http://<hostname>:<port>/OA_HTML/jsp/fnd/aoljtest.jsp) you get the following result under the "Checking guest user/password" heading:

oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_LOGIN_FAILED

If you check the GUEST username/password through the following methods it appear to be OK:

  1. Looking at the GUEST_USER_PWD variable in $FND_TOP/secure/<SID>_<hostname>/<SID>.dbc

  2. Executing the following SQL (returns a result of Y):

    select fnd_web_sec.validate_login('GUEST','<PASSWORD FROM DBC FILE>') from dual;


Try to login via http://<hostname>:<port>/servlets/AppsLogin or http://<hostname>:<port>/OA_HTML/AppsLocalLogin.jsp


Users can login directly to Forms via http://<hostname>:<port>/dev60cgi/f60cgi.


Users cannot log in to Oracle Applications via the web interface.


You recently applied (RUP 5) following <Note 375682.1>.


To view full details, 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 a vibrant support community of peers and Oracle experts.