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 18.104.22.168 and later
Information in this document applies to any platform.
This problem can occur on any platform.
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.
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