MSCPLD - Loader Worker With Direct Load Option Finish With Warning - Error Shown Is Invalid Index (Doc ID 2191920.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

On 12.2.4 Memory Based Planner in Production:

Users are running an ASCP plan.  However 2 of the 12+ Loader workers that run during planning is finishing with WARNING during plan run with message about partitioned indexes

MSCPLD: Loader Worker With Direct Load Option


ERROR
=====
One or more indexes on table [TEMP_TABLE_NAME||PLAN_ID] are invalid. Please check the SQL*loader error and take corrective action.

One or more indexes on table MSC.FULL_PEGGING1 are invalid. Please check the SQL*loader error and take corrective action.
One or more indexes on table MSC.RESOURCE_REQUIREMENTS1 are invalid. Please check the SQL*loader error and take corrective action.


STEPS
--------
1.  Run ASCP plan
2.  Observed the some Loader workers will finish with Warning >> NOT Error - AND KEY POINT >>>>> The Memory Based planner did not fail - and all other requests finish OK



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