AD Applied Patches R12.2

➜ Back to Library
Description
Categories: Enginatics, Toolkit - DBA
Repository: Github Columns: Applied Check ...
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
EBS release version 
 
Appl top id 
 
 Number
Patch number 
 
 Number
Patch language 
,:language
Download
Related Blitz Reports
BEN Life Events Summary ECC Admin - Concurrent Programs WSM Pending Transactions AR iReceivables Customers Statement Data Definition GMF Inventory Valuation WSH Packing Slip Report PDF Output ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL3 ECC Procurement, Indirect Procurement, SQL1 ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: