My Oracle Support Banner

Replicate Seed Data For Colombia Ends In Error - ORA-20000: ORA-00001: Unique Constraint (JL.JL_ZZ_AR_TX_ATT_VAL_U1) (Doc ID 1399733.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Release 12.1

Attempting to run the Replicate Seeded Data for Colombia for Columbia Operating Unit and receive the following error:

ERROR
-----------------------
declare
*
ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (JL.JL_ZZ_AR_TX_ATT_VAL_U1)
violated:ad_morg.replicate_table_data(JL_ZZ_AR_TX_ATT_VAL_ALL,2320):INSERT INTO JL_ZZ_AR_TX_ATT_VAL_ALL (TAX_CATEG_ATTR_VAL_ID,
TAX_CATEGORY_ID, TAX_ATTRIBUTE_TYPE, TAX_ATTRIBUTE_NAME, TAX_ATTRIBUTE_VALUE, DEFAULT_TO_CLASS, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
TAX_ATTR_VALUE_CODE, ORG_ID) SELECT TAX_CATEG_ATTR_VAL_ID, TAX_CATEGORY_ID, TAX_ATTRIBUTE_TYPE, TAX_ATTRIBUTE_NAME,
TAX_ATTRIBUTE_VALUE, DEFAULT_TO_CLASS, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,
ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,

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.