Loader Worker Failing With ORA-00911 On MSC_SYSTEM_ITEMS
(Doc ID 2513648.1)
Last updated on APRIL 01, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.2 version, Memory Based Planner
The Loader Worker with Direct Load is failing with the following message:
ERROR
-----------------------
Error message:
"Check the revised columns in MSC.MSC_SYSTEM_ITEMS:
Selecting REVISED COULMNS 0:00
ORA-00911: invalid character
ORA-06512: at "SYSTEM.AD_DDL", line 210
OMSCSLD : Error in main 103 : table_name_str MSC_SYSTEM_ITEMS 36024
Error string=
Statement with the error:
declare lv_temp_ind_nxtext number ; lv_deg_parallel number ; lv_index_"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner
2. Supply Chain Plan
3. Launch
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 |
| References |