ORA-00001: Error when Trying to Re-enter a DCI with Two DCMs when One DCM was Soft Deleted
Last updated on DECEMBER 09, 2016
Applies to:Oracle Clinical - Version: 4.0.3 to 4.5
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
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