GLLEZL Journal Import Erroring with ORA-6502 or ORA-00001 in GLLCBH (Doc ID 293780.1)

Last updated on NOVEMBER 18, 2008

Applies to:

Oracle General Ledger - Version: 11.5.8
This problem can occur on any platform.
EXECUTABLE:GLLEZL - Journal Import
gllcbh - Create journal Batches

Symptoms

While running GLLEZL module: Journal Import, receive the following error

Error in: gllcbh
Function return status: 0
Function Err Message: Executing bch_prep
Function warning number: -1
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode:  -6502  sqlerrml: 70
sqlerrmc:
ORA-06502: PL/SQL: numeric or value error: character to number convers

Or

sqlcaid:   sqlabc: 0 sqlcode: -1 sqlerrml: 60
sqlerrmc:
ORA-00001: unique constraint (GL.GL_JE_BATCHES_U2) violated SHRD0014:
GLLEZL - process exiting with failure

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