Planning ODS Load Worker Warning - ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_BIO"."NEW_SCHEDULE_DATE") (Doc ID 1289234.1)

Symptoms

Decentralized.
Source: 12.1.3       APS: 12.1.3
Upgraded both instances from 11.5.10.2  to 12.1.3 and they started to get this issue after the upgrade:

Run Complete Refresh Collection:

Steps:
Responsibility: GEEU SWE ASCP Super User
Collections> Standard Collections

ODS Load fails:

MSCPDCW module: Planning ODS Load Worker
18-JAN 20:09:59 : Procedure MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY started.
18-JAN 20:09:59 : load_supply
18-JAN 20:10:09 : Load supply: not found:
18-JAN 20:10:15 : OTHER========================================
18-JAN 20:10:15 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
18-JAN 20:10:15 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=17050000
18-JAN 20:10:15 : COLUMN=ORGANIZATION_CODE, VALUE=BIO:UPM
18-JAN 20:10:15 : COLUMN=ORDER_TYPE, VALUE=Work order
18-JAN 20:10:15 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_BIO"."NEW_SCHEDULE_DATE")
18-JAN 20:10:15 : OTHER========================================
18-JAN 20:10:15 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
18-JAN 20:10:15 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=17544200
18-JAN 20:10:15 : COLUMN=ORGANIZATION_CODE, VALUE=BIO:UPM
18-JAN 20:10:15 : COLUMN=ORDER_TYPE, VALUE=Work order
18-JAN 20:10:15 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_BIO"."NEW_SCHEDULE_DATE")

Changes

Migrated from 11.5.10 to 12.1

Cause

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