My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Clinical - Version: 4.5.1 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Symptoms

In OC version 4.5.3, when attempting to Run a PDR in RDC PDF, 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 customer 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


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