JDE-VCP Integration - ORA-00001: Unique Constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) Violated (Doc ID 2180389.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.6 and later
Information in this document applies to any platform.

Symptoms

12.2.5 in Test


PROBLEM
-------------
Client is getting the following error when we run collection for all planning entities (or) running collection for ship methods.


+---------------------------------------------------------------------------+

**Starts**06-AUG-2016 15:34:17
**Ends**06-AUG-2016 15:34:17
ORA-00001: unique constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) violated
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
06-AUG 15:34:37 : Purge Batch Size is set to : .
06-AUG 15:34:37 : Initialized the Pipes for IPC
06-AUG 15:34:37 : Schema : APPS
06-AUG 15:34:37 : RAC_ENABLED value 2
06-AUG 15:34:37 : Get Pipe :MSC_CL_TQ2021
06-AUG 15:34:37 : sucess_flag :0
06-AUG 15:34:37 : Message :2
06-AUG 15:34:37 : Worker receiving return code : 0
06-AUG 15:34:37 : Worker Task Unpacked : 2
06-AUG 15:34:37 : Calling Execute Partial Task for task number: 2
06-AUG 15:34:37 : MSC_DL_TASK_START_PARTIAL (PROCEDURE=MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING)
06-AUG 15:34:37 : ORA-00001: unique constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) violated
06-AUG 15:34:37 : ORA-00001: unique constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) violated
06-AUG 15:34:37 : Send Pipe :MSC_CL_WM2021
06-AUG 15:34:37 : sucess_flag :0
06-AUG 15:34:37 : Message :-9999999
06-AUG 15:34:37 : Sending message :
  -9999999 to monitor.
06-AUG 15:34:37 : Send Pipe :MSC_CL_ST2021
06-AUG 15:34:37 : sucess_flag :0
06-AUG 15:34:37 : Message :1
06-AUG 15:34:37 : Error_Stack...
06-AUG 15:34:37 : ORA-00001: unique constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) violated

06-AUG 15:34:37 : Error_Backtrace...
06-AUG 15:34:37 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3680
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3905

STEPS
--------
JDE - VCP collection

BUSINESS IMPACT
----------------------
Unable to create sourcing rule without shipping methods and run plan.

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