DBA Dependencies (used by) – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Hierarchical report showing all database objects using the specified object, e.g. a certain table and the report shows all the views or packages that are refrencing or depending on the specified table (bottom to top)

Report Parameters

Owner, Object Type, Object Name

Oracle EBS Tables Used

dba_objects, dba_dependencies

Report Categories

Enginatics

Related Reports

DBA Dependencies (uses), DBA Result Cache Objects and Dependencies, DBA Index Columns, DBA Blitz Report ORDS Configuration, DBA SGA Active Session History, DBA ORDS Configuration Validation, DBA Blocking Sessions, DBA Objects

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

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
Full SQL 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

© 2026 Enginatics