My Oracle Support Banner

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

Last updated on MARCH 03, 2022

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.

or

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 :

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.