Upgrading Application with Forms Patchset 18

Action Plan for Forms Patchset 18 Upgrade (4948577)


1. Take a backup of the the Printer File.

If you have customized the printer configuration file located in ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt with your printer definitions, you will have to redo the configurations after applying the Developer 6i patch. Your previous uiprint.txt is backed up as $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt.PRE_P4948577

cp $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt.PRE_P4948577

2. Apply the Main Patch 4948577
3. Apply the Apps Interop Patch 4888294 ----11i Patch


Apply the Additional Patches

a. Apply the Patch 4968700

To apply this patch, please follow the steps below:

1) Stop your web listeners and Forms Server.

2) Make a patch directory for this bug, and put your patch files in it:
% cd $ORACLE_HOME
% mkdir bug5034714
% cd bug5034714
% cp bug5034714.zip to $ORACLE_HOME/bug5034714
% unzip bug5034714.zip

3) If you don't have genshlib in $ORACLE_HOME/bin directory then copy this
file over there.
% cp genshlib $ORACLE_HOME/bin
% chmod ug+x $ORACLE_HOME/bin/genshlib

4) Copy your original objects in case you ever need it:
% cd $ORACLE_HOME/lib
% cp libiffw.a libiffw.a.pre5034714
% cp libiwfw.a libiwfw.a.pre5034714

5) Archive objects into the libraries:
% ar rv libiffw.a $ORACLE_HOME/bug5034714/iftm.o
% ar rv libiwfw.a $ORACLE_HOME/bug5034714/iwit.o

6) Generate the shared libraries:
% cd $ORACLE_HOME/lib
% $ORACLE_HOME/bin/genshlib iwfw 0
% $ORACLE_HOME/bin/genshlib iffw 0

7) Generate forms executables
% cd $ORACLE_HOME/forms60/lib
% make -f ins_forms60w.mk install

Note: If you are an Oracle Applications customer, please also run adrelink.
E.g. to relink f60webmx for Oracle Applications:
% adrelink.sh force=y "fnd f60webmx"

8) Restart Forms server and Web listeners.


b. Apply the Patch 4261542.

Installation instructions for Apps customers
--------------------------------------------

[Part 1] Shut down the listeners and copy the patch files

1. Stop your web listeners and Forms Server.

2. Make a patch directory within your 6i ORACLE_HOME and unzip this file
within it to create a new subdirectory. You will be able to see the
folder 4261542 which contains the actual one-off files.

%cd $ORACLE_HOME
%unzip p4261542_600_GENERIC.zip


[Part 2] Unzip the java class files and regenerate your JAR files

3.Backup the Forms class files, i.e.$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542



4. Inside folder 4261542 in step-2 has class files in oracle\forms\engine directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/engine
%cd $ORACLE_HOME/4261542/oracle/forms/engine
%cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
%cd $ORACLE_HOME/4261542/oracle/forms/handler
%cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class


5. Make sure that you have set up custom certificates for JAR file signing.
Run adadmin administration utility. Select the "Maintain Files" option
and then the "Generate JAR Files" sub-option.

6. Spot check that the JAR files have been generated by verifying the timestamp.

[Part 3] Restart the listeners

7. Restart the Forms Server.

8. Restart the web listener serving Forms Applets (e.g. Apache or WebDB 2.2).


c. Apply the Patch 5216496.

- Not Availbale for HP TRU64.


STEPS INVOLVED in PATCHING

STEPS Involved in patching
***************************

1. Install the Developer 6i Patch

2. Install the Additional Developer 6i Patches

3. Relink Applications Executables on UNIX Platforms


You can relink these executables by running adadmin
When the Main Menu appears select 'Maintain Applications Files Menu' and then select 'Relink Applications Program'
Answer the questions below as follows, in order to select the individual executables for relinking.

Enter list of products to link ('all' for all products)[all] : fnd
Generate specific executables for each selected product [No] ? y
Relink with debug information [No] ? n

(You will then be offered a list of executables that are available for relinking)

Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund *

* In a multi-node configuration, not all these executables exist on each node. The list of executables will show those that do exist on the node you are currently running on, and only those should be entered to avoid errors.

Refer to the Maintaining Oracle Applications manual for more information on how to use the AD Administration Utility or AD Relink Utility for relinking executables.


4. Apply the Oracle Applications 11i Interoperability Patch


5. Verify your upgrade

Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in the $OA_JAVA/oracle/apps/fnd/jar directory. If the timestamp is not current and the previous steps completed successfully, run the AD Administration Utility (adadmin), select Maintain Applications Files, then select Generate Product JAR Files. Do not force the regeneration of all JAR files. Again, verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.
If your JAR files are still not updated, verify all the prior steps, and the Known Issues section below.
If you have applied Developer 6i Patch 6 or above, verify that the PL/SQL version installed is 8.0.6.3.x. You can run '$ORACLE_HOME/bin/f60gen help=y' to display various component versions. (If the version shown is still 8.0.6.0.x please refer to Metalink Note 191573.1 )
For Microsoft Windows platforms, look under Control Panel - Services to see if additional Forms and Reports services were added. If so, disable the new ones by pressing the Startup button, and setting the Startup Type toDisabled.


6. Start the Forms, Reports, HTTP, Concurrent Manager Servers

a. Stop the Forms Server process.

b. Add the following environment variable to the 'Oracle Forms 6.0 environment variables' section of
your '$APPL_TOP/< SID >.env' file as;

FORMS60_RESTRICT_ENTER_QUERY="TRUE"
export FORMS60_RESTRICT_ENTER_QUERY

c. Source the environment, then restart the Forms Server process