Warning Status in Calculate Resource Availability - Log File Shows ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U2) (Doc ID 2171371.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

VCP 12.1.3.9.1 in Production

Legacy Collections


PROBLEM
-------------
MSCCLRES module: Calculate Resource Availability
+---------------------------------------------------------------------------+

Current system time is 08-JUL-2016 03:59:42

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

**Starts**08-JUL-2016 03:59:43
**Ends**08-JUL-2016 04:00:17
Planning ODS Load process failed to calculate the resource availability.
+---------------------------------------------------------------------------+

Error::(60)::-1:ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U2)
Error::(60)::-1:ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U2)
Error::(60)::-1:ORA-00001: unique constraint (MSC.MSC_NET_RESOURCE_AVAIL_U2)

STEPS
--------
Launch complete collection with Calculate Resource Availability.

BUSINESS IMPACT
----------------------
Planning ODS Load process failed to calculate the resource availability.

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