My Oracle Support Banner

ASCP Plan Failing At Memory Based Planner With Unique Constraint MSC_SUPPLIES Error (Doc ID 2311668.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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


On : 12.2.3 version, Memory Based Planner

ASCP Plan failing at Loader Worker With Direct Load with Unique Constraint error on MSC_SUPPLIES

ASCP is being used with integration to Oracle Production Scheduling. After publishing a schedule from Production Scheduling, the ASCP plan run is failing at the Loader Worker With Direct Load Option stage.

For 5 days, the full integrated cycle ran with no issues. On the sixth day, the ASCP errors every time after publishing from Oracle Production scheduling.

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

The issue can be reproduced at will with the following steps:
1. Launch Production Scheduling: Production Scheduler > Production Scheduler> Launch
2. Open the PS Workbench and perform scheduling Production Scheduler > Production Scheduler > Workbench
3. Approve and publish the PS schedule. SCP Integration concurrent request launches, as a result of publishing, and completes successfully.
4. Launch ASCP plan.
5. ASCP Plan fails


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.