My Oracle Support Banner

Replicate Seed Data Errors With ORA-20000: ORA-00001: unique constraint (CN.CN_HEAD_HIERARCHIES_ALL_TL_U2) (Doc ID 1104023.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Whilst running Replicate Seed Data the following error is encountered:

ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (CN.CN_HEAD_HIERARCHIES_ALL_TL_U2)
violated:ad_morg.replicate_table_data(CN_HEAD_HIERARCHIES_ALL_TL,2):INSERT INTO CN_HEAD_HIERARCHIES_ALL_TL (HEAD_HIERARCHY_ID,
DIMENSION_ID, NAME, LANGUAGE, SOURCE_LANG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
SECURITY_GROUP_ID, ORG_ID) SELECT HEAD_HIERARCHY_ID, DIMENSION_ID, NAME, LANGUAGE, SOURCE_LANG, CREATION_DATE, CREATED_BY,
LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID, :X_target_org_id FROM CN_HEAD_HIERARCHIES_ALL_TL A WHERE
NVL(ORG_ID, -99) = nvl(:X_source_org_id, -99) AND NOT (ORG_ID = -3114 AND :X_target_org_id IS NOT NULL) AND NOT EXISTS ( SELECT
NULL FROM CN_HEAD_HIERARCHIES_ALL_TL WHERE NVL(ORG_ID, -99) = NVL(:X_target_org_id, -99) AND HEAD_HIERARCHY_ID =
A.HEAD_HIERARCHY_ID AND LANGUAGE = A.LANGUAGE)
ORA-06512: at line 9



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.