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 laterInformation 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 |