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

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Common Application Components - Version 12.0.0 and later
Oracle Receivables - Version 12.0.0 and later
Oracle Application Object Library - Version 12.0 and later
Oracle Incentive Compensation - Version 12.0.0 and later
Information in this document applies to any platform.
Checked for relevance 14-Aug-2014
AK - Oracle Common Modules - Version: 12.0

Symptoms

Whilst running Replicate Seed Data process with NULL as a parameter for all Operating Units the following error is encountered:

 

ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (CN.CN_PERIOD_TYPES_U1)
violated:ad_morg.replicate_table_data_bulk(CN_PERIOD_TYPES_ALL,-3113):INSERT INTO CN_PERIOD_TYPES_ALL (PERIOD_TYPE_ID, PERIOD_TYPE,
ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE, LAST_UPDATED_BY, SECURITY_GROUP_ID, ORG_ID) SELECT /*+ ordered no_expand parallel(a) */ PERIOD_TYPE_ID,
PERIOD_TYPE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE,
LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, LAST_UPDATED_BY, SECURITY_GROUP_ID, V.ORGANIZATION_ID FROM CN_PERIOD_TYPES_ALL A, (SELECT /*+
no_merge */ ORGANIZATION_ID FROM fnd_product_groups, hr_operating_units WH

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