Two tables to check if the patch is applied or not:
This table includes the defined bugs on the system:
SELECT bug_number
FROM apps.ad_bugs
WHERE bug_number LIKE '%' ||3594604 || '%';
This table includes patches applied on the system:
SELECT patch_name
FROM apps.ad_applied_patches
WHERE patch_name LIKE '%' ||3594604 || '%'
This table includes the defined bugs on the system:
SELECT bug_number
FROM apps.ad_bugs
WHERE bug_number LIKE '%' ||3594604 || '%';
This table includes patches applied on the system:
SELECT patch_name
FROM apps.ad_applied_patches
WHERE patch_name LIKE '%' ||3594604 || '%'
nice sir,your blog helped me alot in very urgent cases couple of times .
ReplyDeleteIam new to oracle apps dba but learn few things from you and onlineappsdba blogs.
:Saikumar K.