Oracle Application Manager Patch Wizard Does Not Show Patches Applied Via Downtime Mode Or Hotpatch Mode
Last updated on AUGUST 08, 2017
Applies to:Oracle Applications Manager - Version 12.2.3 and later
Information in this document applies to any platform.
E-Business Suite 12.2 Applications Manager, Patch Management Features
The following navigation path in Oracle Applications Manager does not display patches applied in downtime mode or hotpatch mode:
OAM -> Site Map -> Maintenance -> Applied Patches
Overall it appears apply_mode=downtime or apply_mode=hotpatch patches do not show in Oracle Application Manager Patch Wizard.
When applying a patch in downtime mode users are not able to see the patch in OAM, even though the patches may have entries in ad_bugs and ad_applied_patches.
(Note: In EBS 12.2 you cannot simply query the ad_bugs table. This table may have entries for patches that were applied but later the patching cycle was aborted (not really applied). The way to check whether a patch is really applied is to use the AD_PATCH.IS_PATCH_APPLIED pl/sql function
select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
SELECT adb.bug_number,ad_patch.is_patch_applied('11i', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in (20034256);
or for single app tier installations:
select ad_patch.is_patch_applied('R12',-1,20034256) from dual;
EXPLICIT = applied
NOT APPLIED = not applied / aborted)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms