Journal Import GLLEZL Errors with ORA-00001 GL.GL_JE_HEADERS_U2 (Doc ID 2217965.1)

Last updated on DECEMBER 27, 2016

Applies to:

Oracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run journal import the following error occurs.

 

This only occurs when there are some duplicate journal name data in GL_INTERFACE table.
Journal Import Process rename journal name if there are duplicate journal name.
But in this case, the renamed journal name are also duplicated.


ex.)

This case, the journal is foreign currency journal and has different value in CURRENCY_CONVERSION_DATE.
30-APR-16
30-APR-15
30-JUN-16
30-JUN-15
If journal import truncate the end of value "30-A" and "30-J" for journal name like following , this error is occurred.

123456789012345678901234567890123456789012345678901234567890123456789 Adjustment USD Corporate 30-A
123456789012345678901234567890123456789012345678901234567890123456789 Adjustment USD Corporate 30- 2
123456789012345678901234567890123456789012345678901234567890123456789 Adjustment USD Corporate 30-J
123456789012345678901234567890123456789012345678901234567890123456789 Adjustment USD Corporate 30- 2



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