Upgrade EBS R12.2 To Java 1.8

 1-Apply Patch 21624242

2-Cutover

3-Cleanup

4-Stop the application

5-Download the plugin under

$COMMON_TOP/webapps/oacore/util/javaplugin

6-Run the txkSetPlugin.sh script

 -bash-4.4$ txkSetPlugin.sh 18202

7- Generate the Product jar file with force option using adadmin utility

8- start the application

ADOP failed An error occurred while generating Oracle Forms files

 

ADOP patch session fail form / report compilation

Error log :-

 An error occurred while generating Oracle Forms files.

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

Solution:- 

 abandon=no restart=yes flags=autoskip

example:  adop phase=apply patches=25738975 abandon=no restart=yes flags=autoskip
 
 In addition to the autoskip option creates a new logfile called asautoskip.log 

EBS R12.2 Enable JWS from backend

--SELECT *

--FROM fnd_profile_options_tl

--WHERE user_profile_option_name = 'Enable Java Web Start';

--- FND_ENABLE_JAVA_WEB_START 

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('FND_ENABLE_JAVA_WEB_START', 'Yes', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

---

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

-----------------

--ICX: Forms Launcher

SELECT *

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'ICX: Forms Launcher';

-- ICX_FORMS_LAUNCHER

SELECT po.profile_option_name "NAME", po.user_profile_option_name,

DECODE (TO_CHAR (pov.level_id),

'10001', 'SITE',

'10002', 'APP',

'10003', 'RESP',

'10005', 'SERVER',

'10006', 'ORG',

'10004', 'USER',

'???'

) "LEV",

DECODE (TO_CHAR (pov.level_id),

'10001', '',

'10002', app.application_short_name,

'10003', rsp.responsibility_key,

'10005', svr.node_name,

'10006', org.NAME,

'10004', usr.user_name,

'???'

) "CONTEXT",

pov.profile_option_value "VALUE"

FROM fnd_profile_options_vl po,

fnd_profile_option_values pov,

fnd_user usr,

fnd_application app,

fnd_responsibility rsp,

fnd_nodes svr,

hr_operating_units org

WHERE 1 = 1

AND pov.application_id = po.application_id

AND pov.profile_option_id = po.profile_option_id

AND usr.user_id(+) = pov.level_value

AND rsp.application_id(+) = pov.level_value_application_id

AND rsp.responsibility_id(+) = pov.level_value

AND app.application_id(+) = pov.level_value

AND svr.node_id(+) = pov.level_value

AND org.organization_id(+) = pov.level_value

and po.user_profile_option_name = 'ICX: Forms Launcher'

ORDER BY NAME, pov.level_id, VALUE;

Add

--http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

 Apply Oracle Forms 10g Technology Patch 32960401

Generate JAR files with force option from adadmin

EBS R12 Update profile option from backend script

 SELECT *

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'Enable Java Web Start';

--- FND_ENABLE_JAVA_WEB_START 

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('FND_ENABLE_JAVA_WEB_START', 'Yes', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

Oracle EBS R12.2 Bounce Script

 . /u02/EBS/ADPF/EBSapps.env run

adstpall.sh apps/apps4adpf<<EOF

Welcome_1

EOF

echo "Waiting for 60 seconds..."

sleep 60

ps aux  |  grep FNDLIB  |  awk '{print $2}'  |  xargs  kill -9

ps aux  |  grep FNDSM  |  awk '{print $2}'  |  xargs  kill -9

ps aux  |  grep FND

. /u02/EBS/ADPF/EBSapps.env run

adstrtal.sh apps/apps4adpf<<EOF

Welcome_1

EOF

EBS r12.2 NLS Patch ARABIC

 

Translation Synchronization patches or Addition of Patches

Reference Note id's:
********************
R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)
Oracle Applications NLS Release Notes, Release 12.1 (Doc ID 788053.1)
How To Apply An NLS Patch Again When The Maintain MultiLingual Step Is Missed (Doc ID 1623652.1)

1.Shutdown required MT and DB services
2.Take  required backup
3.Start the DB and MT services.
4.Install the required Language (Arabic) from OAM.

Enabling the Arabic from OAM, folllow the below steps
Login to OAM as a sysadmin -> sitemap -> License Manager -> License -> Languages And license the following language

Enable the below languages

a. Arabic


Note:Make sure you should not change the base language, it should be english.

5.Validate the language activated

Login to application with apps user and execute the below command.

Select NLS_LANGUAGE from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

Make sure you get below result.

a. Arabic


Here base lang is American

5. Stop MT services
6.Run Maintain Multi-lingual Tables

      4.Maintain Applications Database Entities
              
         3. Maintain multi-lingual tables

AD Administration Main Menu > Maintain Applications Database Entities Menu using adadmin.

7.Run Update current view snapshot from adadmin

adadmin -> Maintain Applications Files -> Maintain snapshot information -> Update current view snapshot)

             2.    Maintain Applications Files menu

                4.    Maintain snapshot information

                   2.    Update current view snapshot

                      1.    Update Complete APPL_TOP

8.Run the Translation Synchronization Patch utility (adgennls.pl)

Login to applmgr user in application tier, make sure enviorment is sourced properly and execute the following command

perl $AD_TOP/bin/adgennls.pl

Above command will genertate the manifest file which you need to upload to support. Menifist file will be on following location:

$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt

9.Upload the manifest file to oracle support, use the below steps.

Upload the adgennls.txt file to https://updates.oracle.com/TransSync.
Once you upload the file, select the option Get Latest Translstions and click on next it will provide you the patch number which support is going to generate for NLS syncronization.

Note:If you do not receive any email regarding your request within 48 hours, you may contact Oracle Support for assistance.
this patch will generate NLS media patch, it will take some time to generate

15.Bring up the instance and release instance to customer
16.Once we have TSP patches then apply the Translation Synchronization patches 

adop phase=prepare,apply patches=34083171_AR:u34083171.drv patchtop=/home/oracle/software/AR_Patch

10.Bring down DB and MT services and take one cold backup
11.Start DB and listener.
12.Follow the instructions in the README file to apply the patch.

note: Before Applying patch make sure enough space in appl top directory, patch initially copy all required files to appl top create new lang patch Choose a directory that contains enough space for the NLS updates (about 10 GB for each language Minimum).

unzip patches in source folder
mkdir /home/applmgr/patch/dest
chmod -Rf 777 /home/applmgr/patch/dest
admrgpch -s /home/applmgr/patch/source -d /home/applmgr/patch/dest -merge_name u_mergeded
cd /home/applmgr/patch/dest
adpatch driver=u_mergeded.drv options=nocheckfile

13.AD Administration utility to generate message files from the Generate Applications Files menu.
14.Compile the invalid objects using utlrp.
15.Complie Forms and Reports
16.Complile Apps schema and validate apps schema