Oracle Application Manager Patch Wizard Does Not Show Patches Applied Via Downtime Mode Or Hotpatch Mode (Doc ID 2061618.1)

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.

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

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