Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

How to find a patch applied in the release 12.2

edited Sep 18, 2018 5:01AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center