My Oracle Support Banner

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

Last updated on JULY 14, 2021

Applies to:

Oracle General Ledger - Version 11.5.8 and later
Information in this document applies to 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

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.