Unable To Retire DCIs With Batch Loaded Data

(Doc ID 2100243.1)

Last updated on JANUARY 26, 2016

Applies to:

Oracle Clinical - Version 4.6.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to retire a DCI Form with only has batch loaded data collected, the following error occurs.

ERROR
-----------------------
742400: Cannot set the status to Retired. No data has been collected using this DCI form version.

The following query returns with a count greater than 0:
SELECT COUNT(*)
FROM   received_dcis
WHERE  dci_id = &dci_id;
However, the following query returns 0 for the count:
SELECT COUNT(*)
FROM   received_dcis rdci, dci_form_versions dcifv
WHERE  rdci.dci_id = &dci_id
AND    rdci.version_sn = dcifv.version_sn
AND    dcifv.fl_status  = 'A';

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