Duplicate response records are logged in the Oracle Clinical database
(Doc ID 750324.1)
Last updated on JULY 01, 2020
Applies to:Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.
Checked for Relevance on 01-Feb-2019
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 the 'ORA-1427: single-row subquery returns more than one row' error.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!