Forms And Reports 6i Patch Set 13

Forms And Reports 6i Patch Set 13 Average ratng: 4,4/5 6586 votes

A Oracle Forms and Reports Patch Set Installer Screens. This appendix contains screenshots and descriptions for the Oracle Forms and Reports Patch Set Installer screens. It's worth setting both as many documents don't follow my preference. A number of the sections below assume these environment variables have been set.

Oracle® Forms and Reports Developer and Oracle Forms andReports Services 6i (Patch 19)Release NotesRelease 6.0.8.28 for Microsoft Windows and UnixSeptember 2007 Note to E-Business Suite Users: Please see the README titled 'Upgrading Developer 6i with Oracle Applications 11i' before reading these Forms Release Notes. The E-Business Suite Users README is available at MetaLink > Technical Libraries > ERP Applications > Applications Technology Stack under D2K Forms Issues, Setup & Usage. Refer to the Forms Release Notes only when instructed to do so in the E-Business Suite Users README file. To find ReadMe documents for previous patch releases and other platforms, go to https://metalink.oracle.com/ and query Patch Set releases for Forms or Reports 6i. Note: This patch set has only been certified for use with Oracle Applications installations and for Extended Maintenance Support (EMS) customers. Standard Error Correction Support for non-Oracle Applications users ended 31-JAN-2005. Please refer to Oracle MetaLink Note:228666.1 for more details. This document contains the following sections: ■ Section 1, 'General Considerations' ■ Section 2, 'Supported Platforms in This Patch' ■ Section 3, 'What’s New in This Patch' ■ Section 4, 'Installation Considerations' ■ Section 6, 'Generic Oracle Forms 6i Issues' ■ Section 7, 'Generic Oracle Reports 6i Issues' ■ Section 8, 'Oracle Forms 6i Platform-Specific Issues' ■ Section 9, 'Oracle Reports 6i Platform-Specific Issues' ■ Section 10, 'Source of Additional Information' ■ Section 11, 'Documentation Accessibility' 1 General Considerations This section contains the following: ■ Section 1.1, 'Server Licensing' ■ Section 1.2, 'Name and Packaging Changes' 1


■ Section 1.3, 'Release Numbering'■ Section 1.4, 'RSF Components Include Additional Bug Fixes'■ Section 1.5, 'Precompilers Compatible With This Release'■ Section 1.6, 'Integration with Oracle Repository'■ Section 1.7, 'Effect of Fill Patterns on Performance'■ Section 1.8, 'Client Platform Certifications'■ Section 1.9, 'Java Importer'■ Section 1.10, 'Unix Considerations'1.1 Server LicensingIf you want to deploy your Oracle Forms or Oracle Graphics to the Internet or anintranet, then you need the Oracle Forms Server and its associated deploymentlicense.The Oracle Forms Server is included on the general Oracle Forms DeveloperCD-ROM for demonstration and test purposes, but is licensed separately. Contactyour Oracle sales representative to get additional information on Oracle FormsServer pricing.1.2 Name and Packaging ChangesPreviously, Oracle Developer was two separate products: Oracle FormsDeveloper and Oracle Reports Developer, and Oracle Developer Server was twoseparate products: Oracle Forms Server and Oracle Reports Server.Now, the names Oracle Developer and Oracle Developer Server are obsolete.Oracle Forms Server is now called Oracle Forms Services and Oracle ReportsServer is now called Oracle Reports Services.1.3 Release NumberingIn this release of Oracle Forms Developer 6i, most of the major components (forexample, Oracle Forms Builder and Oracle Graphics Builder) have a 6.0.8 versionnumber. Most of the subcomponents (Toolkit, for example) have a 6.0.5 versionnumber. These are the appropriate versions of the subcomponents for this initialrelease.1.4 RSF Components Include Additional Bug FixesRelease 6i includes some RSF components that contain code fixes beyond those inthe formal, numbered patches to the component. (These fixes or patch-levels of acomponent are sometimes referred to as one-offs.)Specifically, Release 6i includes fixes for bugs 1063571, 1063104, 1028960, 1049171,and 1040536. These bug fixes affect the following components: SQLNET,RDMBMS, NLS, and PL/SQL. 2


