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 09, 2016

Applies to:

Oracle Clinical - Version: 4.0.3 to 4.5
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

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