Planning ODS Load Worker Fails with ORA-01452 OPERATION_RESOURCES_U1_XXX (Doc ID 2308053.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Data Collections, the following error occurs in the Planning ODS Load/Worker (MSCPDC/MSCPDCW)...

ERROR
-----------------------

15-SEP 14:01:57 : Unique index violated - OPERATION_RESOURCES_U1_TST
15-SEP 14:01:57 : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
15-SEP 14:01:57 : ======= Below records violate the unique constraint =======
15-SEP 14:01:57 : PLAN_ID -1 / SR_INSTANCE_ID 21 / ROUTING_SEQUENCE_ID 188 / OPERATION_SEQUENCE_ID 332 / RESOURCE_SEQ_NUM 10 / RESOURCE_ID 1118 / ALTERNATE_NUMBER 0 / NEW_PLAN_ID / SIMULATION_SET_ID

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Collections

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