Module RXCCGLCG generates ERR REP-1401: 'cf_descriptionformula': Fatal PL/SQL error occurred. ORA-01427: single-row subquery returns more than one row (Doc ID 1310386.1)

Last updated on APRIL 06, 2011

Applies to:

Oracle Clinical - Version: 4.0.3 and later   [Release: 4 and later ]
Information in this document applies to any platform.

Symptoms

Given a copy group of a GLIB domain, include in the copy group an active validation procedure with at least two versions and submit the module RXCCGLCG (Glib -> Glib Reports -> Copy Groups).

The job will fail with the following error:


"ERR REP-1401: 'cf_descriptionformula': Fatal PL/SQL error occurred. ORA-01427: single-row subquery returns more than one row"


This issue was reported on all versions from pre 4.0 up to 4.6

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