32 Oracle Reports

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

32.1 General Issues and Workarounds

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

32.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

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

http://ftp.novell.com/partners/oracle/sles-11/openmotif_FUSION_SLES11.tgz

32.1.3 Java Error May Occur When Accessing WLS_REPORTS Server

The java.lang.UnsatisfiedLinkError may occur when you access /reports/rwservlet of the WLS_REPORTS server.

The CLASSPATHSEP variable is set incorrectly in the setDomainEnv.sh file and the environmental variables that depend on the CLASSPATHSEP variable are set to incorrect paths. The libraries are not loaded and the Java error occurs.

Workaround

Set the CLASSPATHSEP variable in the setDomainEnv.sh file before the WLS_REPORTS block as follows:

export COMMON_COMPONENTS_HOME
CLASSPATHSEP=":"
export CLASSPATHSEP
 if [ "${SERVER_NAME}" = "WLS_REPORTS" ] ; then
....
....

32.1.4 Reports Weblayout not Supported on SUSE 10

As Mozilla Firefox is not supported on SUSE 10, Reports WebLayout is not certified with SUSE 10.