Oracle Apps R12: Check if the patch applied from sqlplus
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 || '%'
Mitali Aggarwal is known for her thoughtful approach to helping individuals work through emotional challenges. She focuses on listening with care and understanding each persons situation before offering simple, practical guidance. Her work reflects the idea that real change begins with awareness, patience, and consistent effort in the right direction.
ReplyDelete