Learn about using Database Object Dependencies page.

The Database Object Dependencies page features two panes:

• Tree - The left pane displays as a tree of database object types, such as Tables, Packages, Procedures, Schemas, and System Dependencies. To view specific objects, expand the object type. For example, expanding the Tables node displays a list of tables. Expanding a table displays specific columns.
• Report - The right pane displays a report based on the selected node in the tree. In the following example Tables is selected. The report displays four columns: Owner, Name, Component Property, and Code. The Component Property column displays as link. Click the link to navigate to the component.

Description of the illustration db_object_dependencies.png

Filtering Objects

Filter objects by entering a search term in the filter that displays above the tree. In the following example, the search term EBA_DEMO_IR_EMP displays in the filter and the report displays the EBA_DEMO_IR_EMP table. Filters you create are persistent and are preserved within the APEX session.

Description of the illustration db_object_dependencies_filter.png

Learn about viewing errors on Database Object Dependencies page.

If an application contains code or object references that cause errors, an Errors node displays in the tree. The following example shows an application with five errors. The report in the right pane displays three columns: Component Property, Error Message, and Code. Component Property displays as link. Click the link to navigate to the component.

Description of the illustration db_object_dependencies_error.png

Refresh the dependencies on the Database Object Dependencies page by rescanning the application.

To rescan an application:

1. View an existing Data Object Dependencies page:
   1. Navigate to the Workspace home page.
   2. Select the application.
   3. Click Utilities.
   4. On the Utilities page, click Database Object Dependencies.
2. On the Database Object Dependencies page, click Scan Application.

   The Scan Application dialog appears.

   
   

   
   Description of the illustration scan_appilcation_dialog.png

   
   
3. On Scan Application, configure the options:
   1. Scan Type:
      • Full Scan - Scan all sources for dependencies including errors.
      • Errors Only - Create a report on code errors only.
   2. Scope:

      • Application - Scan the entire application including all pages and shared components.

      • Page - Restrict the scan to a single page only.

        If you select a page, select a page from the Page list.

   3. Click Scan.

   The Database Object Dependencies page is refreshed.

Remove dependency records from the Database Object Dependencies page by clicking Clear Dependencies.

To clear dependency records:

1. View an existing Data Object Dependencies page:
   1. Navigate to the Workspace home page.
   2. Select the application.
   3. Click Utilities.
   4. On the Utilities page, click Database Object Dependencies
2. On the Database Object Dependencies page, click Clear Dependencies.
   
   

   
   Description of the illustration db_object_depend_clear.png

   
   

   A dialog appears confirming your request.

3. Click Clear Dependences again..

   The Application home page appears.

4. On Scan Application, configure the options:
   1. Scan Type - Select an option:
      • Full Scan - Scan all sources for dependencies including errors.
      • Errors Only - Create a report on code errors only.
   2. Scope - Select an option:

      • Application - Scan the entire application including all pages and shared components.

      • Page - Restrict the scan to a single page only.

        If you select a page, select a page from the Page list.

   3. Click Scan.

   The Database Object Dependencies page appears.