Skip to content
APEX Project Eye Docs

Object Dependencies

The Object Dependencies feature in APEX Project Eye provides comprehensive visibility into the complex web of relationships between Oracle database objects and APEX application components. This powerful analytical tool helps developers understand how changes might impact the system, plan refactoring activities, and gain deeper insights into application architecture through detailed dependency tracking and visualization.

Key Benefits

Section titled “Key Benefits”
  • Change Impact Analysis: Understand how changes to one object may affect others
  • Refactoring Support: Plan and execute refactoring with confidence
  • Debugging Assistance: Quickly identify dependency chains when troubleshooting
  • Architecture Understanding: Gain deeper insights into application structure
  • Knowledge Transfer: Help new team members understand object relationships
  • Risk Reduction: Avoid unintended consequences of database changes

Utilization Report

Section titled “Utilization Report”

Select one to three applications and the dependency types to analyze:

The dependency calculation engine analyzes relationships between database objects and APEX applications

Object Detail View

Section titled “Object Detail View”

Interact with dependencies through intuitive visualizations:

  • Columns: See which columns are used in tables and views
  • Constraints: Understand how constraints are applied to objects
  • Relationships: See how objects are connected with an ER diagram
  • Indexes: Understand how indexes are used in the context of dependencies
  • Object Dependencies: See how objects are related to each other
  • Sample Data: Preview sample data for tables and views

Visual Dependency Explorer

Application-Level Usage

Section titled “Application-Level Usage”

Understand which database objects are used by specific applications. This report provides a list of Oracle APEX components with page IDs and dependency types for the selected database object:

Application-Level Usage

Application-Level Dependency Report

Section titled “Application-Level Dependency Report”

Get a comprehensive view of dependencies across entire applications:

  • Application Analysis: See all database objects used by an application
  • Usage Distribution: Identify which objects are used most frequently
  • Critical Path Analysis: Identify core objects with many dependencies
  • Unreferenced Objects: Find objects that aren’t used by the application
  • Cross-Application Dependencies: Understand shared dependencies between applications

Database Object Dependecy Report

Section titled “Database Object Dependecy Report”

Gain insights into what database objects are referenced by other objects:

Object Utilization

Section titled “Related APE Features”