My Oracle Support Banner

RS_Failure When Running A DCF Report (error ORA-01427) (Doc ID 1481065.1)

Last updated on MARCH 08, 2017

Applies to:

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


When running a DCF report for 2 specific DCFs in a specific study, the job does not run successfully: the job status is RS_FAILURE, and the log shows the following message:

  LOG :
  Report: d:\opapps45\oc\RXCDRPTL.rep
  Logged onto server: pr01
  Username: OPS$FESNEAG

  ERR ORA-01427: single-row subquery returns more than one row
  SELECT rownum , dcf_id_dnc dcf_id2 , q_line1_1 , q_line2_1 , q_line1_2 , q_line1_3 , q_line1_4 , q_line1_5 , discrepancy_entry_id_dnc discrepancy_entry_id , status_dnc s status , disc_rev , disc_type FROM pf_dcf.pf_DCF_RPT_DETAIL DD WHERE ( :dcf_id1 =
  ERR Error occurred sending Job output to cache

The PDF is not generated, however the status of the DCF is changed as required.

This is reproducible, but only for 2 specific DCFs. For other DCFs, there is no problem.


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.