I use the following SQL:
select distinct ap.patch_name, ap.creation_date, NVL(pd.patch_abstract,DECODE(ad_pa_validate_criteriaset.get_concat_mergepatches(pd.patch_driver_id ),NULL,'',
ad_pa_validate_criteriaset.get_concat_mergepatches(pd.patch_driver_id ))) patch_description
from ad_applied_patches ap, ad_patch_drivers pd
where pd.applied_patch_id = ap.applied_patch_id
and ap.creation_date > SYSDATE - 2000
order by ap.creation_date desc;
Or in OAM:
Thanks you sooooo much Michael
If you need to find the recommended patches for your EBS instance, use the Patch Advisor/Wizard.
If you want to find all your minipack and family pack versions, then use below:
R11i / R12.0 / R12.1 / R12.2: Oracle Applications Current Patchset Comparison Utility - patchsets.sh (Doc ID 139684.1)
I thought the Patch Wizard will show all recommended patches , including minipack and familiy pack patches?