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 ECC Procurement, Indirect Procurement, SQL1 ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances GMF Inventory Valuation ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL3
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: