AD Applied Patches R12.2

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Check if a specific patch is applied in 12.2

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select 
decode(ad_patch.is_patch_applied(:ebs_release, :appltop_id, :patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') applied_check
from dual
Parameter Name SQL text Validation
EBS release version 
 
 Char
Appl top id 
 
 Number
Patch number 
 
 Number
Patch language 
,:language
 Char
Download
 
Related Blitz Reports
ECC Admin - Concurrent Programs BEN Life Events Summary CAC Inventory Accounts Setup CAC Cost Group Accounts Setup OPM Reconcilation ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets CAC WIP Resource Efficiency with Method and Lot Variances CAC Manufacturing Variance Detail CAC Manufacturing Variance Summary CAC WIP Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: