RXASTMQC Creating A New Study Throws: Ora-1422: Exact Fetch Returns Too Many Rows
Last updated on MAY 12, 2009
Applies to:Oracle Clinical - Version: 4.0.3 to 4.5.3
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.
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 hundreds of Community platforms