ASCP Plan Failing At Memory Based Planner With Unique Constraint MSC_SUPPLIES Error
(Doc ID 2311668.1)
Last updated on AUGUST 14, 2018
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!