Oracle EBS Applications DBA Reports

5 ready-to-run SQL reports for Oracle E-Business Suite Applications DBA, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Applications DBA tables in these reports are ad_patch_drivers, ad_patch_runs, ad_adop_session_patches, ad_adop_sessions, ad_comprising_patches, ad_bugs.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Applications DBA SQL Reports

Report Description
AD ADOP Sessions Online patching (adop) sessions of Oracle EBS 12.2 with one row per node and phase, showing the status, start and end time and duration of each phase. Phases…
AD Applied Patches AD applied patches, patch runs, included bugs, filenames and actions
AD Applied Patches R12.2 Check if a specific patch is applied in 12.2
AD Code Levels Code level and baseline of each Oracle EBS product and product family, as maintained by the patching utilities in ADTRACKABLEENTITIES. Patch readme files and…
AD Patch Task Timing Run time of each job of an adpatch, adop or upgrade session from ADTASKTIMING, to identify the jobs that took longest. Session Percentage is the job’s share of…

← All Oracle EBS modules

© Enginatics GmbH