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

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Mar-2013***

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

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