Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  Which is the patch level for a specific product ?

NOTE: This article named Which is the patch level for a specific product ?  was taken from  www.in-oracle.com.

SQL> conn apps/apps
Connected.

SQL> col PATCH_LEVEL format a17

The following select will return the patch level for all the products we have installed:

SQL> select PATCH_LEVEL from FND_PRODUCT_INSTALLATIONS order by 1;

For a specific product (for instance for AD product) we can run the following select: 

SQL> select PATCH_LEVEL from FND_PRODUCT_INSTALLATIONS  where PATCH_LEVEL like '%AD%';

The following query could be useful too:

set linesize 100

set pagesize 250

col Appl_short_name format a15

col Application_Name format a45

col PATCH_LEVEL format a12

col STATUS format a14

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 fnd_application_all_view    fa, 

                 fnd_product_installations fpi
WHERE fa.application_id = fpi.application_id

ORDER BY 2;

NOTE:

We can use also

• the Patchset comparison tool - patchsets.sh ( Metalink Note: 139684.1 )

• OAM

• Applications Diagnostic Tests

• $AD_TOP/sql/adutconf.sql 

        NOTE: This article named Which is the patch level for a specific product ?  was taken from  www.in-oracle.com.