Finding Patch History in Oracle Apps

Note 231701.1

How to find patching history in Oracle Applications 11i.

Two scripts, adphrept.sql (patch history) and adfhrept.sql (file history), both are located in the $AD_TOP/patch/115/sql directory. When the scripts are ran under the APPS schema from Sql*Plus, they create xml reports. This scripts take 16!! parameters.

As an alternative, the following SQL statements may be used to obtain basic patch history from the database:

a. To find a list of all the patches that have been applied:

select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS;

b. To find if a particular patch has been applied:

select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS
where DRIVER_FILE_NAME like ‘%2408149%’;

Note: the SQL statements will return a listing of the respective C, D, and G
drivers of each patch. Thus, for the SQL statement in (b) above if the patch
had been applied to this instance, the results would be:

DRIVER_FILE_NAME
——————————
g2408149.drv
c2408149.drv
d2408149.drv

(Patches applied using admrgpch, will not be listed in the results of the above SQL statements.)

Note 162498.1
Note 139684.1

Advertisements

About this entry