Check if a Patch is Applied in 12.2.x

Hi,

Following document 1963046.1

I use the following query to know if Bundle Patch 12.1.0.2.190416 (Apr2019) patch 29176139 is applied.

But for one I receive:

ERROR at line 1:

ORA-01722: invalid number

Here are the queries:

SQL> select ad_patch.is_patch_applied('R12',-1, 29176139 ) from dual;

AD_PATCH.IS_PATCH_APPLIED('R12',-1,29176139)

--------------------------------------------------------------------------------

NOT_APPLIED

SQL> SELECT adb.bug_number,ad_patch.is_patch_applied('R12', 1045, adb.bug_number) FROM ad_bugs adb WHERE adb.bug_number in (29176139);

SELECT adb.bug_number,ad_patch.is_patch_applied('R12', 1045, adb.bug_number) FROM ad_bugs adb WHERE adb.bug_number in (29176139)