Here is Oracle's answer to question " How do I know what changes xxx patch does to my system , what is impact"
Patch Wizard is a Web-based utility in Oracle Applications Manager (OAM)
Navigation : Login to System Administrator
Oracle Applications Manager-->Patching and utilities -->
Select Feature ( Dropdown at right top corner ) Patch Wizard
There are different task names listed there for performing specific task.
Patch Staging directory is defined in "Patch Wizard Preferences" task
"Recommend/Analyze Patches" task allows you to analyze specific patch mentioned in text box.
Tip : If Metalink login does not connect from the Apps server,
the patch Zip file can be downloaded from metalink and FTP'ed to
Patch staging directory and /ad directory . Read light blue note
below the patch numbers box in "Recommend/Analyze Patches" task
This submits request set to run and once completed, Impact analysis is done and
presented in "Recommended Patches Results" section
Note : I think there should be way to generate nice impact analysis document
for presenting it to management , but I could not get something similar yet.
There can be query to get the details in reader-friendly format.
Clicking on each hyperlink to see impact is cumbersome
Details on how to use patch wizard can be found at
http://www.in-oracle.com/Oracle-Apps/11i/patch-impact-analysis.php
http://docs.oracle.com/cd/E18727_01/doc.121/e12148/T531058T531063.htm
P.S. Till today I could not get query which will nicely display impact analysis. Crude way to provide the screen shots after clinking on impact details button in patch wizard screens. I certainly believe there exists some query which will easily generate user friendly report on patch impact analysis.
Patch Wizard is a Web-based utility in Oracle Applications Manager (OAM)
Navigation : Login to System Administrator
Oracle Applications Manager-->Patching and utilities -->
Select Feature ( Dropdown at right top corner ) Patch Wizard
There are different task names listed there for performing specific task.
Patch Staging directory is defined in "Patch Wizard Preferences" task
"Recommend/Analyze Patches" task allows you to analyze specific patch mentioned in text box.
Tip : If Metalink login does not connect from the Apps server,
the patch Zip file can be downloaded from metalink and FTP'ed to
Patch staging directory and /ad directory . Read light blue note
below the patch numbers box in "Recommend/Analyze Patches" task
This submits request set to run and once completed, Impact analysis is done and
presented in "Recommended Patches Results" section
Note : I think there should be way to generate nice impact analysis document
for presenting it to management , but I could not get something similar yet.
There can be query to get the details in reader-friendly format.
Clicking on each hyperlink to see impact is cumbersome
Details on how to use patch wizard can be found at
http://www.in-oracle.com/Oracle-Apps/11i/patch-impact-analysis.php
http://docs.oracle.com/cd/E18727_01/doc.121/e12148/T531058T531063.htm
P.S. Till today I could not get query which will nicely display impact analysis. Crude way to provide the screen shots after clinking on impact details button in patch wizard screens. I certainly believe there exists some query which will easily generate user friendly report on patch impact analysis.
