Introduction:

Some times we face problem due to older version or incorrect version of developer 6i in Oracle Applications 11i. For example I can explain my scenario, where I had to upgrade Forms Developer 6i version from Patch level 17 to Patch level 18.

I was trying to apply patch 6372396 TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH S (APRIL/MAY 2008) to one of the environment. In the pre-reqs section it ask to run txkprepatchcheck.pl script to generate the report, which will actually carry out the analysis of the techstack level in your environment and whether all the techstack level is sufficient enough to apply this patch.

In my case if gave me a report as shown in this link.

So I had to upgrade my Developer 6i version. You can get the current version of Forms Developer 6i by logging on application side and sourcing the environment and running following command

$ORACLE_HOME/bin/f60gen help=y

Upgrading Developer 6i Home:

Following are the steps performed for upgrading developer 6i from 6.0.8.26.0 (Patch 17) to 6.0.8.27.0 (Patch 18). (The steps are followed from metalink note ID 125767.1)

1) Check if you have a latest version of Oracle Jinitiator in your application.

Oracle JInitiator is now available on two streams of JDK for Oracle Applications 11i customers. Customers may continue to use JInitiator 1.1.8.x (JDK 1.1 based) or move to JInitiator 1.3.1.x (JDK 1.3 based). In some cases, migration to JInitiator 1.3.1.x requires additional technology upgrades. Please review the list of requirements in MetaLink Note 124606.1 (Upgrading Oracle JInitiator with Oracle Applications 11i) to determine feasibility of migration to JInitiator 1.3.1.x at this time. We strongly recommend you upgrade to the latest version of Oracle JInitiator certified with Applications along either stream.

If you don’t have latest version for Oracle Jinitiator, then you can upgrade the same using this link.

2) Apply Developer 6i Patch set (4948577). This is the techstack patch set and needs to be applied to 8.0.6 oracle home.

Following steps are to be done for applying the patch

• Download patch 4948577 from metalink
• Set ORACLE_HOME to your 8.0.6 forms oracle home
• unzip the patch in you 8.0.6 oracle home
• cd $ORACLE_HOME/developer6i_patch18
  ./patch_install.sh 2>&1 | tee patch_install_p18.log (ksh)
  ./patch_install.sh |& tee patch_install_p18.log (csh)
• Check patch_install_p18.log for errors.
• Relink Procedure Builder, Forms, Graphics and Reports:
  cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
  cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
  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 either one of:
  $ORACLE_HOME/network/jre11/lib/linux/native_threads
  $ORACLE_HOME/network/jre11/lib/i686/native_threads
  in $LD_LIBRARY_PATH before linking Reports.
  Please check your files under $ORACLE_HOME/network/jre11/lib to see which one of the above is appropriate on your system. The same $LD_LIBRARY_PATH should be used at run-time.

  cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install

3) Applying the additional patches as mentioned in metalink docs

• 5713544
• 4261542
• 5216496
• 5753922 – If your database is 9i, skip this patch as this is for database 10g
• 6195758
• 5938515

After applying the Oracle Developer 6i Patch and apps interop on UNIX platforms, you must relink several Oracle Applications executables to include Developer patch changes. The executables are f60webmx,  ar60run , ar60runb, ar60rund, and are all owned by FND.

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 *

4) Download and apply the apps interop patch (4888294)

This completes the upgrade of developer 6i home from 6.0.8.26.0 (Patch 17) to 6.0.8.27.0 (Patch 18).

Run the txkprepatchcheck.pl report once again and check and you will see the report as shown by this link.

Hope this helps !!

Reference:

Metalink Note ID: 125767.1