Hi,
some time ago I wrote a query to accomplish exactly what you ask:
This one shows all the applied patches (exactly the applied patches not the
fixed bugs, you know the diffrerence, right?) and a date of it's
installation. If there were multiple patches intalled using a merged driver
file, all of them will be listed with the same installation date, if the
same patch was applied twice - it will be in the list twice:
SELECT nvl(ab.bug_number, ap.PATCH_NAME) patch,
end_date
FROM applsys.ad_appl_tops AT,
applsys.ad_patch_driver_langs l,
applsys.ad_patch_runs pr,
applsys.ad_patch_drivers pd,
applsys.ad_applied_patches ap,
applsys.ad_bugs ab,
applsys.ad_comprising_patches acp
WHERE pr.appl_top_id = AT.appl_top_id
AND pr.patch_driver_id = pd.patch_driver_id
AND pd.applied_patch_id = ap.applied_patch_id
AND pd.patch_driver_id = l.patch_driver_id
and ab.bug_id(+) = acp.bug_id
and acp.patch_driver_id(+) = pd.patch_driver_id
and language = 'US'
ORDER BY end_date DESC;
I had actually used this query to generate html pages listing all the
patches applied on al environemnts with the dates they were installed, see
attachment for a sample. Those htmls are available for our functional
consultants to be able to see which patches hawe been applied in any
particular environemnt.
best regards,
Maris Elsins
http://appsdbalife.wordpress.com
On Sat, Oct 30, 2010 at 12:43 PM, dileep kumar <dileep463@xxxxxxxxx> wrote:
> Hello DBAs,
>
> I have requirement to compare the applied patches across two applications
> EBS instances.
> (Applied patches may ...one offs,mini packs, family packs,help and Merge
> patches).
>
> Please suggest me.
>
> Thanks,
> Dileep.
>
Attachment:
patchlist.gif
Description: GIF image
