RXASTMQC Creating A New Study Throws: Ora-1422: Exact Fetch Returns Too Many Rows
(Doc ID 261149.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Clinical - Version 220.127.116.11 to 4.5.3 [Release 4.0.0 to 4.5.3]
Information in this document applies to any platform.
This problem can occur on any platform.
RXASTMQC - Easy Study Design
After defining the Study Details in Easy Study Design,
Open OC Design > Study > Easy Study Design.
Choosing study name, project, program code, and so on...
you attempt to save the study pressing F10 or by clicking the [Save] button then the error message is displayed at the bottom left of the screen:
ORA-01422: Exact fetch returns too many rows
To check for duplicates which could cause this problem do the following. Run the following query from
a sqlplus session against this database as the RXC user:
WHERE REF_CODELIST_NAME = 'DX_CONFIG'
AND REF_CODELIST_VALUE_SHORT_VAL = 'KEY_TEMPLATE'
AND TEMPLATE_TYPE = 'KEY'
AND NAME = LONG_VALUE;
If this returns more than on key template with the same name you are experiencing this issue.
Next confirm if one of these duplicate names has been set as the default KEY_TEMPLATE
NAV: OC: Admin > Reference Codelists > Installation Codelists > F7 to Enter a query
> Query the codelist named 'DX_CONFIG' > Check the value entry for KEY_TEMPLATE.
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