Plan Calculation Fails If Safety Stock Enabled

(Doc ID 2314151.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information 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

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