R12 E-Business Suite Login Fails with HTTP 500 Internal Server Error And Applications.log Show Error 'ORA-00604: error occurred at recursive SQL level 1 ORA-01438: value larger than specified precision allowed for this column' (Doc ID 2225615.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Applications Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications Technology Stack,  SSO/OID and Access Manager issues

 



When attempting to login in to E-Business Suite applications the following error occurs:


HTTP 500 Internal Server Error

Checking the applications.log file the following additional error messages will appear:

java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 5


The issue can be reproduced at will with the following steps:
1. Try to open page AppsLocalLogin.jsp.


The issue has the following business impact:
Due to this issue, users cannot login

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