Planning ODS Loade Worker Fails With ORA-920 in MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS

(Doc ID 1335540.1)

Last updated on JUNE 28, 2017

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

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