Query List Applied Patches – Oracle EBS

Hi,

This query can be used to provide datalist of applied patches in Oracle E-Business Suite.
Check this out.

Applied patches 2

select aap.applied_patch_id,aap.patch_name,
aprb.application_short_name as AFFECTED_MODULE,
apd.driver_file_name,apd.patch_abstract,
apr.patch_top,
apr.patch_action_options
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'
order by aap.applied_patch_id desc;

Reference : Get Oracle patches details, oracle-apps-dba.blogspot.co.id

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s