1.5 Precompilers Compatible With This ReleaseIf you are developing user-exits for Oracle Forms Developer 6i using the OraclePrecompilers, then use the versions of the Precompilers that are bundled with theOracle 8.0.6 release.1.6 Integration with Oracle RepositoryOracle Forms Developer can be integrated with Oracle Repository.This 6i release is shipped with a d2sc plug-in (similar to those provided forPVCS, Clearcase, and other products) that allows integration with Repository forsource control management. Users will be able to check in and check out FMBs,MMBs, and so forth, and can then use Repository's dependency tracking andother advanced functionality. (See the Repository documentation for moreinformation.)This initial feature establishes the potential for enhanced levels of integration infuture Forms Developer releases.1.7 Effect of Fill Patterns on PerformanceAssigning a fill pattern to a large Forms object may degrade runtimeperformance on the web. Objects are filled in 64x64 pixel increments. Thus,objects larger than 64x64 require multiple operations. (For example, painting awindow of size 800x600 would require 120 such operations.)Recommendations: Avoid using fill patterns for large objects unless doing so is asignificant user requirement. Also, minimize the number of different patterns.(Each pattern used requires 4K of memory.)1.8 Client Platform CertificationsFor the latest information regarding supported client platforms and their supportlevel, consult the current version of the Client Platform SOD, available from theOracle Technology Network (http://www.oracle.com/technology/)website or your Oracle support representative.1.9 Java ImporterThe Java Importer does not function when the web preview mode of the builderis used. The Java Importer functions as documented in client/server runtimemode and in a deployment environment with Oracle Forms Services. The JavaImporter requires a separate, manual installation of JDK 1.2.2 before use.1.10 Unix ConsiderationsThis section contains the following consideration for Unix:1.10.1 Motif Patch on SolarisMotif runtime library patch 103461-07 is the minimum patch level for OracleForms Developer and Oracle Forms Server 6i on Solaris 2.5.1.Motif runtime library patch 105284-20 is the minimum patch level for OracleForms Developer and Oracle Forms Server 6i on Solaris 2.6. 3


2 Supported Platforms in This PatchThe following platforms are supported in this patch:■ AIX5L Based Systems (64-bit)■ HP-UX PA-RISC (64-bit)■ Linux x86 (32-bit)■ Microsoft Windows (32-bit)■ Solaris Operating System (SPARC)For availability of Patch 19 on other platforms, please see Oracle MetaLink athttps://metalink.oracle.com/.3 What’s New in This PatchSee Section 5, 'Platform Specific Bugs Fixed in Patch 19' for more informationabout what is new in Patch 19.4 Installation ConsiderationsThe following section contains information on how to install the patch. Note: The Oracle E-Business Suite is a complete set of business applications that runs entirely on the internet. E-Business Suite Users must first see Upgrading Developer 6i with Oracle Applications 11i and refer to this readme file only when that note so states. This note can be obtained via MetaLink -> Technical Libraries -> ERP Applications -> Applications Technology Stack under D2K Forms Issues, Setup & Usage4.1 Installation Instructions for Microsoft Windows1. Close all other Windows applications and background Oracle services and processes.2. From the Start menu select Run.. and enter D:Setup.exe and replacing D: with the correct location to the patch.3. Select an ORACLE_HOME. (For Oracle Internet Application Server (9iAS) customers, this is the Forms & Reports home from your iAS install.)4. Select the patch product you would like to install.4.2 Installation and De-Installation Instructions for UnixThis section contains the following:■ Section 4.2.1, 'Installation Instructions for AIX'■ Section 4.2.2, 'De-Installation Instructions for AIX'■ Section 4.2.3, 'Installation Instructions for HP-UX PA RISC (32-bit)'■ Section 4.2.4, 'De-Installation Instructions for HP-UX PA RISC (32-bit)'■ Section 4.2.5, 'Installation Instructions for Linux' 4


