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:

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

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