Unable To Retire DCIs With Batch Loaded Data
Last updated on JANUARY 26, 2016
Applies to:Oracle Clinical - Version 4.6.6 and later
Information in this document applies to any platform.
When attempting to retire a DCI Form with only has batch loaded data collected, the following error occurs.
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';
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