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 11.5.10.2 to 11.5.10.2.6 [Release 11.5.10]
Oracle Self-Service Web Applications - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
11i.ATG_PF.H.delta.5 (RUP 5)
Checked for relevance on 01-JUL-2012

Symptoms

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

Request URI: /OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.ExceptionInInitializerError


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;

STEPS TO REPRODUCE

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

WORKAROUND

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

BUSINESS IMPACT

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

Changes

You recently applied 11i.ATG_PF.H.delta.5 (RUP 5) following <Note 375682.1>.

Cause

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