46 Oracle Reports

46.1.1 Mapping Users and Roles to Reports Application

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

46.2.1 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:

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.

46.2.2 Errors in the Oracle Fusion Middleware Oracle Reports User's Guide to Building Reports

Note the following corrections to the content 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 first paragraph of the section contains the following sentence:

  "For testing purposes, however, you can use the Oracle WebLogic Server instance shipped with the Oracle Developer Suite."

  Ignore this sentence. The Oracle Developer Suite does not exist in 11g.

• Steps 1 and 2 refer to the following as the deployment directory:

  $BEA_HOME\servers\WLS_REPORTS\stage\reports\reports\web.war
  

  This path is incorrect. The following is the correct path:

  $DOMAIN_HOME\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.1.2.0\dir_name\war
  

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