My Oracle Support Banner

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

Last updated on AUGUST 20, 2018

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

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
Changes
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.