Minimum JRE Release
JRE 8 Update 301 or later (for macOS Big Sur and earlier clients) 1
JRE 8 Update 181 or later (for multiple Forms session support) 2
JRE 8 Update 171 or later (for macOS Catalina and earlier clients) 3
JRE 8 Update 144 b01 Patch 26512977 or later 4
JRE 8 Update 141 b15 Patch 25951321 5
JRE 8 Update 131 b31 Patch 25767257
JRE 8 Update 121 b33 Patch 25450542 - To be applied
4.2.1 Minimum Prerequisites
The following lists the minimum codelevels required to install Java Web Start on Oracle E-Business Suite Release 12.2.
Oracle E-Business Suite Release 12.2.3
R12.AD.C.Delta.8
R12.TXK.C.Delta.8
R12.ATG_PF.C.Delta.6
Using below queries
to Check the AD, TXK and ATG Patch Level
select bug_number,
decode(bug_number,17919161, 'R12.2.4',
19676458, 'R12.2.5',
21900901, 'R12.2.6',
24690690, 'R12.2.7',
26787767, 'R12.2.8',
28840850, 'R12.2.9',
30399999, 'R12.2.10',
31856789, 'R12.2.11',
33527700, 'R12.2.12',
17909318,
'R12.ATG_PF.C.Delta.4',
19245366,
'R12.ATG_PF.C.Delta.5',
21900895,
'R12.ATG_PF.C.Delta.6',
24690680,
'R12.ATG_PF.C.Delta.7',
28840844,
'R12.ATG_PF.C.Delta.8',
30399994,
'R12.ATG_PF.C.Delta.9',
31856779,
'R12.ATG_PF.C.Delta.10',
33527666,
'R12.ATG_PF.C.Delta.11',
17766337,
'R12.AD.C.DELTA.4',
18283295,
'R12.AD.C.DELTA.5',
19197270,
'R12.AD.C.DELTA.6',
20745242,
'R12.AD.C.DELTA.7',
21841299,
'R12.AD.C.DELTA.8',
25178222,
'R12.AD.C.DELTA.9',
25820806,
'R12.AD.C.DELTA.10',
26834480, 'R12.AD.C.DELTA.11',
30628681,
'R12.AD.C.DELTA.12',
32394134,
'R12.AD.C.DELTA.13',
33600809,
'R12.AD.C.DELTA.14',
17893964,
'R12.TXK.C.DELTA.4',
18288881,
'R12.TXK.C.DELTA.5',
19330775,
'R12.TXK.C.DELTA.6',
20784380,
'R12.TXK.C.DELTA.7',
21830810, 'R12.TXK.C.DELTA.8',
25180736,
'R12.TXK.C.DELTA.9',
25828573,
'R12.TXK.C.DELTA.10',
28840822,
'R12.TXK.C.DELTA.11',
30735865,
'R12.TXK.C.DELTA.12',
32392507,
'R12.TXK.C.DELTA.13',
33602997,
'R12.TXK.C.DELTA.14',
bug_number)
ARU_RELEASE_NAME
from AD_BUGS b
where b.BUG_NUMBER in
('17919161','19676458','21900901','24690690','26787767','28840850','30399999','31856789','33527700','17909318','19245366','21900895','24690680','28840844','30399994',
'31856779','33527666','17766337','18283295','19197270','20745242','21841299','25178222','25820806','26834480','30628681','32394134','33600809','17893964','18288881','19330775',
'20784380','21830810','25180736','25828573','28840822','30735865','32392507','33602997')
order by
ARU_RELEASE_NAME, BUG_NUMBER;
SELECT fa.application_id
Appl_ID,
fa.application_short_name
"Appl_short_name",
fa.application_name "Application_Name",
decode( fpi.status,
'I', 'Installed', 'S', 'Shared', 'N', 'Not Installed', 'Customized ?' ) Status,fpi.patch_level Patch_Level
FROM apps.fnd_application_all_view fa,
apps.fnd_product_installations
fpi
WHERE
fa.application_id = fpi.application_id
ORDER BY 2;
SELECT
V.APPLICATION_NAME app
,
to_char(V.APPLICATION_ID) appId
, L.MEANING appStatus
,
DECODE(I.PATCH_LEVEL, NULL, '11i.' || v.APPLICATION_SHORT_NAME || '.?',
I.PATCH_LEVEL) patch
FROM
apps.FND_APPLICATION_ALL_VIEW V, apps.FND_PRODUCT_INSTALLATIONS I,
apps.FND_LOOKUPS L
WHERE
(V.APPLICATION_ID = I.APPLICATION_ID)
--AND
(V.APPLICATION_ID IN
--('0', '50', '178',
'231', '275', '453', '603', '800', '801', '802', '803', '804', '805', '808',
'809', '810', '8301',
--'8302', '8303'))
AND (L.LOOKUP_TYPE =
'FND_PRODUCT_STATUS')
AND (L.LOOKUP_CODE =
I.Status )
ORDER BY 1;
SELECT ABBREVIATION,NAME,codelevel FROM
AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad','atg');
Applying Patches to
Oracle E-Business Suite Release 12.2.7
1) Oracle Forms 10g and application technology patches to Oracle E-Business Suite Release 12.2
Check the Patches Applied or Not on Oracle 10g Form - $ORACLE_HOME/OPatch/opatch lsinventory|grep 25441839
Source the APPS environment.
$ source <EBS_ROOT>/EBSapps.env run
Start a new online patch cycle.
$ adop phase=prepare
Apply the Oracle Forms 10g technology patch.
$ source <EBS_ROOT>/EBSapps.env patch
$ORACLE_HOME/OPatch/optach apply 25441839
2) Apply the required Oracle E-Business Suite application technology patches (AD/TXK/FND) bfor Oracle E-Business Suite Release 12.2.
Download the 24498616,25449925,25380324 pathes to $PACTH_TOP and unzip the patches
$ adop phase=apply patches=24498616,25449925,25380324 merge=yes
3) Apply product-specific patches (English plus Arabic) as needed for Oracle E-Business Suite Release 12.2 using adop for those products that are in use. These product-specific patches add support for Java Web Start for non-Forms Java applets in Oracle E-Business Suite.
a) Oracle Workflow Status Diagram; Notification signing with Digital Signature - Patch 28713780:R12.OWF.C
b) Oracle Scripting Script Author - Patch 23475123:R12.IES.C
c) Oracle Customers Online Party Relationships - Patch 23280764:R12.IMC.C
d) Oracle General Ledger Account Hierarchy Manager - Patch 23645622:R12.GL.C
e) Oracle Sourcing Auction Monitor - Patch 23575933:R12.PON.D
f) Oracle Installed Base Visualizer Applet - Patch 22221603:R12.CSI.C
g) Oracle Advanced Supply Chain Planning Plan Editor (PS/SNO) - Patch 23586286:R12.MSC.C
h) Oracle Process Manufacturing Recipe Designer - Patch 24833534:R12.GMD.C
Download English and Arabic patches 28713780, 23475123, 23280764, 23645622, 23575933, 22221603, 23586286, 24833534 to $PATCH_TOP and unzip the patches
$ adop phase=apply patches=28713780
$ adop phase=apply patches=28713780_AR:u28713780.drv
$ adop phase=apply patches=23475123
$ adop phase=apply patches=23475123_AR:u23475123.drv
$ adop phase=apply patches=23280764
$ adop phase=apply patches=23280764_AR:u23280764.drv
$ adop phase=apply patches=23645622
$ adop phase=apply patches=23645622_AR:u23645622.drv
$ adop phase=apply patches=23575933
$ adop phase=apply patches=23575933_AR:u23575933.drv
$ adop phase=apply patches=22221603
$ adop phase=apply patches=22221603_AR:u22221603.drv
$ adop phase=apply patches=23586286
$ adop phase=apply patches=23586286_AR:u23586286.drv
$ adop phase=apply patches=24833534
$ adop phase=apply patches=24833534_AR:u24833534.drv
4) Use the AD Administration tool (adadmin) to regenerate JAR files with force option
$ source <EBS_ROOT>/EBSapps.env patch
$ adadmin
Navigation: Generate Applications Files Generate product JAR files
Regenerate JAR files with FORCE option set to Yes
Do you wish to force regeneration of all jar files? [No] ? Yes
Complete the online patch cycle.
5) $ adop phase=finalize,cutover
6) Follow these instructions to enable Java Web Start in Oracle E-Business Suite:
- backup of context file
- updated parameter like <config_option oa_var="s_forms_launch_method" type="techstack">jws</config_option>
- Change below Profile Options
1. Enable Java Web Start / FND_ENABLE_JAVA_WEB_START Yes
2. ICX: Forms Launcher / ICX_FORMS_LAUNCHER https://nizamappsdba.com:4443/forms/frmservlet?config=jws
Stop all application tier services.
$ sh <ADMIN_SCRIPTS_HOME>/adstpall.sh
Run AutoConfig on the application tier.
$ sh <ADMIN_SCRIPTS_HOME>/adautocfg.sh
Start all application tier services.
$ sh <ADMIN_SCRIPTS_HOME>/adstrtal.sh
7) Cleanup and fs_clone
$ source <EBS_ROOT>/EBSapps.env run
Perform a cleanup of the online patch cycle.
$ adop phase=cleanup
Synchronize the patch file system with the new run file system.
$ adop phase=fs_clone
Reference: Using Java Web Start with Oracle E-Business Suite (Doc ID 2188898.1)