Planning ODS Load Worker Failing With ORA-1400 (VALUE = 'Purchase order')
Last updated on APRIL 12, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.
EXECUTABLE:MSCPDC - Planning ODS Load
EXECUTABLE:MSCPDCW - Planning ODS Load Worker
When attempting to run the data collection, the following error occurs during the Planning ODS Loader Worker run.
15-JUN 14:32:22 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
15-JUN 14:32:22 : COLUMN=ITEM_NAME, VALUE=B-PT5286
15-JUN 14:32:22 : COLUMN=ORGANIZATION_CODE, VALUE=PRD:103
15-JUN 14:32:22 : COLUMN=ORDER_TYPE, VALUE=Purchase order
15-JUN 14:32:22 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_PRD"."NEW_SCHEDULE_DATE")
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