AD Applied Patches R12.2

➜ Back to Library
Description
Categories: Enginatics, Toolkit - DBA
Repository: Github
Check if a specific patch is applied in 12.2
Run AD Applied Patches R12.2 and other Oracle EBS reports with Blitz Report™ on our demo environment
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 ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets WSM Pending Transactions CE General Ledger Reconciliation AR iReceivables Customers Statement Data Definition CE General Ledger Cash Account Usage ECC Procurement, Indirect Procurement, SQL4 GMF Inventory Valuation (1) ECC Procurement, Indirect Procurement, SQL3
Blitz Report™

Blitz Report™ provides multiple benefits: