DBA Dependencies (used by) – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports

Overview

Hierarchical report showing all database objects that use the specified objects, e.g. all views or packages referencing or depending on a table (bottom to top).

Select several object names to list the hierarchy of each, one after the other.

Show Table Statistics adds the optimizer statistics and the indexes of every table in the hierarchy.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Owner, Object Type, Object Name, Show Table Statistics

Oracle EBS Tables Used

dba_objects, dba_dependencies

Report Categories

Enginatics

Related Reports

DBA Result Cache Objects and Dependencies, DBA Dependencies (uses), DBA Blocking Sessions, DBA SGA Blocking Session Summary, DBA Segments, DBA SGA Active Session History

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource	Link
Excel Example Output	DBA Dependencies (used by) 12-Dec-2020 224509.xlsx
Blitz Report™ XML Import	DBA_Dependencies_used_by.xml
SQL Source	DBA Dependencies (used by).sql
Full Report on Enginatics	www.enginatics.com/reports/dba-dependencies-used-by/

Executive Summary

The DBA Dependencies (used by) report performs a “Bottom-Up” impact analysis. It answers the critical question: “If I change this object (e.g., a table or view), what else will break?” This is essential for Change Management and risk assessment before applying patches or deploying custom code.

Business Challenge

• Impact Analysis: “We need to alter the XX_CUSTOM_ORDERS table. Which reports and packages use it?”
• Regression Prevention: “Did we forget to recompile a view that depends on the table we just dropped?”
• Cleanup: “Can we safely drop this old table, or is it still referenced by a forgotten legacy procedure?”

Solution

This report queries the Oracle Data Dictionary to find all objects that depend on the input object.

Key Features:

• Recursive Search: Can show direct dependencies (Level 1) and indirect dependencies (Level 2+).
• Object Types: Covers Tables, Views, Packages, Synonyms, and more.
• Status Check: Shows whether the dependent object is currently VALID or INVALID.

Architecture

The report queries DBA_DEPENDENCIES.

Key Tables:

• DBA_DEPENDENCIES: The system catalog of object relationships.
• DBA_OBJECTS: Object metadata.

Impact

• Risk Mitigation: Prevents production outages caused by “breaking changes”.
• Change Confidence: Gives developers and DBAs confidence that they understand the scope of their changes.
• Maintenance: Helps identify and remove obsolete code that depends on deprecated objects.

---

Useful Links

• Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
• Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
• Oracle EBS Reporting Toolkits by Blitz Report™
• Blitz Report™ FAQ & Community Q&A
• Supply Chain Hub by Blitz Report™
• Blitz Report™ Customer Case Studies
• Oracle EBS Reporting Blog
• Oracle EBS Reporting Resource Centre

© Enginatics GmbH