India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 1 appsdbawiki

Introduction to India Localization Patch:

Pre-Requisite Patch Check:

select * from jai_applied_patches where patch_number = ‘<Patch_Number>’;

Object Details:

Check the status of the objects that will be updated by the patch driver. select owner, object_name, object_type, last_ddl_time, status from all_objects

where object_type like '<OBJ_TYP>' and object_name = ‘<OBJ_NAME>’;

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 2 appsdbawiki

Object Version:

select object_name||';;' ||

decode(object_type,'TRIGGER','en','VIEW','vw','PACKAGE','pls','PACKAGE

BODY','plb','compile')||';;' || jai_get_sql_ver_f(object_name, object_type)

from user_objects

where object_name in ‘(‘<OBJ_NAME>');

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 3 appsdbawiki

Checking FND Version:

select patch_level, application_name

from fnd_product_installations fpi, fnd_application_tl fat where patch_level is not null and fpi.application_id = fat.application_id and patch_level like

'%FND%' ;

Invalid objects:

select count(*) from dba_objects where status='INVALID';

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 4 appsdbawiki

Connection to JA schema:

Object Backup:

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 5 appsdbawiki

Patch Top:

Copy the patch to JA_TOP and unzip it. Change the directory to patch folder. Inside the patch folder you can see a sql supplied by oracle to find out the version of all the objects which patch will be updating.

Patching:

DB, Concurrent Node:

perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=D systempwd=<PWD>

perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=C systempwd=<PWD>

strings -a ja_in_localization_setup_checks_trg.sql | grep Header

Form Node 1:

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 6 appsdbawiki

perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd= <PWD> japwd=<PWD> mode=F systempwd=<PWD> strings -a ja_in_localization_setup_checks_trg.sql | grep Header

Form Node 2:

perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=F systempwd=<PWD> strings -a ja_in_localization_setup_checks_trg.sql | grep Header

Backup Folder:

A backup folder will be created inside the patch top. In this location you can find all the objects that are going to be replaced by patching.

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 7 appsdbawiki

Patch Log Location and Log File:

India Localization Patch Tool – 11.5.10.2

Krishnamoorthy Rasappan Page 8 appsdbawiki

and more ….

Monitoring:

There is no tool to monitor India Localization Patch like how we can adctrl for adpatch in EBS. But we can find by checking for the processes running in OS.