My Oracle Support Banner

ORA-00001: Error when Trying to Re-enter a DCI with Two DCMs when One DCM was Soft Deleted (Doc ID 152803.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Clinical - Version 4.0.3.49 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

 

Inconsistent DCM status with a soft deleted DCI. 
There is one DCI with two DCMS. The DCI was deleted and has a status of REMOVED 
and its end_ts was updated to the soft delete date, but one of the two DCMS has 
status Pass 2 Complete instead of REMOVED and is end_ts is still 15-AUG-01.
As a result, when you try to re-enter the RDCI the following error is returned:

ORA-00001: Unique constraint (RXC.RECEIVED_DCM_UK2_IDX) violated.


In addition the document cannot be hard delete since it will not show up in the 
corresponding LOV.

Cause

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.