ASCP Plan Fails When IO Plans Are Provided As Demand Schedule (Doc ID 2277595.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Inventory Optimization - Version 12.1.3.9.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9.2 version, Installation/Configuration

ASCP plan is failing when IO plans are fed as Demand schedules. IO plans are run for Safety stock calculations and those plans are fed to ASCP plan to consider in supply planning. ASCP plan fails with below error.


ERROR
-----------------------
ORA-00001: unique constraint (MSC.MSC_SAFETY_STOCKS_U1) violated  << KEY ERROR <<


APP-FND-01388: Cannot read value for profile option RPM_CONC_PROCESS_ID in routine &ROUTINE.   << ALWAYS IGNORE THIS ERROR <<



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run MSCPLD module: Loader Worker With Direct Load Option

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