MSCPCP: ASCP to RP Plan Copy Fails with ORA-00001 Running MSCPLD

(Doc ID 2057798.1)

Last updated on DECEMBER 18, 2017

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


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