DBA Dependencies (uses) – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Hierarchical report showing all dependent database objects that a specified object, e.g. a view or package name uses or depends on (top to bottom)
Report Parameters
Owner, Object Type, Object Name
Oracle EBS Tables Used
Report Categories
Related Reports
DBA Dependencies (used by), 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 (uses) 12-Dec-2020 231856.xlsx |
| Blitz Report™ XML Import | DBA_Dependencies_uses.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-dependencies-uses/ |
Executive Summary
The DBA Dependencies (uses) report performs a “Top-Down” dependency analysis. It answers the question: “What does this object rely on?” This is crucial for understanding the complexity of a view or package, or for migrating code between environments (ensuring all prerequisites are moved).
Business Challenge
- Code Understanding: “This view is complex. What underlying tables does it pull data from?”
- Migration Planning: “I want to move this package to the QA environment. What other objects do I need to move with it?”
- Architecture Review: “Is this report accessing raw tables directly, or is it going through the secured views?”
Solution
This report lists all objects that are referenced by the input object.
Key Features:
- Source Tracing: Traces a view back to its base tables.
- External Dependencies: Identifies dependencies on objects in other schemas.
- Link Analysis: Can identify dependencies over database links.
Architecture
The report queries DBA_DEPENDENCIES.
Key Tables:
DBA_DEPENDENCIES: The system catalog of object relationships.
Impact
- Deployment Success: Ensures that code migrations don’t fail due to missing prerequisites.
- Security Auditing: Verifies that code is accessing data through the approved security layer (e.g., Views vs. Tables).
- Documentation: Automatically documents the data lineage of complex reports.
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