When Adding Placebo to a Study Configuration and Saving, An ORA-01422 Error Is Returned (Doc ID 1405454.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The following error occurs when attempting to add a who drug (Placebo) to a study configuration

Error:
Following exception has occurred: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_BUS_CONFIG", line 6325
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_BUS_CONFIG", line 1671
ORA-06512: at line 1

Steps to Repeat:
1. Argus Console > Business Configuration > Studies
2. Select or create a study.
3. Under the study products section, click on the add WHO DRUG button, search for Placebo, select a returned record and click on select.
4. Save the study configuration.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.