Patch Reporting - Oracle E-Business

There are 4 methods that you can use to generate patch report in Oracle EBS:

-> Using $AD_TOP/patch/115/sql/adphrept.sql.
Example:
$sqlplus apps/apps_password @adphrept.sql 2 ALL ALL ALL ALL ALL \
ALL ALL ALL ALL N N N N N my_patches.txt

->Using patchsets.sh script (download it updated using Oracle Metalink Note 139684.1.
Example:
patchsets.sh connect=apps_user/apps_pwd

-> By querying database using this query below:
set verify off
set pages 999
column patch_name format a20
column patch_type format a10
column creation_date format a20
column last_update_date format a20

undef 1

select
patch_name,
patch_type,
to_char(creation_date, 'yyyy-mm-dd hh24:mi') creation_date,
to_char(last_update_date, 'yyyy-mm-dd hh24:mi') last_update_date
from ad_applied_patches
where patch_name like upper('%&&1%')
union all
select
bug_number patch_name,
'BUG' patch_type,
to_char(creation_date, 'yyyy-mm-dd hh24:mi') creation_date,
to_char(last_update_date, 'yyyy-mm-dd hh24:mi') last_update_date
from ad_bugs
where bug_number like upper('%&1%')
order by patch_name
/



-> And finally, using the OAM (Oracle Application Manager) - Applied Patches session.


I hope that it help you find your applied patches.

Regards,
Paulo Portugal