I am running Oracle6i Reports. What version of Oracle Reports should I migrate to?
I am running Oracle9i Application Server Release 1. Do I need to migrate to a newer version?
How do I buy Oracle Reports 10g?
What migration steps are necessary to upgrade my existing reports to Oracle Reports 10g?
Has the upgrade process changed in Oracle Reports 10g Release 2 (10.1.2)?
Prior to Oracle Reports 10g Release 2 (10.1.2), during the upgrade process, those Oracle Reports configuration files that were listed as upgrade items were copied from the previous installation to the new installation, and, if the file names clashed, the files in the new installation were over-written. For example, the textpds.conf file in the 10g (9.0.4) installation was over-written with the textpds.conf file copied from the previous installation.
In the new upgrade process for Oracle Reports 10g Release 2 (10.1.2), if the file names clash, the file names in the new installation are changed to *.preupgrade before copying upgrade files from the previous installation. The files in the new installation are not over-written. For example, the textpds.conf file of the 10.1.2 installation will be renamed to textpds.conf.preupgrade before copying the textpds.conf file from the previous installation. This provides you an opportunity to open the *.preupgrade files, and copy any 10.1.2-specific configuration parameters from these files.
After the above upgrade process is complete, you need to perform the following steps manually:
Step 1: Change the following files in your 10.1.2 installation to preserve your custom configuration (these files are not copied from your previous installation):
Step 2: Modify the in-process server name in targets.xml to the name you were using in your previous installation. This is necessary because the default in-process server name has changed from rep_hostname to rep_hostname_oraclehome in Oracle Reports 10g Release 2 (10.1.2).
Step 3 (Windows only): Define or change all Reports-related registry entries to preserve your custom configuration, for example, REPORTS_PATH. These registry entries are not copied from your previous installation.
Refer to Oracle Application Server Reports Services Publishing Reports to the Web for more information on the above files and registry entries.
Oracle Application Server Upgrade and Compatibility Guide for more information on the upgrade process.
Yes, selected features have been depreceted and desupported in Oracle Reports 10g Release 2 (10.1.2). Refer to the Generic FAQ for a list of these features. Refer to the white paper A Guide to Functional Changes Between Oracle Reports 6i and 10g available on the Oracle Technology Network (OTN) for information on how to migrate reports that use these features .
In Oracle Reports 10g Release 2 (10.1.2), Reports Server clustering is deprecated. An OracleAS Forms Services application from prior releases that includes a Reports Server cluster name will fail to bind to the Reports Server cluster it references. To resolve this issue, Oracle Reports 10g Release 2 (10.1.2) introduces a new Reports Servlet property REPORTS_SERVERMAP, which enables you to map a cluster name to a Reports Server name. This avoids the necessity to change the cluster name in all OracleAS Forms Services applications. Refer to the chapter titled Configuring Oracle Reports Services in Oracle Application Server Reports Services Publishing Reports to the Web for more information.
How do I migrate my charts from Oracle Graphics to the new graph format in Oracle Reports 10g?
Can I still run my existing Oracle6i Reports Developer reports containing Oracle Graphics charts in Oracle Reports 10g?
Reports built with previous versions of Oracle Reports containing Oracle6i Graphics charts will continue to run when the report is opened in Oracle Reports 10g Release 2 (10.1.2) if the Oracle6i Graphics runtime is installed on the same machine in a separate ORACLE_HOME. However, this is not a supported configuration, and Oracle will not fix bugs that result from this configuration.
Can I modify or add Oracle6i Graphics charts to my reports with Oracle Reports 10g?
I see a difference in the number of pages when I run my 10g (9.0.4) report in 10g Release 2 (10.1.2). Why?
This is because the value of the Page Break properties were not saved correctly in 10g (9.0.4). To fix this, open the report in Reports Builder 10g Release 2 (10.1.2), set the Page Break Before and Page Break After properties to the correct values, and save the report.
My reports created with previous versions do not produce valid HTML 4.0 output in 10g Release 2 (10.1.2). Why?
Stock graphs show data in bars in when I run my reports with previous releases of Oracle Reports. Why don't I see the bars when I run the same reports with Oracle Reports 10g Release 2 (10.1.2)?
Additionally, in Oracle Reports graphs, bars support special effects like color gradients, while lines do not. If you have used color gradients in your Stock Hi-Lo-Close graph in Oracle Reports 10g (9.0.4) and you run it in Oracle Reports 10g Release 2 (10.1.2), bars change to lines, and the lines lose color information. As a result, the data lines become transparent. To fix this issue, you must specify color for the data lines either using the Graph Wizard or in the graph.xml file.
Can I run Oracle Reports Builder 9.0.2 and 10.1.2 on the same machine?
Can I connect to Oracle Reports 10g Release 2 (10.1.2) Server using Oracle Reports 10g (9.0.4) clients, and vice-versa?
Oracle Reports 10g Release 2 (10.1.2) produces PDF 1.4 compatible output. It provides the following PDF features:
To create multibyte output, you must have the appropriate Adobe multibyte fonts installed. For detailed information about the PDF support in Oracle Reports 10g Release 2 (10.1.2) , refer to Oracle Application Server Reports Services Publishing Reports to the Web .
You can reuse your Oracle6i Reports Server configuration in Oracle Reports 10g Release 2 (10.1.2) by copying the following files:
You can find more information about configuring Oracle Reports Services 10g Release 2 (10.1.2) in Oracle Application Server Reports Services Publishing Reports to the Web .Top of Page
Can I open my existing RDF report and save it as a JSP?
Oracle6i Reports Builder had a Postscript menu choice under File > Generate to File menu. It has been replaced with a Text menu choice in Oracle Reports Builder 10g. How do I generate Postscript?
When I open an Oracle6i Reports Developer report in the Oracle Reports Builder 10g and run my Web layout, I get an empty Web page in my browser.
How do I migrate my Oracle6i Reports Developer reports in Oracle Portal to Oracle Reports 10g?
My existing report accesses data from a non-Oracle database using ODBC, will it still work?
Note that the Oracle Express data source is deprecated in Oracle Reports 10g Release 2 (10.1.2). You should plan to migrate your Express data to the OLAP option provided with Oracle Database. Use OLAP data source in Oracle Reports 10g Release 2 (10.1.2) to create your reports based on OLAP data. Refer to Oracle Reports Building Reports for more information on creating reports based on the OLAP data source.
If you need to run the report you created with Oracle6i Reports Builder using Express data source, you need to perform the following steps to make it work with Oracle Reports 10g:
You need to perform these steps to migrate your report from the old architecture to the new pluggable data source (PDS) based architecture for connecting to Oracle Express.
Does the Reports 6i distribution (.DST) file format still work in Oracle Reports 10g?
How do I call Oracle Reports 10g from Oracle Forms 10g Applications ?
Is there an alternate configuration for security without using WebDB?
How do I get more information on features deprecated and desupported in Oracle Reports 10g Release (10.1.2)?
For each deprecated and obsolete functionality, this white paper recommends what new functionality should be used instead. As stated above, this white paper covers the
functionality. If you would like to know Oracle Corporation’s
strategy towards Oracle Reports, refer to
Oracle Forms - Oracle Reports - Oracle Designer Statement of Direction available on the
Oracle Technology Network (OTN).