PATCH IMPACT ANALYSIS IN ORACLE EBS 12.2

 

PATCH IMPACT ANALYSIS IN ORACLE EBS 12.2

 Step 1: Download the patch in MOS

 34436371

  

  

 

  Step 2- To check staging directory

 

Navigate to Sys administrator -> oracle application manager ->patching and utilities

 

 In select feature tab please select patch impact and click go to selected feature

  

 

 In that tab click the patch wizard preferences task icon

  

 

 In that pages its sows staging directory so we need to move that patch to this same location

  

 

 Step 3- Move that patch to staging directory location and unzip it

 

 Step 4- Choose recommended analysis task icon

 

 Step 5 - select the analysis specific patch and give the patch number and click ok button

 

  Step 6- click confirmation once done the request submitted please note the request ID

 

 

 

  259170061.

 To view the running status of the request please choose job staus option

 

 

Its shows running status

  

  After some time it will completed.

 

 We can check the request id running status via conc manager ->find request

 

 

Step 7 - Execute below query and mention the correct analysis patch number its give report .

 Export the file in excel format.

 select b.APPLICATION_NAME Application,s.directory,s.filename,

DECODE(s.typeid, 'upgrade', 'Changed File', 'not applied', 'Unchanged File', 'new', 'New File') "Impact Type",

s.NEW_VERSION "Version in Patch",

s.OLD_VERSION "Version in APPL_TOP",

s.FILES_AFFECTED "Objects Affected"

from apps.fnd_application_vl b,    

apps.FND_IMP_PSMaster2 s    

where s.app_short_name=b.APPLICATION_SHORT_NAME

and s.bug_no='34436371';