MSCPPM Module: Pre-Process Monitor Error Ora-01418: Specified Index Does Not Exist
(Doc ID 1248550.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.1 and laterInformation 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)
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
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 |