How To Check The Current India Localization Patchset Level Installed On An Instance?

How To Check The Current India Localization Patchset Level Installed On An Instance?

Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:

Oracle Application - India Localization - Version: 11.5.10.2
Information in this document applies to any platform.
Goal

How to check the current India Localization Patchset Level installed on an Instance?


Solution

The latest India Localization Patchset is IN60107(Patch Number = 5498551)
If the Patch Number 5498551 is applied, your current India Localization patchset is IN60107.
This can be verified by running the below select

select * from JAI_APPLIED_PATCHES where Patch_number = 5498551
/

If the Patch Number 5498551 is not applied, the India Localization Patchset should be IN60106 or below.
This can be checked by running the below statement:-
select * from JA_IN_INSTALL_CHECK_INFO where name like '601%'