Oracle Applications: Patch Queries (Applied Patches etc)

http://www.thotasuman.com/

Below queries will provide you information on which/whether patches are applied:

Select * FROM ad_applied_patches WHERE patch_name = '<Patch_number>';

select * from ad_bugs where bug_number = '<patch_number> ';

SELECT  DISTINCT RPAD(a.bug_number,11)|| RPAD(e.patch_name, 11)|| RPAD(TRUNC(c.end_date),12)|| RPAD(b.applied_flag,4)
FROM  ad_bugs a,  ad_patch_run_bugs b,  ad_patch_runs c,  ad_patch_drivers d ,  ad_applied_patches e WHERE  a.bug_id = b.bug_id    AND  b.patch_run_id = c.patch_run_id    AND  c.patch_driver_id = d.patch_driver_id AND d.applied_patch_id = e.applied_patch_id  AND  a. bug_number in ('<patch_number>') ORDER BY 1 DESC


select ad_patch.is_patch_applied('R12','-1','<Patch_Number>') from dual;
-Suman
(http://www.thotasuman.com/)