My Oracle Support Banner

R12 Upgrade: File b7373688.ldt Fails with ORA-00001: Unique Constraint (GL.GL_JE_SOURCES_TL_U3) Violated (Doc ID 1240844.1)

Last updated on MARCH 29, 2022

Applies to:

Oracle General Ledger - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
b7373688.ldt


Symptoms

While upgrading an environment to 12.0 or later, the adworker process stops due to a failure while loading the records into GL_JE_SOURCES table.

The adworker log file contains the following error:

Error loading seed data for GL_JE_SOURCES: JE_SOURCE_NAME = AutoCopy, ORA-00001: unique constraint (GL.GL_JE_SOURCES_TL_U3) violated
ORA-06512: at "APPS.GL_JE_SOURCES_PKG", line 213
ORA-06512: at "APPS.GL_JE_SOURCES_PKG", line 526
ORA-01403: no data found

Changes

Customer created a custom journal source.

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
 Still Have Questions?
References


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