MSCPCP: ASCP to RP Plan Copy Fails with ORA-00001 Running MSCPLD
(Doc ID 2057798.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Rapid Planning - Version 12.2.4 and later
Information in this document applies to any platform.
Using Rapid Planning / ASCP to RP Plan Copy
On VCP 126.96.36.199:
When attempting to copy an ASCP plan to an RP plan
the following error occurs in MSCPLD: Loader Worker With Direct Load Option
Record 1: Rejected - Error on table "MSC"."MSC_INTERORG_SHIP_METHODS#".
ORA-00001: unique constraint (MSC.MSC_INTERORG_SHIP_METHODS_U1) violated
-- Steps To Reproduce:
Customer states the issue can be reproduced at will at customer site with the following steps:
1. copy ASCP plan MSI-EDD to RP plan RP-EDD-BSE
2. Observe that the MSCPCP: Purge Copy Plan concurrent program log file
identifies an error in a request corresponding to
MSCPLD: Loader Worker With Direct Load Option
which contains the noted error.
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