My Oracle Support Banner

No Available Organizations To Assign For The Responsibilities In ASCP (Doc ID 1447028.1)

Last updated on NOVEMBER 04, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-OCT-2013***

Goal


There's no Available Organizations to assign for the responsibilities in ASCP.


And we are getting Warning in ODS Load with ORA-00001

MSCPDC module: Planning ODS Load
28-MAR 18:12:28 : Procedure MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER started.
28-MAR 18:12:29 : ========================================
28-MAR 18:12:29 : Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_TRADING_PARTNERS
28-MAR 18:12:29 : COLUMN=SR_TP_ID, VALUE=380
28-MAR 18:12:29 : COLUMN=ORGANIZATION_CODE, VALUE=FRM:P22
28-MAR 18:12:29 : ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNERS_U3) violated
28-MAR 18:12:29 : ========================================
28-MAR 18:12:29 : Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_TRADING_PARTNERS
28-MAR 18:12:29 : COLUMN=SR_TP_ID, VALUE=381
28-MAR 18:12:29 : COLUMN=ORGANIZATION_CODE, VALUE=FRM:P09
28-MAR 18:12:29 : ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNERS_U3) violated
28-MAR 18:12:29 : ========================================
28-MAR 18:12:29 : Error in PROCEDURE=LOAD_TRADING_PARTNER, TABLE=MSC_TRADING_PARTNERS
28-MAR 18:12:29 : COLUMN=SR_TP_ID, VALUE=382
28-MAR 18:12:29 : COLUMN=ORGANIZATION_CODE, VALUE=FRM:P44
28-MAR 18:12:29 : ORA-00001: unique constraint (MSC.MSC_TRADING_PARTNERS_U3) violated



Solution

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
Goal
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.