'742400' Error appears when trying to Retire a DCI Form Version.
(Doc ID 2100243.1)
Last updated on MAY 03, 2020
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 which only has batch loaded data collected (i.e. version_sn is null for all the CRFs entered into the 'RXC.RECEIVED_DCIS' table for this particular DCI) then the following error occurs.
742400: Cannot set the status to Retired. No data has been collected using this DCI form version.
In this case the following query returns with a count greater than 0: SELECT COUNT(*) FROM RXC.received_dcis WHERE dci_id = &dci_id;
and the following query returns 0 for the count: select count(*)
from rxc.received_dcis rdci,
where rdci.dci_id = &dci_id
and rdci.version_sn = &version_sn
and dcifv.dci_id = rdci.dci_id
and dcifv.version_sn = rdci.version_sn
and dcifv.fl_status = 'A'
and dcifv.language = 'en_US';
The 742400 error is returned when:
- user is in TEST Mode
- production data has been entered for the DCI/Form Version that has to be retired (i.e. the two above mentioned queries both return data).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!