Skip Headers
Oracle® Application Server Release Notes
10g Release 2 (10.1.2) for Linux Itanium
  Go To Documentation Library
Go To Product List
Solution Area
Go To Table Of Contents


5 Oracle Forms

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

5.1 General Issues and Workarounds

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

5.1.1 Forms Dual Monitor Certification

Using a dual monitor configuration with Oracle Forms is now supported.

5.1.2 Unix Issues and Workarounds

On Unix platforms, if you relink Forms executables after installation (for example, because you are applying a one-off patch) the permissions on newly created executables will not necessarily be the same as the originals. Use chmod to change them manually.

5.1.3 Oracle Forms Logout Behavior and Oracle Application Server Single Sign-On

Forms applications use Oracle Application Server Single Sign-On only for obtaining database connection authentication. Once this connection is made, interaction with Oracle Application Server Single Sign-On no longer occurs. Exiting a Forms application will not perform an Oracle Application Server Single Sign-On logout. Conversely, logging out of an Oracle Application Server Single Sign-On session will not terminate an active Forms session. The database session will exist until the Forms Runtime (e.g. frmweb.exe) on the server terminates, usually by explicitly exiting the form.

5.1.4 Incorrect Memory Usage Is Reported for Forms on SLES9

On SLES9, when you click the Forms link on the Enterprise Manager main page, the Forms Overview page is displayed. On this page, the Pie Chart showing the Memory Usage is broken and shows an unhandled exception error. When you click the User Sessions tab, it shows the Total Memory Usage, in percentage. Due to the way SLES9 operating system reports the memory of a process, the private and shared memory sections display very high values. To resolve this issue, apply the following patch:

5.2 Configuration Issues and Workarounds

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

5.2.1 EM_MODE Needs To Be 1 to Enable Grid Control to Collect Metrics

The EM_MODE parameter in formsweb.cfg needs to be set to 1 for Grid Control to collect metrics. This parameter is set to 0 by default. You will need to restart the Enterprise Manager Agent.

5.2.2 Grid Control Reports Forms Targets as Down after Web Cache Is Disabled

After disabling Web Cache, Grid Control reports Forms targets as down, which is false. As a workaround, in the targets.xml file in %ORACLE_HOME%/sysman/emd, change the target property with the NAME="ServletUrl" to read from the HTTP listener port instead of the Web Cache port.

5.2.3 Non-Internet Explorer Browser Proxy Settings when Using One-Button-Run

If you encounter a FORBIDDEN error when using One-Button-Run with any of the supported Browsers other than Internet Explorer, verify if (localhost) is in the proxy settings for your browser. If is not in the exceptions list, then add it. This ensures that the browser will bypass the proxy server.

5.2.4 Change to Default Setting for FORMS_RESTRICT_ENTER_QUERY Environment Variable

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.

5.2.5 PJC Wizard Now Part of Oracle Forms

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

5.2.6 Exception When Clicking Other Items While Inputting Multibyte Characters

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.

5.2.7 JDK 1.4.2_06 Plug-in Not Installed When Running a Form on the Web for the First Time

The Install JDK 1.4.2 dialog appears when running a Form on the Web for the first time. When you click Install, the JDK 1.4.2 Plug-in is installed instead of the JDK 1.4.2_06 Plug-in. If you are attempting to use the JDK 1.4.2 plugin from Internet Explorer, and it is not currently installed on your machine, it will download the wrong version. The workarounds are:

  • Modify formsweb.cfg by finding:


    and change it to:

  • Run the Form (for the first time) from Netscape, which will go to the correct location for the download.

  • Go to the correct location and manually install the JDK 1.4.2_06 Plug-in.

5.2.8 CLOB Data Cannot be Retrieved When Query Data More Than Max Width

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 error message "FRM-40505"or "FRM-92101" depending on your platform.

As a workaround, extend the maximum length of the Text Item to fit the length of the CLOB data.

