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

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