SELECT applied_patch_id, rapid_installed_flag, patch_name, patch_type, maint_pack_level
FROM applsys.ad_applied_patches
order by 1 desc;
FROM applsys.ad_applied_patches
order by 1 desc;
select * from ad_patch_drivers
where applied_patch_id = 102974;
where applied_patch_id = 102974;
Notice the ORIG_PATCH_NAME is a surrogate number instead of the old convention of “merged”.
PATCH_DRIVER_ID APPLIED_PATCH_ID ORIG_PATCH_NAME
99582 102974 2123079401
SELECT ab.bug_number, acp.patch_abstract
FROM ad_comprising_patches acp, ad_bugs ab
WHERE acp.bug_id = ab.bug_id AND acp.patch_driver_id = 99582;
BUG_NUMBER PATCH_ABSTRACT
21830810 R12.TXK.C.DELTA.8
23569114 INVALID APPS DATABASE USER CREDENTIALS – TXKGENADOPWRAPPER_PL – 12.2.4
23705992 TNSNAMES.ORA GENERATED WITH SCAN NAME INSTEAD OF SCAN IPS FOR CUSTOM RACE DB CLONE
18525466 REVERT CHANGES MADE TO VALIDATE MANAGED SERVER PORTS OF ALL NODES