Targeted Collection Error - Duplicate Keys Found
Last updated on MARCH 09, 2018
Applies to:
Oracle Supply Planning Cloud Service - Version 11.13.17.09.0 and laterInformation in this document applies to any platform.
Symptoms
When running targeted collection the following errors are seen in one of the Load Entity logs:
ERROR
The Load Entity process started with refresh number xxxxxx.
Number of records copied from ODS to Temp = 0
MSC_ITEM_STRUCTURES
ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "FUSION.ADM_FUSION_DDL", line 490
ORA-06512: at "FUSION.MSC_COLL_PARTITIONS", line 613
Exchange partition failed for table : MSC_ITEM_STRUCTURES
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-06512: at "FUSION.MSC_COLL_PARTITIONS", line 1075
ORA-06512: at "FUSION.MSC_COLL_BOMS", line 1825
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-06512: at "FUSION.MSC_COLL_BOMS", line 1911
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1056
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1069
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 2196
STEPS TO REPRODUCE
1. Run Targeted Collections.
2. See the errors in the Load Entity log file
Changes
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