35 Oracle Reports

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