|
Oracle® Application Server Forms and Reports Services Release Notes
10g Release 2 (10.1.2) for Microsoft Windows (64-Bit) on Intel Itanium B25339-01 |
|
|
Oracle® Application Server Forms and Reports Services Release Notes
10g Release 2 (10.1.2) for Microsoft Windows (64-Bit) on Intel Itanium B25339-01 |
|
Forms and Reports Services Release Notes
10g Release 2 (10.1.2) for Microsoft Windows (64-Bit) on Intel Itanium
B25339-01
October 2005
This document contains information that is specific for installing, configuring, and using Oracle Application Server 10g release 2 (10.1.2) Forms and Reports Services:
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
Oracle Application Server Forms and Reports Services allows you to install and configure Forms and Reports Services without the need to install and configure all of Oracle Application Server 10g.
This type of installation is suited best for users who want to upgrade Forms applications to the Grid environment in two phases. In phase one, they move to the Grid environment by upgrading their client server based Forms applications to Web-based ones. In phase two, users can then choose to use the services offered by an existing Oracle Application Server Infrastructure upgrade.
Oracle Application Server Forms and Reports Services provides no Infrastructure service, such as Single Sign-On or Identity Management integration. However, Infrastructure services are available by upgrading your instance to use the services of an existing infrastructure, or install a new one.
Once you configure Forms and Reports Services to use the services of an OracleAS infrastructure, you cannot reverse this configuration.
When you install Oracle Application Server Forms and Reports Services, you'll have access to these features:
Oracle Application Server Forms Services deploys Forms applications with database access to Java clients in a Web environment. Oracle Application Server Forms Services automatically optimizes class downloads, network traffic, and interactions with Oracle database. Applications are automatically load-balanced across multiple servers and, therefore, can easily scale to service any number of requests.
Oracle Application Server Reports Services provides an easy-to-use, scalable, and manageable solution for high-quality database publishing and reporting by creating dynamic reports for the Web and across the enterprise. It enables you to implement a multitiered architecture for running your reports.
Oracle HTTP Server is the Web server that Oracle Application Server uses, which is built on Apache Web server technology. Oracle HTTP Server offers scalability, stability, speed, and extensibility. It also supports Java servlets, Java Server Pages (JSPs), Perl, PL/SQL, and CGI applications.
Oracle Application Server Web Cache is a server accelerator caching service that improves the performance, scalability, and availability of frequently used e-business Web sites that run on the Oracle platform. By storing frequently accessed URLs in virtual memory, Oracle Application Server Web Cache eliminates the need to repeatedly process requests for those URLs on the Web server, and it caches both static and dynamically-generated HTTP content from one or more applications Web servers.
Oracle Application Server Containers for Java is a complete set of J2EE containers written entirely in Java that execute on the Java Virtual Machine (JVM) of the standard Java Development Kit (JDK).
Oracle Enterprise Manager Application Server Control (from here on Application Server Control) provides you with the management tools you need to monitor and administer Oracle Application Server instances. Application Server Control is installed with every instance of Oracle Application Server.
Application Server Control provides Web-based management tools designed specifically for Oracle Application Server. Using Application Server Control, you can monitor and configure components of your application server. You can deploy applications, manage security, and create and manage Oracle Application Server clusters.
Application Server Control consists of the following:
The Enterprise Manager Home pages you use to manage Oracle Application Server and its components: These Web pages provide you with a high-level view of your Oracle Application Server environment. From these pages you can drill down for more detailed information on administration, configuration, and performance monitoring. These pages allow you to administer the application server and its components and deployed applications.
The underlying software technologies that keep track of your application server instances and components: These technologies automatically perform many management tasks. For example, they discover the components of each application server instance, gather and process performance data, and provide access to application configuration information.
Application Server Control is installed as part of the Oracle Application Server installation process.
Oracle Process Manager and Notification Server (OPMN): OPMN provides process control and monitoring for application server instances and their components. It gathers component status information, and distributes the status information to components that are interested in it. The Application Server Control uses OPMN for such tasks as starting and stopping the components of your application server instance.
Distributed Configuration Management (DCM): DCM manages configurations among application server instances that are associated with a common Metadata Repository. It enables Oracle Application Server cluster-wide deployment so you can deploy an application to one instance and have it automatically propagated to the entire cluster. You can also make a single host or instance configuration change to one instance and have it propagated across all instances in the cluster. Application Server Control uses DCM to make configuration changes and to propagate configuration changes and deployed applications across the cluster.
Before starting the software installation, please take the time to read the following documents:
Read this document first, which includes Release Notes for Oracle Application Server Forms Reports Services.
Read Oracle Application Server 10g Release 2 (10.1.2) Forms and Reports Services Installation Guide.
This document explains what you need to know and to do when installing this installation type.
If you are upgrading from Oracle Forms 6i to Oracle Forms10g, visit the Oracle Forms upgrade center at http://www.oracle.com/technology/products/forms/.
The following sources provide additional information:
Online help, available in Oracle Forms Developer, Oracle Reports Developer, and Oracle Enterprise Manager
Oracle Application Server Forms Services Deployment Guide
Oracle Forms Migration Guide
Oracle Application Server Reports Services Publishing Reports to the Web
Oracle Application Server Concepts
Oracle Application Server Administrator's Guide
Oracle Application Server 10g Release Notes
Oracle Technology Network (http://www.oracle.com/technology/products/forms/).
The non-English Welcome pages files have some of the links coded incorrectly, as they point to .html instead of .htm. The workaround is that, if you click on a link and you get the Not Found page, to change the extension in the address bar to .htm instead of .html.
This section describes issues associated with Oracle Forms. It includes the following topics:
This section contains issues related to Oracle Forms and Windows:
Section 7.1.1, "Availability of JACOB Libraries for WebUtil"
Section 7.1.2, "Java Related Dialogs And Windows Are Not Read By JAWS"
You can download the latest version of the JACOB libraries from http://prdownloads.sourceforge.net/jacob-project/.
3032246
You need to add access-bridge.jar and jaccess-1_3.jar to CLASSPATH.
JAWS scripts are now installed with Oracle Forms. The location for these scripts is ORACLE_HOME/forms/ScreenReader/, and are also available at Oracle Technology Network (OTN) at http://www.oracle.com/technology/products/.
This section describes configuration issues and their workarounds. It includes the following topics:
Section 7.2.1, "Non-Internet Explorer Browser Proxy Settings when Using One-Button-Run"
Section 7.2.2, "Change to Default Setting for FORMS_RESTRICT_ENTER_QUERY Environment Variable"
Section 7.2.4, "Exception When Clicking Other Items While Inputting Multibyte Characters"
Section 7.2.5, "CLOB Data Cannot be Retrieved When Query Data More Than Max Width"
Section 7.2.6, "ORACLE_HOME Value Not Replaced In workingDirectory In formsweb.cfg"
If you encounter a FORBIDDEN error when using One-Button-Run with any of the supported Browsers other than Internet Explorer, verify if 127.0.0.1 (localhost) is in the proxy settings for your browser. If 127.0.0.1 is not in the exceptions list, then add it. This ensures that the browser will bypass the proxy server.
The environment setting FORMS_RESTRICT_ENTER_QUERY has a default value of TRUE. This setting disallows users from using QUERY-WHERE functionality until it is set to FALSE.
With Oracle Forms 10.1.2 and higher, the Forms PJC Wizard is part of the standard Forms installation. The PJC Wizard works with JDeveloper 10g release 2 (10.1.2) that is part of Oracle Developer Suite 10g. For versions of JDeveloper that are obtained from OTN, the PJC wizard is available as a separate Jar file to download and place into your JDeveloper installation.
In CJK languages, the Forms client may stop responding when clicking another item while inputting text through inline IME. As a workaround, disable the inline IME. See section 4.10.2, "Inline IME Support" in Oracle Application Server Forms Services Deployment Guide. This issue will be fixed in a future patch set.
When using Japanese NLS_LANG (JA16SJIS, JA16EUC etc.) if the queried CLOB data is longer than the maximum length (240 bytes by default) of the Text Item corresponding to this CLOB data, the query fails at runtime. The issue is that the CLOB data is correctly truncated with the maximum length of the Text Item (240 bytes by default) in English NLS_LANG, but not in Japanese NLS_LANG.This issue may also raise "FRM-40505: ORACLE error: unable to perform query" on Windows.
As a workaround, extend the maximum length of the Text Item to fit the length of the CLOB data.
The OracleAS Upgrade Assistant does not replace any references to the source ORACLE_HOME with the destination ORACLE_HOME in the workingDirectory parameter in formsweb.cfg.
As a workaround, after running the OracleAS Upgrade Assistant, replace the references to the source ORACLE_HOME with the location of the destination ORACLE_HOME for the workingDirectory parameter in formsweb.cfg.
On the System Component Tables in Enterprise Manager, the CPU and Memory statistics are collected every minute, by default. Note that this potentially can mean that any CPU spikes will not be displayed. In addition, if Forms server processes are dormant, awaiting client activity or requests, it is perfectly normal for the CPU usage to report 0.0%.
On the Forms Overview page, the CPU and Memory statistics are gathered each time the page is rendered when you click the Overview Tab or when you click the refresh icon next to the timestamp. However, due to an operating system restriction, if the Response Time from the Forms Servlet is less than 16ms, it will display as 0.00ms.
This chapter describes issues with Oracle Reports. It includes the following topics:
|
See Also:
|
This section describes general issues and their workarounds for Oracle Reports. It includes the following topics:
Section 8.1.1, "OracleAS Reports Services Demos Will Not Work If JServ Is Configured"
Section 8.1.2, "Error While Editing Batch Registered Report in OracleAS Portal"
Section 8.1.3, "Limitation on Linked Queries for DelimitedData Output"
Section 8.1.8, "PL/SQL Compilation Failure When Using SQL Constructs"
Section 8.1.9, "Using New SQL Constructs (Post Oracle Database 9.2.0)"
To run OracleAS Reports Services demos properly, do not configure Apache JServ on the computer where OracleAS Reports Services is installed.
If you batch register a report in OracleAS Portal, then subsequently manually edit the report's registration in OracleAS Portal, you may encounter an unexpected Save As dialog box during the manual editing process.
To work around this issue, specify the Display Name property while editing the report's registration in OracleAS Portal.
Refer to the Oracle Application Server Reports Services Publishing Reports to the Web manual for information on how to register a report with OracleAS Portal.
DelimitedData output does not allow multiple queries to be linked to the main query, because sibling groups are not supported.
For example:
Case 1: You have a link between Q1 and Q2, a link between Q2 and Q3, and a standalone Q4 query.
Q1<-->Q2<-->Q3 Q4
In this case, DelimitedData output is generated correctly.
Case 2: You have a link between Q1 and Q2, a link between Q2 and Q3, and a link between Q4 and Q1.
Q1<-->Q2<-->Q3 Q1<-->Q4
In this case, DelimitedData output is not generated correctly. Alternatively, you can use XML output.
If any summary column values are not correctly left-aligned in the output of JSP-based Web reports with a Group Above or Matrix style, you can implement the following workaround to get proper alignment:
Open the JSP report in Reports Builder.
Select the Web Source view.
In the Web Source view, locate the section where the summary column is defined, and delete the following line to remove the extra space:
<th class="summary_column_name"> </th>
If OracleAS Web Cache is configured as SSL-enabled and Oracle HTTP Server is not, then the images in the HTML output of Oracle Reports is not displayed when viewed from Oracle Enterprise Manager 10g. This is because the image URLs mentioned in the HTML output points to OracleAS Web Cache ports, which are SSL-enabled, whereas the request for past job outputs of Oracle Reports from Oracle Enterprise Manager 10g is non-SSL.
To work around this issue, edit the Servlet property of the URL in the targets.xml file for Reports Server type such that it points to the OracleAS Web Cache port instead of the Oracle HTTP Server port. The targets.xml file is available at ORACLE_HOME/sysman/emd directory.
For example, if your OracleAS Web Cache is SSL-enabled and the listening port number is 443, then the Servlet property of the URL for the Reports Server target in the targets.xml file should be as shown in the following example:
<Target TYPE="oracle_repserv" …..> ...... <Property NAME="Servlet" VALUE="https://xyz.mycompany.com:443/reports/rwservlet"/> ...... </Target>
If you use Acrobat Reader 7.0 to view multibyte and unicode PDF reports that use enhanced font subsetting feature (default) and the report size is very large, then some of the characters displayed will not be aligned properly.
To work around this issue, you can do either of the following:
Set the environment variable REPORTS_ENHANCED_SUBSET to NO to revert to the Type 3 font subsetting implementation used in releases prior to Oracle Reports 10g Release 2 (10.1.2).
Use Acrobat Reader 6.0 or earlier.
If any of the following conditions are present, then the text in the Paper Design view of Reports Builder may display in an incorrect color:
A text object includes multiline text, which wraps beyond the first line.
The text object's Contains HTML Tags property is set to Yes.
More than one color is applied to different parts of the multiline text.
|
Note: This issue is shown in the Paper Design view only. The report output in all other output formats show correct colors. |
PL/SQL compilation may fail if you use SQL constructs in your reports and if the following conditions are present:
The SQL constructs were introduced in Oracle Database versions after 9.0.1, for example, ROW_NUMBER().
The SQL constructs are used in client side PL/SQL procedures.
To work around this issue, you can do any of the following:
Use Oracle Database Release 10.1.0.4 or later.
Move those SQL constructs to the server-side stored procedures.
Use the SQL constructs within SQL queries directly instead of procedures.
PL/SQL compilation may fail if you use SQL constructs in your reports and if the following conditions are present:
The SQL constructs were introduced in Oracle Database versions after 9.2.0, for example, ROW_NUMBER().
The SQL constructs are used in client side PL/SQL procedures.
To work around this issue, you can do any of the following:
Use Oracle Database Release 10.1.0.4 or later.
Move those SQL constructs to the server-side stored procedures.
Use the SQL constructs within SQL queries directly instead of procedures.
This section describes Globalization Support issues and their workarounds for Oracle Reports. It includes the following topics:
When you deploy reports created with Reports Builder on Windows to a Solaris or Linux Reports Server that has NLS_LANG set to JA16EUC, the PDF font mappings will not work. This happens if any one of the following fonts is used in the PostScript font mapping entry:
"<MS Mincho in JP>"..... "<MS PMincho in JP>".....
To work around this issue, you must perform one of the following tasks:
Set NLS_LANG to JA16SJIS.
Use MS Gothic instead of MS Mincho in PostScript font mappings when creating the reports.
Oracle Reports status messages on the Job Status page in Application Server Control Console may contain invalid characters if the middle tier character set, NLS_CHARACTERSET (the third field of NLS_LANG) does not correspond to the encoding of the Reports Servlet response for the servlet locale.
|
Note: The middle tier's default encoding can be different from the Servlet's encoding. For example, when you setLANG to ja or ja_JP.eucJP, the default middle tier system encoding is EUC. However, in this locale, Reports Servlet messages are encoded in Shift_JIS. This is because default encoding for ja_JP is Shift_JIS in the servlet.
|
Oracle Enterprise Manager 10g converts the messages from the middle tier's NLS_CHARACTERSET to UTF8 resulting in invalid characters in the status messages on the Job Status page. For example, the Reports Servlet messages are encoded in Shift_JIS when the middle tier runs with LANG set to ja and NLS_LANG set to JAPANESE_JAPAN.JA16EUC. However, Oracle Enterprise Manager 10g assumes that the original message is in JA16EUC, and converts it to UTF8, which results in the display of invalid characters in the status messages. This will be fixed in a future patch set.
When detecting a new incoming request for a duplicate job where the job request includes the TOLERANCE keyword, Reports Server ignores the value of the ENVID keyword. As a result, the job is marked duplicate of a previous job that was submitted with the same values for all keywords except ENVID.
The following example illustrates this issue.
| Report Request | Report | ENVID | TOLERANCE | Output |
|---|---|---|---|---|
| 1 | Japanese.rdf
|
JA
|
10
|
As expected |
| 2 | Arabic.rdf
|
UTF
|
10
|
As expected |
| 3 | Arabic.rdf
|
AR
|
10
|
Same as request 2 (incorrect) |
| 4 | Japanese.rdf
|
JA
|
10
|
Same as request 1 (correct) |
In this example, request 4 is correctly marked as a duplicate of request 1 as both the requests use the same values for all keywords, including the ENVID keyword. However, request 3 is incorrectly marked as duplicate of request 2 because both requests use the same values for all keywords, except the ENVID keyword. As a result, the changed ENVID will not be accepted in request 3.
To work around this issue, either do not specify TOLERANCE on the command line or specify a dummy user parameter in the job request to differentiate the job requests in duplicate job detection.
This section describes vendor-specific issues and their workarounds for Oracle Reports. It includes the following topics:
Section 8.3.1, "Underlines Do Not Display in HTMLCSS Output in Browser"
Section 8.3.2, "JSP-Based Web Report with Large Number of Columns Generates JSP Compilation Error"
Section 8.3.3, "Java AWT Windows Hangs with Specific Graphics Cards"
In HTMLCSS output, underlines may not display in the browser if you use a custom style for a field object and apply both background color and underline as part of the style, as shown in the following example:
.ReportLevel {text-decoration:underline;color:blue; background-color:yellow}
This is a browser limitation. The browser cannot display underlines, with absolute positioning, for the fields that have both underline and background color applied to them.
When you run a JSP-based Web report with more than 149 columns, you may encounter the oracle.jsp.provider.JspCompileException error, as shown in the following example:
500 Internal Server Error
OracleJSP: oracle.jsp.provider.JspCompileException:
Errors
...
6764 code too large for try statement catch( Throwable e)
{18 code too large public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException}
This occurs due to a limitation in the Java language that does not enable compilation of Java files with large methods.
When you start Reports Server with rwserver.exe, the UI may not display and Reports Server may hang on computers with specific graphics cards (for example, ATI Rage XL PCI card). This occurs due to a problem with the UI mechanism used in Java.
As a workaround, start Reports Server with the JVMOPTIONS command line keyword set as shown in the following example:
rwserver SERVER=test JVMOPTIONS="-Dsun.java2d.noddraw=true"
|
Note: It is recommended that you start Reports Server from OPMN. |
This section describes documentation errata. It includes the following topic:
In Section 4.11.1.2.1 of Oracle Application Server Forms Services Deployment Guide, the description for Mapping F2 is written as:
To map F2, change the default entry for F2, "List Tab Pages", to another key. Here is an example of the default entry:
113: 0 : "F2" : 95 : "List Tab Pages"
This must be explicitly changed to another key mapping such as the following:
113: 8 : "F2" : 95 : "List Tab Pages"
The last line should read as:
113: 8 : "Alt+F2" : 95 : "List Tab Pages"
In section 7.5.12 of Oracle Application Server Forms Services Deployment Guide, there is a sample formsweb.cfg configuration. The last named section is written as:
[salesApp] form=sales.fmx userid=sales/salespw@orcl
However, this example should read as:
[salesApp] form=sales.fmx userid=sales/salespw@orcl jvmcontroller=
In section 9.2.2 of Oracle Application Server Forms Services Deployment Guide, the script tag is written as:
<SCRIPT SRC="/oracle_smp_EndUserMonitoring/oracle_smp_EndUserMonitoring.js"></SCRIPT>
It should read as:
<SCRIPT SRC="/oracle_smp_chronos/oracle_smp_chronos.js"></SCRIPT>
In section 9.2.5 of Oracle Application Server Forms Services Deployment Guide, the default threshold description is written as:
The default unreasonable threshold is set to 60,000 milliseconds, which may be too small for Oracle Forms Applications. You may want to change this default to 1 minute.
The correct description should read:
The default unreasonable threshold is set to 60,000 milliseconds, which may be too small for Oracle Forms Applications. You may want to change this default to 1 hour.
In section 9.3.1 of Oracle Application Server Forms Services Deployment Guide, the EndUserMonitoringURL parameter is written as:
Set EndUserMonitoringURL=http://computername:7777/oracle_smp_EndUserMonitoring/oracle_smp_EndUserMonitoring_sdk.gif
It should read as:
EndUserMonitoringURL=http://<hostname>:<webcache port number>/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
Without the correct EndUserMonitoringURL parameters, End User Monitoring will not work.
Release Notes, 10g Release 2 (10.1.2) for Microsoft Windows (64-Bit) on Intel Itanium
B25339-01
Copyright © 2005, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software—Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.
