Planning ODS Load Worker Failing With ORA-1400 (VALUE = 'Purchase order') (Doc ID 730597.1)

Last updated on JUNE 28, 2017

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

Symptoms

When attempting to run the data collection, the following error occurs during the Planning ODS Loader Worker run.

ERROR
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")

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