5.2.9 FRM-92102 Existing Sessions Disconnect When User Added To JAZN

The FRM-92102 error appears and existing Forms sessions disconnect after adding a new user to JAZN (OC4J_BI_FORMS | Applications | formsapp | Security). Thus, if you're adding new JAZN users to the OC4J_BI_Forms instance, you should do this while no Forms session is running.

5.2.10 Monitoring CPU Usage and Response Time

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.

5.2.11 Setting REPORTS_DEFAULT_DISPLAY and DISPLAY Environment Variables

For proper functioning of the Reports, ensure that the REPORTS_DEFAULT_DISPLAY variable is set to NO and the DISPLAY variable is set to a valid display in the $ORACLE_HOME/bin/ file. For example,

DISPLAY=myserver:0.0; export DISPLAY

Where, myserver:0 is the host machine that is running a valid X server.

If you try to run the demo using test.rdf with a default installation of Reports In Process server, then the Reports In Process server will not work and the following error will be displayed:

REP-3000: Internal error starting Oracle Toolkit.

If you are using in-process server, then ensure that the DISPLAY environment variable is set correctly in the $ORACLE_HOME/opmn/conf/opmn.xml configuration file.

For process-type OC4J_BI_Forms, the default DISPLAY entry is as follows:

<variable id="DISPLAY" value="localhost:0"/>

You need to change the default DISPLAY entry to a computer with a valid X server. For example, to use the X server running on myserver:0.0, you need to change the following:

<variable id="DISPLAY" value="myserver:0.0"/>

You need to run opmnctl, and then reload and restart the OC4J_BI_Forms instance for the changes to take effect.

5.3 Documentation Errata

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

5.3.1 Code in A Text Version of A Module Is in Hexadecimal

In the topic "About Converting Modules from Binary to Text Format", it states:

"The text version of a module is a human-readable file that describes its objects and code."

It should read:

"The text version of a module is a human-readable file that describes its objects and PL/SQL code translated into hex."

5.3.2 Obsolete Property FIXED_LENGTH

The FIXED_LENGTH property, as mentioned in the online help, is obsolete. It is mentioned as a property of the SET_ITEM_PROPERTY Built-in, and in the PL/SQL and Forms Reserved Words.

5.3.3 Invalid Parameters

In the Oracle Forms Services Deployment Guide, the following parameters are invalid:

  • archive_ie (parameter)

  • baseHTMLie (parameter)

  • IE (parameter)

  • (file)

5.3.4 Error in Unix Script in Migration Assistant Guide

In Oracle® Forms Migrating Forms Applications From Forms 6i 10g ( for Windows and UNIX, in Chapter 2, Using the Oracle Forms Migration Assistant, the sample UNIX script says:

    for file in $*
    do module=$ff

This small script does not work in Unix. The corrected script is:

    for file in $*
    do module=$file

5.3.5 Enabling Single Sign-On Description Assumes a new Application

In Chapter 6, the section titled "Enabling OracleAS Single Sign-On for an Application" describes correctly the steps to add this parameter to the configuration section of a chosen application. However, if you change an existing section such as the default, the steps are slightly different as the parameter already exists.In this case, Step 5 becomes is where you select the parameter and enter a new value.

5.3.6 Incorrect Key Mapping

In Section 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"

5.3.7 Incomplete JVM Pooling Example

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:


However, this example should read as:


5.3.8 Incorrect Script Tag Names

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>

5.3.9 Incorrect Default Threshold Setting Description

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.

5.3.10 Incorrect Parameter Names in URL

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.

5.3.11 Missing Kernel Parameters for OracleAS Metadata Repository

Oracle Application Server Forms and Reports Services Installation Guide does not include the kernel parameters for OracleAS Metadata Repository.

For the correct list of these kernel parameters and the procedure to set them, refer to "Section 4.4.2 Kernel Parameter Settings for OracleAS Metadata Repository" in Oracle Application Server Installation Guide.