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.


In OC version 4.5.3, when attempting to Run a PDR in RDC PDF, the following error occurs:

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

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.
Select "Patient Data Report"
Select "Use current selections"
Select "Landscape"
Click OK
Leave all default options
Click Submit Job


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

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