Skip to content

DBA Dependencies (used by)

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DBA Dependencies (used by)

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DBA Dependencies (used by).sql
DBA Dependencies (used by).sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title DBA Dependencies (used by) | Oracle EBS SQL Report
description 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…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Dependencies, (used, by), dba_objects, dba_dependencies
permalink /DBA%20Dependencies%20%28used%20by%29/

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

© 2026 Enginatics