Reports2017-11-18T12:27:27+00:00

AD Applied Patches

Description
Categories: Application, DBA, Enginatics
AD applied patches, patch runs, included bugs, filenames and actions

select distinct
nvl(aprba.creation_date,apr.start_date) start_date,
aap.patch_name patch,
aap.patch_type,
aat.applications_system_name instance_name,
aat.name appl_top_name,
apd.driver_file_name,
&col_bug
&col_action
apr.end_date
from
ad_applied_patches aap,
ad_patch_drivers apd,
ad_patch_runs apr,
ad_appl_tops aat,
(select aprb.* from ad_patch_run_bugs aprb where '&enable_bug'='Y') aprb,
ad_bugs ab,
(select aprba.* from ad_patch_run_bug_actions aprba where '&enable_action'='Y') aprba,
ad_patch_common_actions apca,
ad_files af,
ad_file_versions afv1,
ad_file_versions afv2,
fnd_application_vl fav
where
1=1 and
aap.applied_patch_id=apd.applied_patch_id and
apd.patch_driver_id=apr.patch_driver_id and
apr.appl_top_id=aat.appl_top_id and
apr.success_flag(+)='Y' and
apr.patch_run_id=aprb.patch_run_id(+) and
aprb.applied_flag(+)='Y' and
aprb.success_flag(+)='Y' and
aprb.bug_id=ab.bug_id(+) and
aprb.patch_run_bug_id=aprba.patch_run_bug_id(+) and
aprba.executed_flag(+)='Y' and
aprba.common_action_id=apca.common_action_id(+) and
aprba.file_id=af.file_id(+) and
aprba.onsite_file_version_id=afv1.file_version_id(+) and
aprba.patch_file_version_id=afv2.file_version_id(+) and
upper(aprb.application_short_name)=fav.application_short_name(+)
order by
nvl(aprba.creation_date,apr.start_date) desc
&sort_action

Parameter Name SQL text Validation
Application Name
upper(aprb.application_short_name) in (select fav.application_short_name from fnd_application_vl fav where fav.application_name=:application_name)
LOV
Application Short Name
upper(aprb.application_short_name)=:application_short_name
LOV
Display Level
,aprba.action_id desc
Display Level
Y
Display Level
Y
Display Level
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Display Level
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Display Level
af.app_short_name appl_top,
af.subdir,
af.filename,
afv1.version onsite_version,
afv2.version patch_version,
apca.action_code action,
apca.concat_attribs,
aprba.action_id,
Bug Number
Y
Bug Number
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Filename
Y
Filename
Y
Filename
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Filename
af.app_short_name appl_top,
af.subdir,
af.filename,
afv1.version onsite_version,
afv2.version patch_version,
apca.action_code action,
apca.concat_attribs,
aprba.action_id,
Application Short Name
Y
Application Short Name
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Application Name
Y
Application Name
ab.bug_number,
upper(aprb.application_short_name) application_short_name,
fav.application_name,
Display Level
Y
LOV
Applied Date to
nvl(aprba.creation_date,apr.start_date)<=:applied_date_to
DateTime
Applied Date from
nvl(aprba.creation_date,apr.start_date)>=:applied_date_from
DateTime
Bug Number
ab.bug_number=:bug_number
LOV
Patch
aap.patch_name=:patch_name
LOV
Filename
af.filename=:filename
LOV