Find out the Applied AD patches and Current Patch level in R12

Find out the Applied AD patches and Current Patch level in R12

To Find the Applied AD Patches

From Application

1. Login to Sysadmin

2. Navigate to the System Administrator->Oracle Applications Manager           ->Patching and Utilities

3. Then Search the patch with relevant parameter and click 'Go' Button

From SQL

1)
SELECT DISTINCT 
  e.patch_name Patch_NO, 
  d.patch_abstract Patch,
  e.CREATION_DATE Applied_Date
FROM 
  ad_patch_drivers d , 
  ad_applied_patches e 
WHERE 
  d.applied_patch_id = e.applied_patch_id                                    ORDER BY e.CREATION_DATE desc;


2)
SELECT DISTINCT a.bug_number, 
e.patch_name, 
d.patch_abstract,
e.CREATION_DATE,
c.end_date, 
b.applied_flag
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 
b.applied_flag='Y'
order by e.CREATION_DATE desc



To Find The Current Patch Level

From Application
                
1. Login to Sysadmin

2. Navigate to the System Administrator->Oracle Applications Manager and     open one of Java Page

3. Click Support Cart –> Applications Signature –> Collect->Check “Product     Information” box and Click on “View” (eyeglasses) to run the patch set       level report 

From SQL

SELECT 
  a.application_name, a.APPLICATION_SHORT_NAME,
  DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status, 
  patch_level 
FROM 
  apps.fnd_application_vl a,
  apps.fnd_product_installations b 
WHERE 
  a.application_id = b.application_id;