SQL Loader Worker Of Memory Based Planner Aborting - Showing SQL*Loader-2026

(Doc ID 2335820.1)

Last updated on DECEMBER 05, 2017

Applies to:

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

Symptoms

12.2.5
with patch 26976609 - Cum patch #13

PROBLEM
-------------
In first plan run since upgrade to 12.2.5 with Cum patch #13 -- we are seeing error in loader worker

MSCPLD: Loader Worker With Direct Load Option
Parent Program Name: MSONWL64
This IS part of a Plan run.
Check the revised columns in MSC.MSC_DEMANDS:
  order_number#1 order_number
Selecting REVISED COULMNS 1 0:00
Username:SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
....
One or more indexes on table MSC.DEMANDS1472 are invalid. Please check the SQL*loader error and take corrective action.

STEPS
--------
Run ASCP plan after upgrade

BUSINESS IMPACT
----------------------
cannot continue testing ASCP plans after upgrade

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