R12 E-Business Suite Login Page Is Blank With The Following Error In the Log 'Unable to create anonymous session. Your session is no longer valid. Oracle error 20001: java.sql.SQLException' (Doc ID 2193325.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications Technology Stack, HTTP Server for Applications Technology Login issues

 

 

Users receive a blank page when attempting to access the applications login page.

After further investigation the guest users account is not correct as the following errors appear in the oacore application.log:

Could not initialize class oracle.apps.fnd.common.Guest

Attempts to validate the guest user with the following sql fail:

1. SQL> select fnd_vault.get('FND', '****') from dual;

2. SQL> select fnd_web_sec.validate_login('GUEST','****') from dual;

Other messages received may also include the following:

Unable to create anonymous session. Your session is no longer valid. Oracle error 20001: java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, FND_CONTEXT.INIT, N, ERRNO, -1031, N, REASON, ORA-01031:


 

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