My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.1 and later
Information in this document applies to any platform.

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

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


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