MSCPLD - Loader Worker With Direct Load Option Finish With Warning - Error Shown Is Invalid Index
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.
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
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.
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
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