MSCPDCW module, Planning ODS Load Worker: Error in PROCEDURE=LOAD_OPERATION_RESOURCES, TABLE=MSC_OPERATION_RESOURCES, ORA-00001: unique constraint (MSC.OPERATION_RESOURCES_U1...) violated
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MSCPDCW - Planning ODS Load Worker
Planning data collections is run for the first time. The planning ODS load worker ends in a warning. The log shows the following error:
TABLE=MSC_OPERATION_RESOURCES COLUMN=ROUTING_SEQUENCE_ID,VALUE=1046 COLUMN=OPERATION_SEQUENCE_ID,VALUE=2274
ORA-00001: unique constraint (MSC.OPERATION_RESOURCES_U1_EMG) violated
Is the MSC_OPERATION_RESOURCES "affected" (corrupted?).
Verified the issue by the log file <l200476_req.txt >.
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