This chapter describes issues associated with Oracle Reports. It includes the following topics:
This section describes general issue and workarounds. It includes the following topic:
Section 45.1.1, "Output Image Format for PDF Reports with Graphs"
Section 45.1.2, "Mapping Users and Roles to Reports Application"
PDF reports with Graphs may fail to open in Adobe Acrobat Reader in Oracle Reports 11.1.1.3.0 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.
In Oracle Fusion Middleware 11g Release 1 (11.1.1.3.0) 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
This section lists errors in the Oracle Reports documentation published on OTN.
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.1.1.2.0\
dir_name
\war
.
Note that dir_name
is a randomly generated directory name for each deployment instance.
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:
REP-1223: THE PAGE SIZE IS INVALID
You can set the horizontal panels per page to a value higher than 1 for a matrix report for all DESFORMATs
except ENHANCEDSPREADSHEET
.