Planning ODS Load Worker Failing With ORA-1400 (VALUE = 'Discrete job')
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MSCPDCW - Planning ODS Load Worker
While running a complete refresh data collection, the MSCPDCW module: Planning ODS Load Worker, is failing with the following error:
COLUMN=ORDER_TYPE, VALUE=Discrete job
ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_XUC"."NEW_SCHEDULE_DATE"
- SUPPLIES_XUC - This temporary table is created during ODS load and uses XUC (the instance code) so this will be different depending on the instance code
- This error can occur for different types of supplies:
- For Purchase Orders - See <Note 730597.1>
- For PO In Receiving - See <Note 550531.1>
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