Unable To Login Into R12 Receive ICX_SESSION_FAILED

(Doc ID 558657.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Application Object Library - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Oracle Applications Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

On Oracle Applications Release 12.0:

Unable to log into Oracle Applications, and the following error occurs.

ERROR: You have encountered an unexpected error. Please contact the System Administrator for assistance.  Click here for exception details.


Exception Details:

oracle.apps.fnd.framework.OAException: Could not load application module
'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.

## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: ICX_SESSION_FAILED.

Refreshing the page leads to : Unable to authenticate session.

Changes

Guest user is end dated which can be checked using the Sqlplus below:

SQL> SELECT user_name,TO_CHAR(start_date,'DD-MON-YYYY'),TO_CHAR(end_date,'DD-MON-YYYY') FROM FND_USER WHERE user_name = 'GUEST';

USER_NAME|TO_CHAR(START_DATE,'DD-MON-YYYY')|TO_CHAR(END_DATE,'DD-MON-YYYY')
GUEST|27-NOV-1996|01-JAN-1951

Guest user is then enabled via Sqlplus by setting the end_date column to null.

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