My Oracle Support Banner

Planning ODS Load Completes with Warning (Doc ID 2082512.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

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
-----------------------
1. Run Standard Data Collections

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


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