Patch Wizard
Running “Patch Impact” via Patch Wizard :
1)
Login to EBS via sysadmin or system
administrator responsibility
2)
Navigate to “System Administrator” ----- > Oracle Application manager -à Patching and utilities
3)
On upper right hand side under “Select Feature “
, Select “Patch wizard” and hit Go
4)
On next screen select “Patch Wizard Preferences”
by clicking on Arrow under Tasks column
5)
Under Staging directory select location where
you downloaded Patch and click OK twice
6)
Click on Patch Wizard on top to go back to
Wizard home page.
7)
Select “Recommend / Analyze Patches by clicking
on Arrow under Tasks column corresponding to this choice
8)
On Next screen ,
select “Analyze Specific Patches” and enter patch number to analyze and hit OK
until you get back to the same page
9)
Click on “Patch Wizard” on top to go back to
“Patch Wizard” home page, now that you submitted the request refresh this page
to see if complete you will see on bottom of page recently analyzed patches
including one you submitted
10)
Once patch impact report completed click on link
under Details , and on next page click on Impact link
11)
Now you will see the actual Patch Impact Report
/ Page
Once you have patch
impact, run below query in SqlDeveloper and fetch output in spreadsheet form,
Note replace this with patch number or provide during run time “&1 --- Provide
patch number whose report you are fetching.”
SELECT DISTINCT
app_short_name,
directory,
filename,
typeid,
old_version,
MAX(new_version),
files_affected,
is_flagged_file,
type_affected,
trans_name
FROM fnd_imp_psmaster2
WHERE typeid NOT IN ('not applied')
AND (snapshot_id, patch_id) IN
(SELECT ads.snapshot_id, adp.patch_id
FROM ad_pm_patches adp,
ad_appl_tops adt,
ad_pa_analysis_run_bugs adb,
ad_pm_product_info appi,
ad_snapshots ads
WHERE adb.bug_number = &1 ---
Provide patch number whose report you are fetching.
AND adb.analysis_status IN
('MISSING', 'READY', 'APPLIED')
AND adb.analysis_run_id = (SELECT
MAX(adb_sub.analysis_run_id)
FROM
ad_pa_analysis_run_bugs adb_sub
WHERE
adb_sub.bug_number = adb.bug_number)
AND ads.snapshot_type = 'G'
AND adt.name = 'GLOBAL'
AND adb.appl_top_id = adt.appl_top_id
AND ads.appl_top_id =
adt.appl_top_id
AND appi.product_abbreviation(+)
= adp.product_abbreviation
AND adb.bug_number =
adp.bug_number
AND adb.baseline = adp.baseline
AND adp.patch_metadata_key =
'DEFAULT'
AND (adp.is_high_priority = 'Y'
OR adp.is_code_level = 'N')
AND adp.bug_number NOT IN (SELECT
bug_number FROM ad_hidden_patches))
GROUP BY app_short_name,
directory,
filename,
typeid,
old_version,
files_affected,
is_flagged_file,
type_affected,
trans_name
ORDER BY
app_short_name;
Comments
Post a Comment