Oracle Application Manager Patch Wizard Does Not Show Patches Applied Via Downtime Mode Or Hotpatch Mode
(Doc ID 2061618.1)
Last updated on MAY 15, 2024
Applies to:
Oracle Applications Manager - Version 12.2.3 and laterInformation in this document applies to any platform.
Goal
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
Usage:
select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
example sql:
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;
expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted)
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |