Skip Headers
Oracle® Fusion Middleware Release Notes
11g Release 1 (11.1.1) for AIX Based Systems (64-Bit)

Part Number E14771-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

35 Oracle Reports

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

35.1 General Issues and Workarounds

This section describes the general issues and their workarounds.

35.1.1 Associating SSL Port of OID Using Enterprise Manager

While installing Oracle Reports 11g Release 1 (11.1.1), you can specify whether an OID port is SSL-enabled. However, in the Reports-OID Reassociation page in Enterprise Manager, you cannot view, associate, deassociate, or reassociate OID that was configured during the installation to use the SSL port.

35.1.2 Configuration Changes Made Using Enterprise Manager to a Mail Server That Is Not Secure

After you make any changes from Enterprise Manager Reports server basic and advanced configuration pages, the mail server configuration element entry is impacted. The commented child elements of mail server configuration elements are removed from the rwbuilder.conf and rwserver.conf configuration files. As a result, running a job to a mail destination fails. This problem occurs only when you use a mail server that is not secure. For example, the following error message may appear on the browser when the job is submitted through rwservlet:

COULD NOT CONNECT TO SMTP HOST: LOCALHOST, PORT: 25: SENDING MAIL

To work around this problem, add an entry for the child element of the mail server in the rwbuilder.conf and rwserver.conf configuration files manually and comment out the entry, as shown in the following example:

<pluginParam name="mailServer" value="aaa.bbb.com">
    <!--property name="enableSSL" value="yes"/-->
</pluginParam>

35.2 Interoperability Issues and Workarounds

This section describes interoperability issues and their workarounds. It includes the following topics:

35.2.1 Interoperability between Reports 11g Server and Reports 10.1.2.3 Client

This interoperability scenario requires the patch 7597820 to be installed. You can download this patch from http://updates.oracle.com/download/7597820.html. This patch is required to address the CORBA IDL changes between the two releases for the Job Status information. If you want to use rwservlet of Reports 10g Release 2 (10.1.2.3) with the Reports 11g Release 1 (11.1.1) Server, ensure that you install this patch on 10.1.2.3 installation. You can download this patch from http://metalink.oracle.com.

35.3 Documentation Errata

This section describes documentation errata. It includes the following topic:

35.3.1 Default value of XML PROLOG VALUE for multibyte reports

The default value of the report object property XML PROLOG VALUE for multibyte reports is not correct in the online Help for Reports.The default value is documented as <?xml version="1.0"?>. However, the default value is <?xml version="1.0" encoding="&Encoding"?>.

35.3.2 Granting Access to RWbuilder

Section "Granting Access to RWbuilder" in the Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services has some missing steps. In addition to the chmod commands documented in the section, you must run the following commands on the command line:

  • chmod 750 $ORACLE_HOME/bin/rwbuilder

  • chmod 750 $ORACLE_HOME/modules/oracle.dms_11.1.1/*.jar

  • chmod 750 $ORACLE_HOME/modules/oracle.odl_11.1.1/*.jar

  • chmod 750 $ORACLE_INSTANCE/config/reports

  • chmod 750 $ORACLE_INSTANCE/config/reports/bin

  • chmod 750 $ORACLE_INSTANCE/config/reports/bin/rwbuilder.sh

  • chmod 750 $ORACLE_INSTANCE/reports

  • chmod 750 $ORACLE_INSTANCE/reports/reports_install.properties