My Oracle Support Banner

'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.

Symptoms

SCENARIO 1:
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.

ERROR
--------
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,
         dci_form_versions dcifv
  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';

 

SCENARIO 2:
The 742400 error is returned when:

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.