Planning ODS Load Worker Completed In Error - ORA-01400: cannot insert NULL into ("MSC"."DEMANDS_aaa"."USING_ASSEMBLY_DEMAND_DATE") (Doc ID 2285315.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

Any release

PROBLEM
-------------
Planning ODS Load Worker completed in error. I have attached the log files.

The Many unique constraint errors are just warnings. We still have those in Production.
The actual error is the below one.
ORA-01400: cannot insert NULL into ("MSC"."DEMANDS_aaa"."USING_ASSEMBLY_DEMAND_DATE")  
>>> aaa will be the instance code used in ASCP setup  / Instances form

STEPS
--------
Run standard data collections

EXPECTED BEHAVIOR
----------------------------
will not fail

BUSINESS IMPACT
----------------------
cannot run data collections in this TEST instance

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