My Oracle Support Banner

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

Last updated on AUGUST 13, 2018

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

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.