JDE-VCP-DEM Integration: Collect Planning Data Errors With ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNER_SITES_U3) violated

(Doc ID 1950785.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

AIA 3.1 PIP
VCP 12.1.3.9.1

PROBLEM
-------------
We are using Oracle Support demo xml files to validate the PIP 3.1

We are getting this error when running Collect Planning Data concurrent request:

MSCE1TPSITECODE module: Update Trading Partner Sites
+---------------------------------------------------------------------------+
Current system time is 07-OCT-2014 16:05:13
+---------------------------------------------------------------------------+
**Starts**07-OCT-2014 16:05:13
**Ends**07-OCT-2014 16:05:13
TP_SITE_CODE Update failed
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
07-OCT 16:05:13 : Truncated tables t_src_sales_tmpl/item/loc.
07-OCT 16:05:13 : UPDATE msc_trading_partner_sites SET TP_SITE_CODE = LOCATION WHERE partner_type = 2 AND sr_instance_id = 2021
07-OCT 16:05:13 : ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNER_SITES_U3) violated
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

 

Point of Note:
1st run : runs success,
all successive runs fails.

 

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