The Discrepancy History Report completes with: "REPORT FOUND NO DATA" while there should be data on this report (Doc ID 2157668.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Clinical - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Symptoms

The Discrepancy History Report completes for a Study with: "REPORT FOUND NO DATA" while there should be data on this report. Yet a query in the database for a specific Study and Patient returns records:

select count(*)
from rxc.discrepancy_entries de
,rxc.discrepancy_entry_Review_hist h
where patient_position_id = 2362201
and de.discrepancy_entry_id = h.discrepancy_entry_id;

Or:

select *
from discrepancy_management
where patient = '5001'
and clinical_study_id = 2401;

 

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