Planning Data Collection Failed In Planning Ods Load with ORA-00920 (Doc ID 1309581.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

When attempting to perform Planning ODS Load the following error occurs.

Procedure MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND started.
ORA-00920: invalid relational operator
ORA-00920: invalid relational operator
Sending message :-9999999 to monitor.
Error_Stack...
ORA-00920: invalid relational operator

Error_Backtrace...
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3054
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3273

 

Steps:
1. (R) Order Management
2. (N) Scheduling / ATP Data Collection
3. Inspect the Planning ODS Load worker log files to observe the error

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