ORA-00001 Unique Constraint (MSC.MSC_SUPPLIES_U1) Violated When Running Online Replan (Doc ID 1098073.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-April-2013***

Symptoms

On : 12.1 version, Memory Based Planner
When attempting to run online replan #1, the Online Planner spins off requests 390847 - 390856 (all successful).
On the second iteration #2, the following error occurs.

ERROR
-----------------------
Record 1: Rejected - Error on table MSC.MSC_SUPPLIES.
ORA-00001: unique constraint (MSC.MSC_SUPPLIES_U1) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner Responsibility
2. Launch ASCP Plan
3. Start Online Planner
4. Run Online Replan
5. Stop and Start Online Planner
6. Run Online Replan again (for the same plan)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run online replan on the same plan for more than once.

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