■ Section 4.2.6, 'De-Installation Instructions for Linux'■ Section 4.2.7, 'Installation Instructions for Solaris'■ Section 4.2.8, 'De-Installation Instructions for Solaris'4.2.1 Installation Instructions for AIX1. Set your ORACLE_HOME.2. If you are going to apply this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver. b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH. c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH.3. Copy the files in this patch to your ORACLE_HOME.4. Unzip the patch using either WinZip on NT or unzip on Unix.5. Run the install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19. b. ./patch_install.sh 2>&1 tee patch_install_p19.log (ksh) c. ./patch_install.sh & tee patch_install_p19.log (csh)6. Check patch_install_p19.log for errors.7. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install Reports has both link-time and run-time dependency with libjava.so so you need to append $ORACLE_ HOME/network/jre11/lib/aix/native_threads in $LD_ LIBRARY_PATH before linking Reports. The same $LD_LIBRARY_PATH should be used at run-time. d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.2 De-Installation Instructions for AIX1. Set your ORACLE_HOME.2. If you originally applied this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH 5


3. Run the de-install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19 b. ./patch_deinstall.sh 2>&1 tee patch_deinstall_ p19.log (ksh) c. ./patch_deinstall.sh & tee patch_deinstall_p19.log (csh)4. Check patch_deinstall_p19.log for errors.5. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.3 Installation Instructions for HP-UX PA RISC (32-bit)1. Set your ORACLE_HOME.2. If you are going to apply this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver. b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH. c. Prepend <iAS_HOME>/6iserver/lib to the beginning of SHLIB_ PATH.3. Copy the files in this patch to your ORACLE_HOME.4. Unzip the patch using either WinZip on NT or unzip on Unix.5. Run the install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19. b. ./patch_install.sh 2>&1 tee patch_install_p19.log (ksh) c. ./patch_install.sh & tee patch_install_p19.log (csh)6. Check patch_install_p19.log for errors.7. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install Reports has both link-time and run-time dependency with libjava.sl so you need to append $ORACLE_HOME/network/jre11/lib/PA_ 6


RISC/native_threads in $SHLIB_PATH before linking Reports. The same $SHLIB_PATH should be used at run-time. d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.4 De-Installation Instructions for HP-UX PA RISC (32-bit)1. Set your ORACLE_HOME.2. If you originally applied this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH c. Prepend <iAS_HOME>/6iserver/lib to the beginning of SHLIB_ PATH3. Run the de-install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19 b. ./patch_deinstall.sh 2>&1 tee patch_deinstall_ p19.log (ksh) c. ./patch_deinstall.sh & tee patch_deinstall_p19.log (csh)4. Check patch_deinstall_p19.log for errors.5. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.5 Installation Instructions for Linux1. Set your ORACLE_HOME.2. If you are going to apply this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver. b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH. c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH.3. Copy the files in this patch to your ORACLE_HOME.4. Unzip the patch using either WinZip on NT or unzip on Unix.5. Run the install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19. 7


b. ./patch_install.sh 2>&1 tee patch_install_p19.log (ksh) c. ./patch_install.sh & tee patch_install_p19.log (csh)6. Check patch_install_p19.log for errors.7. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install Reports has both link-time and run-time dependency with libjava.so so you need to append $ORACLE_ HOME/network/jre11/lib/linux/native_threads in $LD_ LIBRARY_PATH before linking Reports. The same $LD_LIBRARY_PATH should be used at run-time. d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.6 De-Installation Instructions for Linux1. Set your ORACLE_HOME.2. If you originally applied this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH3. Run the de-install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19 b. ./patch_deinstall.sh 2>&1 tee patch_deinstall_ p19.log (ksh) c. ./patch_deinstall.sh & tee patch_deinstall_p19.log (csh)4. Check patch_deinstall_p19.log for errors.5. Relink Procedure Builder, Forms, Graphics and Reports: 1. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install 2. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install 3. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install 4. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install 8


