My Oracle Support Banner

Planning ODS Load Worker Ends With Warning and Message ORA-1400 (VALUE = 'Purchase order') (Doc ID 730597.1)

Last updated on NOVEMBER 01, 2023

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

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

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