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 DECEMBER 03, 2019
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.2 and later
Information in this document applies to any platform.
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document