45 Oracle Reports

This chapter describes issues associated with Oracle Reports. It includes the following topics:

45.1 General Issues and Workarounds

This section describes general issue and workarounds. It includes the following topic:

45.1.1 Output Image Format for PDF Reports with Graphs

PDF reports with Graphs may fail to open in Adobe Acrobat Reader in Oracle Reports if you specify PNG, JPG, or JPEG as the image output format either by using the outputimageformat command-line parameter or by using the REPORTS_OUTPUTIMAGEFORMAT environment variable.

By default, GIF is used as the output image format even if it is not explicitly specified. Therefore, use GIF as the output image format for PDF reports with graphs.

45.1.2 Mapping Users and Roles to Reports Application

In Oracle Fusion Middleware 11g Release 1 ( installations, roles and users are not added to the Reports application, by default. To run a report using JPS security, you must add roles and users to the Reports application.

For more information, see:

  • "Managing Application Roles" in the Oracle Fusion Middleware Security Guide

  • "Managing Users and Security Policies" in the Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services manual

45.1.3 Openmotif Library for SUSE Linux 11 Operating Systems

Before installing Oracle Reports 11g Release 1 (, ensure that the openmotif22-libs-2.2.4-138.17 library is installed on your machine. If this library is not installed, the installation of Oracle Reports fails.

You can download the library from the following location:


45.2 Documentation Errata

This section lists errors in the Oracle Reports documentation published on OTN.

45.2.1 Incorrect JSP Deployment Path

In Section 42.5 "Deploy the JSP Parameter Form and the Target Report" of the Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports, the JSP deployment path is incorrectly mentioned as $BEA_HOME\servers\WLS_REPORTS\stage\reports\reports\web.war.

The correct path is $DOMAIN_HOME\servers\WLS_REPORTS\tmp\_WL_user\reports_11.\dir_name\war.

Note that dir_name is a randomly generated directory name for each deployment instance.

45.2.2 Restriction on Horizontal Panels Per Page in a Matrix Report Produced in the ENHANCEDSPREADSHEET Format

For a matrix report, if the horizontal panels per page is set to a value higher than 1, running the report in the ENHANCEDSPREADSHEET output format would result in the following error:


You can set the horizontal panels per page to a value higher than 1 for a matrix report for all DESFORMATs except ENHANCEDSPREADSHEET.