Planning ODS Load Worker Completes With Warning, but Many ORA-00001 Errors Exists MSC_SOURCING_RULES_U2, MSC_SR_SOURCE_ORG_N1, and MSC_SR_RECEIPT_ORG_N1 (Doc ID 2181791.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Service Parts Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Installation Issues

Planning ODS Load process shows errors:

MSCPDCW: Planning ODS Load Worker completes with Warning and shows the following errors:


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

Procedure MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING started.
========================================
Error in PROCEDURE=LOAD_SOURCING, TABLE=MSC_SOURCING_RULES
COLUMN=SOURCING_RULE_NAME, VALUE=PURCH_69199
ORA-00001: unique constraint (MSC.MSC_SOURCING_RULES_U2) violated
========================================
Error in PROCEDURE=LOAD_SOURCING, TABLE=MSC_SR_SOURCE_ORG
COLUMN=SR_SR_SOURCE_ID, VALUE=69407
ORA-00001: unique constraint (MSC.MSC_SR_SOURCE_ORG_N1) violated
========================================
Error in PROCEDURE=LOAD_SOURCING, TABLE=MSC_SR_RECEIPT_ORG
COLUMN=SR_RECEIPT_ID, VALUE=76581
ORA-00001: unique constraint (MSC.MSC_SR_RECEIPT_ORG_N2)

 

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