MSCPCP: ASCP to RP Plan Copy Fails with ORA-00001 Running MSCPLD
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.
Using Rapid Planning / ASCP to RP Plan Copy
On VCP 184.108.40.206:
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