No Available Organizations To Assign For The Responsibilities In ASCP
(Doc ID 1447028.1)
Last updated on JULY 25, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation in this document applies to any platform.
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 |