4.2.7 Installation Instructions for Solaris1. Set your ORACLE_HOME.2. If you are going to apply this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver. b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH. c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH.3. Copy the files in this patch to your ORACLE_HOME.4. Unzip the patch using either WinZip on NT or unzip on Unix.5. Run the install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19. b. ./patch_install.sh 2>&1 tee patch_install_p19.log (ksh) c. ./patch_install.sh & tee patch_install_p19.log (csh)6. Check patch_install_p19.log for errors.7. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install Reports has both link-time and run-time dependency with libjava.so so you need to append $ORACLE_ HOME/network/jre11/lib/sparc/native_threads in $LD_ LIBRARY_PATH before linking Reports. The same $LD_LIBRARY_PATH should be used at run-time. d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install4.2.8 De-Installation Instructions for Solaris1. Set your ORACLE_HOME.2. If you originally applied this patch on top of an iAS install: a. Set ORACLE_HOME to <iAS_HOME>/6iserver b. Prepend <iAS_HOME>/6iserver/bin to the beginning of PATH c. Prepend <iAS_HOME>/6iserver/lib to the beginning of LD_ LIBRARY_PATH3. Run the de-install script contained in the patch: a. cd $ORACLE_HOME/developer6i_patch19 b. ./patch_deinstall.sh 2>&1 tee patch_deinstall_ p19.log (ksh) 9


