ODS Load Finishes With Warning and Error Shown In Log File is ORA-01400: cannot insert NULL (Doc ID 1326182.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 27-Nov-2015 ***

Symptoms

When attempting to launch ASCP data collections, planning ODS load is failing with error:

Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE= [item name here]
COLUMN=ORGANIZATION_CODE, VALUE= [org code here]
COLUMN=ORDER_TYPE, VALUE=Purchase Order
ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_NA"."NEW_SCHEDULE_DATE")  -- note the NA in SUPPLIES_NA  is the Instance Code setup in Instances form



STEPS:
1. Responsibility : Advanced supply chain planning
2. Navigation : Supply chain panning > Collections > Oracle systems > Standard collection
3. Planning ODS load fails with error

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