Planning ODS Loader Worker Finishes With Warning and Log Shows Error for "Discrete Job" - ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_R12"."NEW_SCHEDULE_DATE")
(Doc ID 352824.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.9 and laterInformation in this document applies to any platform.
EXECUTABLE:MSCPDCW - Planning ODS Load Worker
Symptoms
When running a Data Collections, the MSCPDCW - Planning ODS Load Worker finished with Warning and the log shows the following error:
Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
COLUMN=ITEM_NAME, VALUE=[Item Name]
COLUMN=ORGANIZATION_CODE, VALUE=[org code]
COLUMN=ORDER_TYPE, VALUE=Discrete job
ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_xxx"."NEW_SCHEDULE_DATE" -- xxx is the instance code for Data Collections
COLUMN=ITEM_NAME, VALUE=[Item Name]
COLUMN=ORGANIZATION_CODE, VALUE=[org code]
COLUMN=ORDER_TYPE, VALUE=Discrete job
ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_xxx"."NEW_SCHEDULE_DATE" -- xxx is the instance code for Data Collections
Notes:
- SUPPLIES_xxx- This temporary table is created during ODS load and uses the instance code -- so this value will be different depending on the instance code
- This error can occur for different types of supplies - please see references below in case other entities have same ORA-1400 error during LOAD_SUPPLY
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |