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!


In this Document
Symptoms
Cause
Solution


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.