c. ./patch_deinstall.sh & tee patch_deinstall_p19.log (csh)4. Check patch_deinstall_p19.log for errors.5. Relink Procedure Builder, Forms, Graphics and Reports: a. cd $ORACLE_HOME/procbuilder60/lib; make -f ins_ procbuilder.mk install b. cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install c. cd $ORACLE_HOME/graphics60/lib; make -f ins_ graphics60w.mk install d. cd $ORACLE_HOME/reports60/lib; make -f ins_ reports60w.mk install5 Platform Specific Bugs Fixed in Patch 19This section contains the following:■ Section 5.1, 'AIX5L (Oracle Forms)'5.1 AIX5L (Oracle Forms)5512158 APPS6: F60CTL CLOSES DOWN ALL F60WEBMX PROCESSES AFTERCHANGES FOR 39885836 Generic Oracle Forms 6i IssuesThis section contains the following:■ Section 6.1, 'Generic Bugs Fixed in Patch 19'■ Section 6.2, 'Patch 19 Not Certified with iDS 1.0.2.2'■ Section 6.3, 'Exception Is Raised When Block Has a Scrollbar'■ Section 6.4, 'Need to Specify a Path for Diagnostics Log Files'■ Section 6.5, 'Use Caution When Uninistalling Intersolve Drivers'6.1 Generic Bugs Fixed in Patch 195908245 RFI BACKPORT OF BUG 5753922 ON TOP OF VERSION 6.0.8.27 (RFI#52662)5905047 RFI BACKPORT OF BUG 5852332 ON TOP OF VERSION 6.0.8.27 (RFI#52562)5897423 RFI BACKPORT OF BUG 5893392 ON TOP OF VERSION 6.0.8.27 (RFI#52349)5895096 RFI BACKPORT OF BUG 5699501 ON TOP OF VERSION 6.0.8.27 (RFI#52260)5895091 RFI BACKPORT OF BUG 5759362 ON TOP OF VERSION 6.0.8.27 (RFI#52257) 10


5764276 RFI BACKPORT OF BUG 5373971 ON TOP OF VERSION 6.0.8.27 (RFI#50544)5752287 RFI BACKPORT OF BUG 5050754 ON TOP OF VERSION 6.0.8.27 (RFI#50233)5708715 RFI BACKPORT OF BUG 5438095 ON TOP OF VERSION 6.0.8.27 (RFI#49306)5692877 RFI BACKPORT OF BUG 5527100 ON TOP OF VERSION 6.0.8.27 (RFI#48943)5690335 RFI BACKPORT OF BUG 5650051 ON TOP OF VERSION 6.0.8.27 (RFI#48894)5663295 RFI BACKPORT OF BUG 5093536 ON TOP OF VERSION 6.0.8.27 (RFI#48453)5652874 RFI BACKPORT OF BUG 5474223 ON TOP OF VERSION 6.0.8.27 (RFI#48286)5652870 RFI BACKPORT OF BUG 5472440 ON TOP OF VERSION 6.0.8.27 (RFI#48285)5589483 RFI BACKPORT OF BUG 4099723 ON TOP OF VERSION 6.0.8.27 (RFI#47344)5512158 APPS6: F60CTL CLOSES DOWN ALL F60WEBMX PROCESSES AFTERCHANGES FOR 39885835374454 RFI BACKPORT OF BUG 5216496 ON TOP OF VERSION 6.0.8.27 (RFI#44646)5372408 RFI BACKPORT OF BUG 5200992 ON TOP OF VERSION 6.0.8.27 (RFI#44623)5218053 RFI BACKPORT OF BUG 5183020 ON TOP OF VERSION 6.0.8.27 (RFI#42841)5192516 APPS6:NLS:BACKPORT BUG#3512144 INTO 6I, REPORTS XMLENCODING5183020 APPS6: SERVLET FORMS60_REJECT_GO_DISABLED_ITEM USEDFOR LISTENER VALUE IN EM RTI5114103 RFI BACKPORT OF BUG 4895304 ON TOP OF VERSION 6.0.8.27 (RFI#40958)5097630 RFI BACKPORT OF BUG 4640704 ON TOP OF VERSION 6.0.8.27 (RFI#40531)5084303 RFI BACKPORT OF BUG 4439359 ON TOP OF VERSION 6.0.8.27 (RFI#40110)5028235 RFI BACKPORT OF BUG 4890922 ON TOP OF VERSION 6.0.8.27 (RFI#38787)4944321 RFI BACKPORT OF BUG 2046150 ON TOP OF VERSION 6.0.8.27 (RFI#37675)4913822 RFI BACKPORT OF BUG 4626660 ON TOP OF VERSION 6.0.8.27 (RFI#37291)4878351 RFI BACKPORT OF BUG 4768418 ON TOP OF VERSION 6.0.8.27 (RFI#36666) 11


4774212 RFI BACKPORT OF BUG 4261542 ON TOP OF VERSION 6.0.8.27 (RFI#36283)6.2 Patch 19 Not Certified with iDS 1.0.2.2Forms 6i Patch 19 is not certified with iDS 1.0.2.2.6.3 Exception Is Raised When Block Has a ScrollbarRunning a webform which has scroll bar on the block raises an exception in theJava console.6.4 Need to Specify a Path for Diagnostics Log FilesIf you don't specify a path for the log file, Oracle Forms will attempt to write it tothe $ORACLE_HOME/forms60/log directory. If this directory doesn't exist (itdoesn't by default), the log file won't be created.6.5 Use Caution When Uninistalling Intersolve DriversDo not uninstall Intersolve drivers (ODBC) from an ORACLE_HOME if otherproducts in another ORACLE_HOME on that computer use them. Uninstallingthe drivers from one ORACLE_HOME removes them from the entire system.6.6 Requirements for Using RUN_PRODUCT on the WebIf you use RUN_PRODUCT in a form to run a report and want to display theoutput in the browser window, it is necessary to do the following:■ On Windows computers, remove the TMP user environment variable.■ On Unix computers, remove the TMPDIR environment variable.6.7 Database Commands Available on Separate Start MenuIn this release, the database commands Build, Drop, Grant, and Revoke are listedon their own Start Menu, entitled 'Oracle Forms 6i Admin,' which is separatefrom the Start Menu for the main Forms product.6.8 Using Index-Only TablesIn order to use an index-only table in Forms, the block's Key Mode should be setto either Updatable or Non-Updatable. Also, a Primary Key should benominated.6.9 Forms-Reports Integration Requires that TMPDIR Not Be SetIn order for Forms-Reports integration to work on the web on a UNIX computer,the variable TMPDIR must not be set. Unset this environment variable beforestarting the Forms listener.6.10 Undocumented Error MessagesThis section contains information about the following: 12

It costs almost nothing and is cool, maybe even useful!Hardware: apart from the terminal itself, you need the appropriate type of serial cables (depends on hardware you have), a serial port, and a null modem. Card rescue mac serial terminal 3.


■ Section 6.10.1, 'Error Messages (93000-99999)'■ Section 6.10.2, 'Error Messages 10905-10909'6.10.1 Error Messages (93000-99999)Any Forms error message not documented in the online help will display ageneric message:FRM-99999 Error FRM-nnnnn occurred, please consult therelease notes.The details of these error messages are documented in Table 1:Table 1 Summary of FRM-99999 Error MessagesFRM-99999, Error 1412. An attempt was made to set scrollbar position on a block that has no scrollbar.FRM-99999, Error 1413. An attempt was made to get scrollbar position on a block that has no scrollbar.FRM-93000: Servlet internal error.Cause: A servlet error occurred, or runtime did not start properly.Action: See the error messages in the jserv.log file for clarification. Checkenvironment settings. Also, run servlet debug tracing.6.10.2 Error Messages 10905-10909FRM-10905: The following return values are invalid.Cause: The invalid return values must be corrected before you can leave thispage of the wizard.Action: Enter a valid return value. Return values must be one of the following:■ A fully qualified Item name (<BLOCK_NAME>.<ITEM_NAME>).■ A Form Parameter (PARAMETER.<PARAMETER_NAME>).■ A global PL/SQL variable (GLOBAL.<VARIABLE_NAME>).FRM-10906: One or more LOV columns has a negative width.Cause: One or more of the columns in the table has a negative width.Action: Ensure that no columns in the table have a negative width.FRM-10907: The LOV size or position has a negative value.Cause: One or more of the attributes of the LOV size and position is negative.Action: Ensure that none of the LOV size or position attributes is negative.FRM-10908: Number of rows retrieved is less than or equal to zero.Cause: The number of rows retrieved is less than or equal to zero.Action: Enter a value greater than zero for the number of records retrieved. 13


FRM-10909: Old Style LOVs cannot be modified using the LOV wizard.Cause: The LOV Wizard was invoked on an Old-Style LOV.Action: Create a new LOV based on a Record Group.6.10.3 Error Messages 13009-13010FRM-13009: The JavaBean does not implement the IView interface.Cause: For Forms to use this JavaBean, it must implement Oracle Forms IViewinterface.Action: Implement Oracle Forms oracle.forms.ui.IView Interface.FRM-18010: An unknown error occurred when attempting to process the JavaBean.Cause: For Forms to use this JavaBean, it must be able to locate the specifiedJavaBean and instantiate it.Action: Ensure that the specified JavaBean and supporting classes are installedcorrectly. Retry the JavaBean after restarting Form Builder.6.10.4 Error Messages 18114-18121FRM-18114: FORMS60_JAVADIR not set.Cause: For Web Preview from the Builder to work the Registry variableFORMS60_JAVADIR must point to the location that contains the Forms Java files.This variable should have been set by the Oracle Installer when Oracle FormsDeveloper was installed. A typical value for this variable isc:orantforms60java.Action: Create or update the registry variable on NT, FORMS60_JAVADIR, andset its value to the location that contains the Forms Java files.FRM-18115: CLASSPATH variable not set.Cause: For forms to run on the Web the environment variable CLASSPATH mustpoint to the location that contains a valid Java installation. This variable shouldhave been set by the Oracle Installer when Oracle Forms Developer wasinstalled.Action: Create or update the environment variable CLASSPATH and set its valueto the location that contains a valid Java installation.FRM-18116: The CLASSPATH does not contain a reference to Forms.Cause: For Forms Server to work, the environment variable CLASSPATH mustinclude an entry that points to a location containing the Java files required byOracle Forms. An entry should have been added to the existing CLASSPATHvariable by the Oracle Installer when Oracle Forms Developer was installed. Atypical value for this variable is c:orantforms60java.Action: Create or update the environment variable CLASSPATH and set its valueto the location that contains the Java files required by Oracle Forms. 14


FRM-18117: The preferences contains a reference to a non-existent HTML file.Cause: In the 'Runtime' Preferences dialog an HTML file has been specified, butthat HTML file does not exist, or the location specified does not exist.Action: In the 'Runtime' Preferences dialog either remove the reference to theoffending HTML file, so that the default HTML file is used, or specify an HTMLfile that exists. Alternatively place the HTML file in the location specified.FRM-18118: Javai.DLL does not exist.Cause: For Forms Server to work in the Microsoft Windows environment, e.g.Windows NT, javai.dll must exist and be in the %ORACLE_JDK%bindirectory, where %ORACLE_JDK% contains a valid Java installation.Action: Determine whether javai.dll exists in the %ORACLE_JDK%bindirectory, and if necessary, reinstall the Oracle JDK.FRM-18119: ORACLE_JDK variable not setCause: For Forms Server to work, the environment variable ORACLE_JDK mustpoint to the location that contains a valid Java installation. This variable shouldhave been set by the Oracle Installer when Oracle Forms was installed.Action: Create or update the environment variable ORACLE_JDK and set its valueto the location that contains a valid Java installation.FRM-18120: libjava.so does not exist.Cause: For Forms Server to work in the Solaris environment, a valid JDKinstallation must exist and be in the path.Action: Determine whether a valid JDK exists in the path and if necessary,reinstall the JDK.FRM-18121: The JavaBean does not implement the IView interface.Cause: For Forms to use this JavaBean, it must implement Oracle Forms IViewinterface.Action: Implement Oracle Forms oracle.forms.ui.IView Interface.7 Generic Oracle Reports 6i IssuesNone.8 Oracle Forms 6i Platform-Specific IssuesNone.9 Oracle Reports 6i Platform-Specific IssuesNone.10 Source of Additional InformationYou can review previous Release Notes for Oracle Forms and Reports Developerand Oracle Forms and Reports Services 6i at Oracle MetaLink,https://metalink.oracle.com/. 15


11 Documentation AccessibilityOur goal is to make Oracle products, services, and supporting documentationaccessible, with good usability, to the disabled community. To that end, ourdocumentation includes features that make information available to users ofassistive technology. This documentation is available in HTML format, andcontains markup to facilitate access by the disabled community. Accessibilitystandards will continue to evolve over time, and Oracle is actively engaged withother market-leading technology vendors to address technical obstacles so thatour documentation can be accessible to all of our customers. For moreinformation, visit the Oracle Accessibility Program Web site athttp://www.oracle.com/accessibility/.Accessibility of Code Examples in DocumentationScreen readers may not always correctly read the code examples in thisdocument. The conventions for writing code require that closing braces shouldappear on an otherwise empty line; however, some screen readers may notalways read a line of text that consists solely of a bracket or brace.Accessibility of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies ororganizations that Oracle does not own or control. Oracle neither evaluates normakes any representations regarding the accessibility of these Web sites.TTY Access to Oracle Support ServicesOracle provides dedicated Text Telephone (TTY) access to Oracle SupportServices within the United States of America 24 hours a day, seven days a week.For TTY support, call 800.446.2398.Oracle Forms and Reports Developer and Oracle Forms and Reports Services 6i (Patch 19), Release 6.0.8.28 for Microsoft Windows andUnixCopyright © 2006, 2007 Oracle. All rights reserved.The Programs (which include both the software and documentation) contain proprietary information; they are provided under a licenseagreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrialproperty laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperabilitywith 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, pleasereport them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreementfor 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 StatesGovernment, 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 AcquisitionRegulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of thePrograms, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle licenseagreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--RestrictedRights (June 1987). Oracle USA, Inc., 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 shallbe the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of suchapplications 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 Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may betrademarks 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 responsiblefor the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If youchoose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is notresponsible 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 forany loss or damage of any sort that you may incur from dealing with any third party. 16


This appendix contains screenshots and descriptions for the Oracle Portal, Forms, Reports and Discoverer Patch Set Installer screens:

A.1 Welcome


This page introduces you to the Oracle Fusion Middleware installer and provides two important pieces of information:

  • A navigation pane on the left that summarizes the tasks the installer will help you complete. Each item in the navigation pane represents a specific installer screen that will prompt you for information required to install the software.

  • Information about any prerequisites you might need to perform before continuing with the installation.

Review the information on this screen carefully to be sure you have performed all the necessary prerequisites.

A.2 Specify Installation Location


Use this screen to identify the Oracle home directory you want to patch.

The following table describes the fields that appear on this page.

FieldDescription

Oracle Middleware Home

Use this field to specify the absolute path to your existing Oracle Middleware home directory; this is the directory that was created when you installed Oracle WebLogic Server. If you do not know the full path to your Middleware home, you can click Browse to select an existing directory in your system.

Oracle Home Directory

Use this field to specify the existing product Oracle home directory inside the Oracle Middleware home. This is the directory that will be patched with this installation.

NOTE: If you are performing an installation on a Windows operating system, be sure that your directory paths are valid and do not contain double backslashes ().

NOTE: If you specify an Oracle home directory that has already been patched, then you will receive an error message and the installation will not continue. Re-patching an Oracle home is not supported.


A.3 Specify Security Updates


Use this screen to enter your My Oracle Support account information so you can receive the latest product information and security updates via your My Oracle Support account.

The following table describes the fields on this screen.

ElementDescription

Email

Enter the email address you used to register with My Oracle support.

I wish to receive security updates via My Oracle Support

Select this check box to indicate that you have a My Oracle Support account and that you want to receive updates via My Oracle Support.

My Oracle Support Password

Enter the password for your My Oracle Support account.


If you do not want to register for security updates or if you do not have a My Oracle Support account, then leave all the fields on this screen empty. You will be prompted to confirm your selection; click Yes in the dialog box:

A.4 Installation Summary


This screen summarizes the selections you have made during this session. It includes the following information:

  • The location of the software that will be patched

  • How much disk space will be used for the installation of the patch

  • The applications that will be patched

Review information on this screen carefully, and take one of the following actions:

  • If you want to make any changes to the configuration before starting the installation of the patch, use the navigation pane to select the Installer screen you want to return to and edit.

  • If you are satisfied with the information, click Install to begin the installation procedure.

  • If you want to save this configuration to a text file (called a response file), click Save. The resulting response file can be used later if you choose to perform the same installation from the command line.

A.5 Installation Progress


This screen shows you the progress of the installation.

If you want to quit before the installation is completed, click Cancel. Doing so will result in a partial installation; the portion of the software that was installed on your system before you click Cancel will remain on your system, and you will have to remove it manually.

A.6 Installation Complete


This screen summarizes the installation that was just completed.

If you want to save this summary information to a text file for future reference, click Save.

Click Finish to dismiss the screen.