My Oracle Support Banner

Planning ODS Load Worker In Error ORA-00936: Missing Expression (Doc ID 2908901.1)

Last updated on APRIL 27, 2023

Applies to:

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


When attempting to run the Data Collections, the following error occurs in the Planning ODS Load/Worker (MSCPDC/MSCPDCW)...

Index creation on Temp Supplies table successful.
Procedure LOAD_ODS_SUPPLY started.
The sql statement is INSERT INTO SUPPLIES_TEX SELECT * from MSC_SUPPLIES WHERE sr_instance_id = 1 AND plan_id = -1 AND order_type NOT IN ( ) AND organization_id NOT IN (15545,22075) UNION ALL SELECT * from MSC_SUPPLIES WHERE sr_instance_id = 1 AND plan_id = -1 AND organization_id not IN (15545,22075) AND order_type IN ( )
ORA-00936: missing expression
ORA-00936: missing expression
ORA-00936: missing expression
Sending message :-9999999 to monitor.

The issue can be reproduced at will with the following steps:
1. Responsibility:  Advanced Supply Chain Planner
2. Navigation:  Collections > Oracle Systems > Standard Collections
3. When entering the parameters for the Planning Data Pull, the Collection Method entered is Complete Refresh, but the only entity set to Yes is Items.

The issue has the following business impact:
Due to this issue, users cannot access the collection results or run the plan.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.