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

Last updated on JANUARY 27, 2011

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

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