Error Adding New Responses Entry(2).Msg:ORA-00001: Unique Constraint (RXC.RESPONSE) While Running Batch Validation

(Doc ID 884545.1)

Last updated on APRIL 13, 2011

Applies to:

Oracle Clinical - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.


-- Problem Statement:
On 4.5.0 in Production:
When running the Batch Validation process in OC,
the following error occurs in the Batch Log:

Indicator Question Checks for Patients with modified data
0 new, 0 remain current, 0 became obsolete
Batch Validation aborted due to an error
Error adding new responses entry(2).Msg:ORA-00001: unique constraint (RXC.RESPONSE_PK_IDX) violated

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Logon to OC
2) Select Study
3) Run Batch Validation


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