My Oracle Support Banner

ORA-00001: Unique Constraint (RXC.RESPONSE_PK_IDX) Violated (Doc ID 466747.1)

Last updated on MAY 17, 2010

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 17-May-2010***


Batch Data load is failing.
The resulting log file contains the error:

ORA-00001: unique constraint (RXC.RESPONSE_PK_IDX) violated

how can this be corrected?


a) You are running OC 4.5.0

b) verified response_id sequence is over 10 digits via below query as DBA user:


select response_seq.nextval from dual;



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

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