How To Resolve the Error "ORA-00001: unique constraint (SYSADM.PS_CM_DRILL_MAP) violated" when Installing a Bundle or Maintenance Pack (Doc ID 779082.1)

Last updated on AUGUST 12, 2016

Applies to:

PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
Information in this document applies to any platform.
This Knowledge Document applies also to Cost Management releases >= 8.8 SP1

***Checked for relevance on 25-Jul-2013***

Goal

The following unique constraint violation error is given when running a dms script as part of the installation of a Bundle or a Maintenance Pack:

Importing CM_DRILL_MAP

Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 805 -
ORA-00001: unique constraint (SYSADM.PS_CM_DRILL_MAP) violated

Failed SQL stmt:INSERT INTO PS_CM_DRILL_MAP (TRANSACTION_GROUP, FROM_PANELNAME,
CM_DRILL_ACTION, TO_PANELNAME, MENUNAME, BARNAME, ITEMNAME, KEYCOUNT, KEY1, KEY2, KEY3, KEY4,
KEY5, KEY6, KEY7, KEY8, KEY9, KEY10, KEY11, KEY12, KEY13, KEY14, KEY15, KEY16) VALUES (:1, :2, :3,
:4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, : (200,0)

 

The above is known to occur when installing the following Bundles and Maintenance Packs or translation versions:

Solution

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