My Oracle Support Banner

ASCP Constrained W/o DS Fails When SS Planned For, APP-FND-01564:mrfsaf_flush_safety_stock (Doc ID 1995993.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


PROBLEM
-------------
When running ASCP on 12.2.4.1 version, Planning mode is Constrained without DS.
Profile MSC: Respect Minimum remaining shelf life = Yes.

When  "plan safety Stocks" is set up for the plan, the plan is failing.

Plan failing with the below error:
APP-FND-01564: ORACLE error 1 in mrfsaf_flush_safety_stock

Cause: mrfsaf_flush_safety_stock failed due to ORA-00001: unique constraint (MSC.MSC_SAFETY_STOCKS_U1) violated
.

The SQL statement being executed at the time of the error was: insert into msc_safety_stocks (inventory_item_id,organization_id,plan_ and was executed from the file .
Total memory usage: 132179

STEPS
--------
Launch ECC Constrained without DS.
Profile MSC: Respect Minimum remaining shelf life = Yes.


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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.