Plan Calculation Fails If Safety Stock Enabled
(Doc ID 2314151.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Memory Based Planner
Plan calculation fails if Safety Stock enabled
A Manufacturing Plan completes in error if the flag "Plan Safety Stock" is checked in the Plan Options (tab Organizations)
The Memory Based Planner fails with an error "APP-MRP-22100: Request 39464014 failed", corresponding to a 'Loader Worker With Direct Load Option' failing with the following error message:
------------------------------------------------------------------------------------------
Record 9: Rejected - Error on table MSC.MSC_SAFETY_STOCKS#.
ORA-00001: unique constraint (MSC.MSC_SAFETY_STOCKS_U1) violated
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
------------------------------------------------------------------------------------------
The plan completes normal if the option "Plan Safety Stock" is not checked.
ERROR
-----------------------
ORA-00001: unique constraint (MSC.MSC_SAFETY_STOCKS_U1) violated
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner
2. Supply Chain Plan
3. Launch
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 |
| References |