Application Development Software

tryed adadmin relink

full shutdown and restart

no change

There's not too many parameters for this function ... Maybe the staging directory is invalid ?

Staging directory is valid

SR recommendation are

1-load latest infobundle

2-Linux#> adadmin -- AD Administration Main Menu

-- Option 4 -- Maintain Applications Database Entities menu

-- Option 2 - Re-create grants and synonyms for APPS schema

-- AD Administration Main Menu

-- Option 2 -- Maintain Applications Files menu

-- Option 4 -- Maintain snapshot information

-- Option 2 -- Update current view snapshot

trying that now

looks like loading infobundle is now needed to be done to analyze patches

tryed to analyse a patch (29201386)

can't see the detail

Total Files in Patch

Applications Patched

File Types Installed

New Files Introduced

Existing Files Changed

all page display nothing

Looks like the patch wizard worked.  Were you able to click the New files Introduced or Existing File Changed.  It should give you details..

Can you check whether the patch is applied already??

the patch is not applyed , i just run the analyse on it

the analyse is done but cant see the detail like "existing file change" ...

knowing that there is 5 file modified is nice

knowing wich 5 files are modified what i want to see

but end in blank page

You have mentioned

"i have installed latest patch wizard patch 28389569

so now if i run the query to know what patch is missing      https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=390454198806118&id=976688.1&_afrWindowMode=0&_adf.ctrl-state=16dah9aeqn_450#L167

they are all flagged APPLIED"

if they all flagged then you can go to Applied patches and check.  Were you able to try and see it there?

In our instance when we run patch wizard it gives the same results but we will be able to click the numbers and see what changed. 

Also please take a look at this document

(Doc ID 468024.1) latest infobundle is loaded

like you said "In our instance when we run patch wizard it gives the same results but we will be able to click the numbers and see what changed. "

thats exactly my problem, if i click on any number i get a blank page except for the Readme file

select

adb.analysis_run_id,

vl.*,

adp.bug_number patch_name,

adp.product_family_abbreviation ,

nvl(adp.product_abbreviation, ' ') ,

adp.bug_description ,

DECODE(adp.IS_FAMILY_PACK,'Y','Family Pack')||

DECODE(adp.IS_MAINT_PACK,'Y','Maintenance Pack')||

DECODE(adp.IS_MINI_PACK,'Y','Mini Pack')||

DECODE(adp.IS_HIGH_PRIORITY,'Y','High Priority Patch',NVL(adp.patch_type,'User Request')) Patch_Type ,

DECODE (adh.bug_number, NULL, 'N', 'Y'),

decode (adb.analysis_status,'MISSING','Missing','READY','Unapplied','APPLIED','Applied',adb.analysis_status) patch_status ,

nvl(decode(adp.has_msi_steps,'Y','Yes','N','No',adp.has_msi_steps), ' ') hasMsiSteps ,

adp.baseline ,

adp.entity_abbr ,

adp.patch_id

from

ad_pm_patches adp ,

ad_appl_tops adt ,

ad_pa_analysis_run_bugs adb ,

ad_hidden_patches adh,

FND_IMP_PSMASTER2_VL vl

where adb.analysis_status in ('MISSING','READY','APPLIED')

and adb.request_set_id = 20436153 --20436153

and adt.NAME ='GLOBAL'

and typeid ='upgrade'

and vl.patch_id = adp.patch_id

and adb.RECOMMENDED_PATCH_TYPE in ('1','3')

and adb.appl_top_id = adt.APPL_TOP_ID

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 adh.bug_number(+) = adp.BUG_NUMBER

order by adb.analysis_run_id desc

can you run this query for either you patch request set or analysis_run_id?

Thanks

I love your query

thanks

at least i will be able to answer my people question

until my SR get answered

Glad to know.  Did it return any rows?

yes exactly the row that i needed

trying that doc

Patch Wizard: Patch Impact Analysis Does Not Accurately Display New Files Introduced And Existing Files Changed When Analyzing a Patch (Doc ID 2467725.1)

Thank you so much for sharing the solution.  Will look into both documents you have suggested..

Thanks

Lalitha