AD Applied Patches R12.2

➜ Back to Library
Description
Categories: Application, DBA, Enginatics
Repository: Github
Check if a specific patch is applied in 12.2 
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
Patch language 
,:language
Patch number 
 
 Number
Appl top id 
 
 Number
EBS release version 
 
Download
Related Blitz Reports
ECC Concurrent Programs BEN Life Events Summary WSM Pending Transactions AR iReceivables Customers Statement Data Definition WSH Packing Slip Report PDF Output ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Indirect Procurement, SQL3 ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL6 ECC Procurement, Indirect Procurement, SQL5
Blitz Report In Action