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
BEN Life Events Summary ECC Admin - Concurrent Programs ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets WSM Pending Transactions AR iReceivables Customers Statement Data Definition CE General Ledger Reconciliation CE General Ledger Cash Account Usage GMF Inventory Valuation (1) WSH Packing Slip Report PDF Output GMF Inventory Valuation
Blitz Report™

Blitz Report™ provides multiple benefits: