46 Oracle Reports

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

46.1 General Issues and Workarounds

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

46.1.1 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

46.1.2 Configuration Fails While Starting WLS_Reports Server

While starting managed weblogic server, WLS_REPORTS, configuration fails showing the following errors:

The input line is too long.
The syntax of the command is incorrect.

This occurs when user creates MW_HOME, ORACLE_HOME and domain directory with long names. Consequently the value for environment variable like JAVA_OPTIONS and CLASSPATH become very long, and the actual command for starting the WLS_REPORTS Managed Server exceeds the windows command maximum limit of 8191 characters.

To work around this issue, use short names for ORACLE_HOME, MW_HOME and domain directory on windows.

46.2 Documentation Errata

This section lists errors in the Oracle Reports documentation published on OTN. It includes the following topics:

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:


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:


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


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