MSCPPM Module: Pre-Process Monitor Error Ora-01418: Specified Index Does Not Exist (Doc ID 1248550.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

MSCPPM module: Pre-Process Monitor gets the following error:

01-OCT 14:35:44 : *************** WARNINGS DURING PRE-PROCESSING ****************
01-OCT 14:35:44 : 1. Table Name: MSC_ST_DEMANDS, Number of Occurences: 41, Warning: The value provided for DEMAND_TYPE is invalid. This has been defaulted to 1
01-OCT 14:35:44 :                  **********************
01-OCT 14:35:44 :  
01-OCT 14:35:44 : Error dropping Index MSC_ST_SO_N2_XXX. Error:ORA-01418: specified index does not exist
01-OCT 14:35:44 : Error dropping Index MSC_ST_SO_N3_XXX. Error:ORA-01418: specified index does not exist
01-OCT 14:35:45 : MSC_PP_WORKER_REQUEST_ID (REQUEST_ID=555060)

 

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