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;

To Verify the Code Level

select * from fnd_product_installations where patch_level like '%AD%';