My Oracle Support Banner

Loader Worker Failing With ORA-00911 On MSC_SYSTEM_ITEMS (Doc ID 2513648.1)

Last updated on JULY 07, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information 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


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