Planning ODS Load Workers Failed With ORA-00001: Unique Constraint on MSC.MSC_NET_RESOURCE_AVAIL_U1 (Doc ID 2194146.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

While running Data Collections , Planning ODS Load Worker completes with the following message in error

MSCPDCW module: Planning ODS Load Worker
+---------------------------------------------------------------------------+

13-OCT 18:47:42 : CALLING POPULATE_ORG_RESOURCES
========================================================
Populating Org Resources for the Org: 223
========================================================
 Populating Org Resources for Null Simulation Set ......
--------------------------------------------------------
 Populating Available Resources.........................
--------------------------------------------------------
 Populating Org Resources for the Simulation Set :XXXXXXXXXXX
--------------------------------------------------------
 Populating Available Resources.........................
--------------------------------------------------------
Error::(80)::-1:ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U1)
13-OCT 18:50:46 : ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U1) violated
13-OCT 18:50:46 : Planning ODS Load process failed to calculate the resource availability.
13-OCT 18:50:46 : User-Defined Exception
13-OCT 18:50:46 : User-Defined Exception
13-OCT 18:50:46 : Sending message :
  -9999999 to monitor.
13-OCT 18:50:46 : Error_Stack...
13-OCT 18:50:46 : ORA-06510: PL/SQL: unhandled user-defined exception

13-OCT 18:50:46 : Error_Backtrace...
13-OCT 18:50:46 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 2340
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3832

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

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