My Oracle Support Banner

Error In Running PDR Report From RDC PDF (Doc ID 1288979.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

In OC version 4.5.3, when attempting to Run a PDR ( Patient Data Report) in RDC ( Remote Data Capture) , the following error occurs:

ERROR
-----------------------
ORA-01795: maximum number of expressions in a list is 1000

Workaround:
Printing one subject at a time seems to work, however we would like for the entire site to be in one report.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Log into RDC (not onsite)
On the Activities Screen, select a Site which has several subjects and pages (For example 12 subjects with a total of 1710 pages)
Click Show all Data for the site.
File->Reports
Select "Patient Data Report"
Select "Use current selections"
Select "Landscape"
Click OK
Leave all default options
Click Submit Job

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.