Journal Import Errors Out with EU02 While Journal Import Reports More Lines to be Imported than Available in gl_interface
(Doc ID 300801.1)
Last updated on APRIL 18, 2025
Applies to:
Oracle General Ledger - Version 11.5 to 12.1.3 [Release 11.5.0 to 12.1]Information in this document applies to any platform.
This problem can occur on any platform.
EXECUTABLE:GLLEZL - Journal Import
Symptoms
Running Journal Import, one or more than one Journal Import requests error out with EU02.
The Total Lines as per Journal Import Execution Report are more than the actual number of lines in the gl_interface table. e.g. As per Execution Report you find that there are 123 lines, whereas query that you run on gl_interface returns only 122 lines.
Also find that the entered_dr and entered_cr are matching and are same as the accounted_dr and accounted_cr.
There is no prima facie reason for getting an EU02 error.
Sample log file looks something like this: gllcje shows 123 lines
> />gllcje() 04-MAR-2005 10:26:34
SHRD0108: Retrieved 170 records from gl_je_categories
SHRD0079: 123 record(s) inserted into gl_je_lines
SHRD0118: Updated 123 record(s) in table: GL_INTERFACE
SHRD0108: Retrieved 123 records from GL_INTERFACE
<< gllcje() 04-MAR-2005 10:26:39
but in gllups you find the number of lines are different gllups shows only 122 lines
> />gllups() 04-MAR-2005 10:26:39
SHRD0118: Updated 30 record(s) in table: GL_INTERFACE
SHRD0118: Updated 19 record(s) in table: GL_INTERFACE
SHRD0118: Updated 47 record(s) in table: GL_INTERFACE
SHRD0118: Updated 26 record(s) in table: GL_INTERFACE
<< gllups() 04-MAR-2005 10:26:39
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |