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

Last updated on MARCH 09, 2012

Applies to:

Oracle Argus Safety - Version: 5.1.1 and later   [Release: 5.1 and later ]
Information in this document applies to any platform.

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.

Cause

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