Duplicate response records are logged in the Oracle Clinical database (Doc ID 750324.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Clinical - Version 4.5.1 and later
Oracle Clinical Remote Data Capture Option - Version 4.5.1 and later
Information in this document applies to any platform.

Goal

There are a few circumstances in which duplicate response records are logged in the Oracle Clinical database, causing subsequent problems with the affected CRF from RDC and possibly from batch validation.
The Patient Data Report can also fail with:

'ORA-1427: single-row subquery returns more than one row' error.

Error getting data for RDCI: rdciId=111xxxx01 userRole=DM
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RXC.RDC_REPORT_XML_GENERATION", line 505
ORA-06512: at "RXC.RDC_REPORT_XML_GENERATION", line 2092
ORA-06512: at line 1

There are 2 different 'duplicate response' symptoms :

Problem Type A - Duplicate Responses with same response ID
Problem Type B - Duplicate Responses with different response IDs

Solution

	To view full details, 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 a vibrant support community of peers and Oracle experts.

Duplicate response records are logged in the Oracle Clinical database (Doc ID 750324.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!