Oracle regularly releases patches to fix code, security, performance and other vulnerability issues in Oracle Apps. Oracle Support formerly known as Metalink maintains all these information. Metalink is a huge repository of knowledge. You get good reference document and knowledge document. Let’s assume you want to check if the patch/fix applied to Oracle APPS ERP or not.
How to check that?
Note:- Not all the patch and bug fixes applicable to your system. You should explicitly check with Oracle Support before applying any patch.
In this article, I will share methods to check if the patch is applied to your system Before that let’s see what is bug and patch.
As per Wikipedia,
A software bug is an error, flaw, failure or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.
A patch is a piece of software designed to update a computer program or its supporting data, to fix or improve it. This includes fixing security vulnerabilities and other bugs, with such patches usually called bug fixes or bug fixes, and improving the usability or performance.
How to check if patch is applied to Oracle Apps 11i and R12.1.X
AD_BUGS and AD_APPLIED_PATCHES
ad_bugs and/or ad_applied_patches are metadata tables in Oracle AppsDatabasee. These tables maintain all these information. You may find information about which patch is applied and when is it applied.
ad_bugs – Bug metadata table which stores bug information. You can use below query to get the bug information.
SELECT * FROM ad_bugs;
ad_applied_patches – Patch metadata table to store all patch information applied to the system. You can use below query to get patch information.
SELECT * FROM ad_applied_patches;
Difference between ad_bugs and ad_applied_patches
The difference between ad_bugs and ad_applied_patches is the information it stores. Patch is a collection of bugs. Every bug is having an entry in ad_bugs while there would be only one entry in the ad_applied_patches table.
How to check if patch is applied to Oracle Apps R12.2.X
For Oracle Apps R12 (12.2.x) method is different. Oracle provides built-in API AD_PATCH.IS_PATCH_APPLIED to check patch information.
Use below query to check,
SELECT AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
Example: Check if patch 1578898 is applied or not.
SELECT adb.bug_number,ad_patch.is_patch_applied('11i', 1021, adb.bug_number) FROM ad_bugs adb WHERE adb.bug_number in (1578898);
Above query is applicable for multi-node for single node apps tier, use below query
SELECT ad_patch.is_patch_applied('R12',-1,1578898) from dual;
EXPLICIT = Means patch is applied
NOT APPLIED = means patch not applied / aborted