My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

Applies to:

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


On : 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.

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 <<

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.