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 25, 2017

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

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