My Oracle Support Banner

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 AUGUST 09, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.