My Oracle Support Banner

Planning ODS Loader Worker Fails With ORA-00920 in MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS (Doc ID 1335540.1)

Last updated on APRIL 04, 2025

Applies to:

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

Symptoms

When attempting to run Data Collections the following error occurs in the Planning ODS Load Worker

01-JUL 16:57:55 : Procedure MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS started.
01-JUL 16:57:55 : <trc 16:57:55>st:Initialize_Schema_PVT
01-JUL 16:57:55 : <trc 16:57:55>en:Initialize_Schema_PVT
01-JUL 16:57:55 : <trc 16:57:55>st:EXCHANGE_SINGLE_TAB_PARTN MSC_ST_DELIVERY_DETAILS
01-JUL 16:57:55 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_1 WITH TABLE DELIVERY_DETAILS_PRD
01-JUL 16:57:55 : <trc 16:57:55>en:EXCHANGE_SINGLE_TAB_PARTNMSC_ST_DELIVERY_DETAILS
01-JUL 16:57:55 : ORA-00920: invalid relational operator
01-JUL 16:57:55 : ORA-00920: invalid relational operator
01-JUL 16:57:55 : Sending message :-9999999 to monitor.
01-JUL 16:57:55 : Error_Stack...
01-JUL 16:57:55 : ORA-00920: invalid relational operator

01-JUL 16:57:55 : Error_Backtrace...
01-JUL 16:57:55 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 2042
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3281

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.