Wednesday, 7 January 2015

Oracle apps How to find the adpatch is applied or not

We can use below tables to find the patch is applied on the given apps system.
 

++ Login to the database using apps user and execute below query with patch no

Tables: ad_bugs ad_applied_patches ad_patch_drivers ad_patch_runs ad_appl_tops ad_patch_run_bugs

select ab.bug_number, ab.creation_date
from ad_bugs ab
where ab.bug_number = '&Patch_no';


select aap.patch_name, aat.name, apr.end_date
from ad_applied_patches aap,
ad_patch_drivers apd,
ad_patch_runs apr,
ad_appl_tops aat
where aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and aat.appl_top_id = apr.appl_top_id
and aap.patch_name = '&Patch_no';


select distinct aprb.application_short_name as "Affected Modules"
from ad_applied_patches aap,
ad_patch_drivers apd,
ad_patch_runs apr,
ad_patch_run_bugs aprb
where aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and apr.patch_run_id = aprb.patch_run_id
and aprb.applied_flag = 'Y'
and aap.patch_name = '&Patch_no';

No comments: