We will apply several major release updates, and they will create thousand of entries in the ad tables. So we need to add data files to prepare for the massive data growth:
xxxxxxxxxx(fresh install)ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE 'C:\ORACLE\TST\DATA\A_TXN_DATA05.DBF' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 1G;ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE 'C:\ORACLE\TST\DATA\A_TXN_DATA06.DBF' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 1G;(Vision install)ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE 'C:\ORACLE\VIS\DATA\A_TXN_DATA28.DBF' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 1G;ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE 'C:\ORACLE\VIS\DATA\A_TXN_DATA29.DBF' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 1G;ALTER TABLESPACE APPS_TS_TX_IDX ADD DATAFILE 'C:\ORACLE\VIS\DATA\TX_IDX22.DBF' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 1G;
Unzip patch 19676458 (EBS 12.2.5 Release Update) to %PATCH_TOP%. Make sure you unzip ALL files for this patch. Then apply it using downtime mode:
adop phase=apply patches=19676458 apply_mode=downtime
When it's done, do the cleanup
adop phase=cleanup
Right now only the Internet Explorer in Windows 2008 Server is able to open the Form. For current browsers, Form can only be launched by using recent JRE with Java WebStart (JWS). So in order to really make the EBS instance functional, we must patch it to use JWS.
Apply Patch 21900895 (R12.ATG_PF.C.delta.6: R12.ATG_PF.C.DELTA.6). It is the prereq for the JRE and JWS patches:
adop phase=apply patches=21900895 hotpatch=yes
Then apply these patches
26100397* - Applications R12 Interoperability Patch for JRE Plugin (not needed as it is included in R12.TXK.C.DELTA.17)
25380324 - Oracle E-Business Suite Java Applets launching with Java Web Start
32902510 - JWS AND JRE (8u291 AND LATER) COMPATIBILITY PATCH
adop phase=apply patches=25380324 hotpatch=yes
adop phase=apply patches=32902510 hotpatch=yes
You must get the valid adkeystore.dat and adsign.txt file pair from some other systems, or you can prepare your own certificate. You also need to know the passphase of the keystore and the certificate.
replace adkeystore.dat and adsign.txt in %APPL_TOP_NE%\ad\admin
Run adjss to setup the keystore:
xxxxxxxxxxadjss -mode KEYSTORE ^-keystore %APPL_TOP_NE%\ad\admin\adkeystore.dat ^-alias symbolthree ^ <-- the alias of the certificate-sigfile CUST
Run adjss -verify to check whether the data is valid.
Download the latest JRE 8 for Windows (8u451 at the time of writing this doc)
https://www.oracle.com/ca-en/java/technologies/javase/javase8u211-later-archive-downloads.html
Rename jre-8u451-windows-x64 to j2se18451.exe and copy it to %COMMON_TOP%\webapps\oacore\util\javaplugin
Run %FND_TOP%\bin\txkSetPlugin.cmd %APPL_TOP%\APPS<SID>_<host>.cmd 18451
Change autoconfig file (%CONTEXT_FILE%) variable s_forms_launch_method to jws, shutdown all app services and run %ADMIN_SCRIPTS_HOME%\adautocfg.
You must upgrade the Weblogic server and IAS stack to work with the latest JWS and JRE.
Download and apply patch 12426828 (Smart Update 3.3.0) to update the BSU program:
xxxxxxxxxxunzip p12426828_1035_Generic.zipjava -jar patch-client-installer330_generic32.jar
the Middleware Home Directory is defaulted. Use Typical Install Type.
Further apply patch 31136426 (SMART UPDATE TOOL ENHANCEMENT V4) for patch preformance:
xxxxxxxxxxunzip -o p31136426_1036_Generic.zip -d %FMW_HOME%\utils\bsucd %FMW_HOME%\utils\bsubsu_update installInstalling Smart Update V4...Updating bsu modules1 file(s) copied.1 file(s) copied.1 file(s) copied.1 file(s) copied.1 file(s) copied.Update was successful
Now you can upgrade the Weblogic server by patch 35710802 (EBS REHOSTED: 35586779 WLS PATCH SET UPDATE 10.3.6.0.231017)
Extract these files from p35586779_1036_Generic.zip to %FMW_HOME%\utils\bsu\cache_dir
E7HI.jar
patch-catalog_27994.xml
xxxxxxxxxxcd %FMW_HOME%\utils\bsubsu.cmd -remove -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -prod_dir=%FMW_HOME%\wlserver_10.3 -verbosebsu.cmd -remove -patchlist=Y5AP,FCX7,YHJK,YVDZ -prod_dir=%FMW_HOME%\wlserver_10.3 -verbosebsu.cmd -prod_dir=%FMW_HOME%\wlserver_10.3 -patchlist=E7HI -verbose -install
Download and apply patch 32960401 to upgrade Oracle Form:
xxxxxxxxxxSET PATH=C:\oracle\TST\fs1\EBSapps\10.1.2\OPatch;%PATH%SET ORACLE_HOME=C:\oracle\TST\fs1\EBSapps\10.1.2cd D:\patch\32960401opatch apply
Update JDK (32bit and 64bit) from 7u85 to 7u351 in %COMMON_TOP%\util.
Download the patch 34170415 (Oracle SERVER JRE 7 Update 351) - Windows 64 and 32bit, then extract file server-jre-7u351-windows-x64.tar.gz and server-jre-7u351-windows-i586.tar.gz
Rename the jdk32 and jdk64 folders to jdk32_old and jdk64_old. Receate these 2 folders.
Unzip the tar.gz files to respectively folder.
Copy the font files LBANWT*.ttf in folder jre\lib\fonts from the old jdk to the new jdk.
Run adadmin to force regenerate all jar files and relink all binaries
xxxxxxxxxx1. Generate Applications Files menu => 4. Generate product JAR files => Do you wish to force regeneration of all jar files? [No] ? yes2. Maintain Applications Files and Registry menu => 1. Relink Applications programs => (take default options)
Shutdown all services. Enable all clock sync features to make new Profile Options to become effective.
Now you have a EBS 12.2.5 instance and you can use current browser to launch the Form. It's actually a very solid release and most of the bugs in previous releases are fixed. However we need to catch up the OS version in order to fit the current standard. We'll do this update in the next part.
If everything looks good, clean up the following folders:
%PATCH_TOP%
%LOG FILE%
PHASE A is completed. You can make a backup of the whole OS (VM files).
© 2026 by Christopher Ho. All Rights Reserved