I want to post a little bit about database administrator command, at Oracle R12.2 applications.
They are “ADOP Best Practice”.
$ adop -status -detail
$ adop phase=cleanup cleanup_mode=full
$ adop phase=apply patches= hotpatch=yes
$ adop phase=fs_clone
I hope this can be usefull.
This query can be used to provide datalist of applied patches in Oracle E-Business Suite.
Check this out.
aprb.application_short_name as AFFECTED_MODULE,
from ad_applied_patches aap,
where aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and apr.patch_run_id = aprb.patch_run_id
and aprb.applied_flag = 'Y'
order by aap.applied_patch_id desc;
Reference : Get Oracle patches details, oracle-apps-dba.blogspot.co.id