MSCPDCW Planning Ods Load Errors With Warnings Ora-00001 And Ora-01400 Intermittently PROCEDURE=ADD_NEW_IMPL_ITEM_ASL (Doc ID 409011.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
EXECUTABLE:MSCPDCW - Planning ODS Load Worker

Symptoms

When running data collections after applying RUP#13 (data collections) MSCPDCW module: Planning ODS Load Worker ends with a warning but each time it's on a different item/organization:

Error in PROCEDURE=ADD_NEW_IMPL_ITEM_ASL, TABLE=MSC_ITEM_SUPPLIERS
COLUMN=ITEM_NAME, VALUE=ATMSW16632
COLUMN=ORGANIZATION_CODE, VALUE=ERP:US
ORA-00001: unique constraint (MSC.MSC_ITEM_SUPPLIERS_U1) violated


Also MSCPDC module: Planning ODS Load ends with a warning with the same information every time:

Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_PARTNER_CONTACTS
COLUMN=PARTNER_ID, VALUE=
COLUMN=PARTNER_SITE_ID, VALUE=
COLUMN=PARTNER_TYPE, VALUE=2
ORA-01400: cannot insert NULL into ("MSC"."MSC_PARTNER_CONTACTS"."PARTNER_ID")


STEPS:
1. Apply Collections RUP#13
2. Run data collections
3. Review log files

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