ATP Data Collection Planning ODS MSCPDCW Load Worker Fails MSC_CL_RPO_ODS_LOAD ORA-00920 ORA-06512 (Doc ID 1307141.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to Run ATP Data Collections MSCPDCW module: Planning ODS Load Worker got the following error.

14-JAN 10:33:18 : Procedure MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND started.
14-JAN 10:33:18 : <>
14-JAN 10:33:18 : ORA-00920: invalid relational operator
14-JAN 10:33:18 : ORA-00920: invalid relational operator
14-JAN 10:33:18 : ORA-00920: invalid relational operator
14-JAN 10:33:18 : Sending message :-9999999 to monitor.
14-JAN 10:33:18 : Error_Stack...
14-JAN 10:33:18 : ORA-00920: invalid relational operator

14-JAN 10:33:18 : Error_Backtrace...
14-JAN 10:33:18 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3013
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3232




STEPS:
1. Run ATP Data collections

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