How to find a patch applied in the release 12.2
Hello,
Please let me know how to find a patch applied in R12.2, I am using the following script got it from MOS when I run the script it's telling me the path has not been applied to the system. In fact, the patch is applied to the system. Please let me know if this script is right to find the R12.2 patches applied.
SQL> SELECT adb.bug_number,ad_patch.is_patch_applied('122', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in (21507777);
BUG_NUMBER
----------------
AD_PATCH.IS_PATCH_APPLIED('122',1045,ADB.BUG_NUMBER)