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

Popular posts from this blog

All about DataInstaller & Hrglobal.drv in Oracle Applications R12

EBS Oracle Database 11.1.0.7 upgrade to 11.2.0.4 steps .

PSU Patching step by step on RAC