GLLEZL Import WebADI Journal Get ORA-00001: Unique Constraint (GL.GL_DOC_SEQUENCE_AUDIT_U1) Violated (Doc ID 2028707.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import

Symptoms

On : 11.5.10.2 version, Journal Import

When running Journal Import to import data from WebADI, for a specific set of books, Journal Import completes in error:
 
ERROR
-----------------------
ORA-00001: unique constraint (GL.GL_DOC_SEQUENCE_AUDIT_U1) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upload from webadi
2. run journal import

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