My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.