MSCPCP: ASCP to RP Plan Copy Fails with ORA-00001 Running MSCPLD (Doc ID 2057798.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Rapid Planning - Version 12.2.4 and later
Information in this document applies to any platform.
MSCPCP
MSCPLD

Symptoms

Using Rapid Planning / ASCP to RP Plan Copy
On VCP 12.2.4.1:
When attempting to copy an ASCP plan to an RP plan
the following error occurs in MSCPLD: Loader Worker With Direct Load Option

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

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