Planning ODS Load Failed With Error - ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE") (Doc ID 2791408.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

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

ERROR
-----------------------
ERROR while inserting PO Acknowledgment Records in MSC_SUPPLIES
ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")
08-JUL 01:24:30 : load supply other exception
08-JUL 01:24:30 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")
08-JUL 01:24:30 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")
08-JUL 01:24:30 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")
08-JUL 01:24:30 : Sending message :
  -9999999 to monitor.
08-JUL 01:24:30 : Error_Stack...
08-JUL 01:24:30 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")

08-JUL 01:24:30 : Error_Backtrace...
08-JUL 01:24:30 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 2341
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3833

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Collections

Cause

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