Planning ODS Load Completes with Warning (Doc ID 2082512.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Data Collections

Planning ODS load and worker goes in warning.

ERROR
-----------------------

MSCPDC: Planning ODS Load

25-NOV 13:45:28 : Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_TRADING_PARTNERS
25-NOV 13:45:28 : COLUMN=SR_TP_ID, VALUE=90
25-NOV 13:45:28 : COLUMN=ORGANIZATION_CODE, VALUE=UJA:SOF
25-NOV 13:45:28 : ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNERS_U3) violated
25-NOV 13:45:28 : ========================================

MSCPDCW: Planning ODS Load Worker

25-NOV 13:45:53 : OTHER========================================
25-NOV 13:45:53 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
25-NOV 13:45:53 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=FG-TE-00146
25-NOV 13:45:53 : COLUMN=ORGANIZATION_CODE, VALUE=
25-NOV 13:45:53 : COLUMN=ORDER_TYPE, VALUE=Intransit shipment
25-NOV 13:45:53 : ORA-01403: no data found
ORA-06512: at "APPS.MSC_CALENDAR", line 1131
ORA-01403: no data found
25-NOV 13:45:53 : OTHER========================================
25-NOV 13:45:53 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
25-NOV 13:45:53 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=RM-PW-00107
25-NOV 13:45:53 : COLUMN=ORGANIZATION_CODE, VALUE=
25-NOV 13:45:53 : COLUMN=ORDER_TYPE, VALUE=Purchase order
25-NOV 13:45:53 : ORA-01403: no data found
ORA-06512: at "APPS.MSC_CALENDAR", line 1131
ORA-01403: no data found



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Standard Data Collections

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run collection and follow business requirements.

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