11i / r12 India Localization Patch Tool

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

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

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

Connection to JA schema:
Object Backup:
India Localization Patch Tool – 11.5.10.2

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

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

Patch Log Location and Log File:
India Localization Patch Tool – 11.5.10.2

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.

 

 

Thanks

Srini