3 Oracle Reports

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

3.1 Oracle Reports Deprecation Notice

Oracle Reports is deprecated. It is included in this 12.2.1 release, but will not be updated in future releases. Similar functionality may be obtained from Oracle BI Publisher.

3.2 General Issues and Workarounds

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

3.2.1 Use JDBC thin connection format in reports server configuration

When using database as job repository or job status repository, JDBC thick connection urls in reports server configuration files will not work. Instead use JDBC thin connection urls. If connection is of JDBC thick connection format <property value="dbSid" name="dbconn"/> change it to JDBC thin connection format, for example, <property value="example.com:dbport:dbSid" name="dbconn" />.

3.2.2 In 12.2.1, Reports Admin pages are not available in the Enterprise Manager

In 12.2.1 reports administration pages are not available in Enterprise Manager. As an alternative please use Oracle Reports Servlet and Enterprise Manager MBean browser for reports administration. For more details, refer to the chapter "Administering Oracle Reports Services Using Oracle Enterprise Manager" in Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services guide.

3.2.3 Reports not starting when length of Oracle Home path is more than 64 characters

Oracle Reports executables may not start when length of oracle home path is more than 64 characters in Windows platform. To fix the issue, apply ARU patch number 19380012.