Java Web Start Configuration in Oracle EBS 12.2.6

Java Web Start Configuration in Oracle EBS 12.2.6

Pre-Requisite

              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)

 

 


appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post