In Oracle : Find the patch level for a specific product

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Find the patch level for a specific product

 

 Find the patch level for a specific product

 

 

Which is the patch level for a specific product ?

 

SQL> conn apps/apps
Connected.

Find the patch level for a specific product

 

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 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Find the patch level for a specific product

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2013  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.