6.13 Using Application Utilities

The Utilities page features links to summaries and reports that enable developers to view an application from various perspectives.

Topics:

See Also:

"Creating Custom Activity Reports Using APEX_ACTIVITY_LOG"

6.13.1 Accessing the Utilities Page

To access App Builder Utilities page:

  1. On the Workspace home page, click the App Builder icon.
  2. Select the application.
  3. Click the Utilities icon.

    The Utilities page features links to the following tools and reports:

See Also:

"Accessing Page Specific Utilities"

6.13.2 Viewing the Application Dashboard

The Application Dashboard details application components and attributes.

To view the Application Dashboard:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Application Dashboard.

    The Application Dashboard appears and contains the following sections:

    • Application Overview lists detailed information and statistics about the current application, including the ID, name, alias, parsing schema, associated group, number of pages, and associated theme.

    • Security lists the current authentication scheme, number of public and non public pages, and the number of authorization schemes used within the current application.

    • Templates contains links to reports of templates used within the current application.

    • Pages by Type lists counts of components, including types of reports and forms and dynamic HTML.

    • Application Components contains links to reports of application-level controls and logic, including lists, shortcuts, lists of value, tabs, application computations, application items, plug-ins, and application processes.

    • Page Components contains links to reports of page-level controls and logic, including regions, items, branches, computations, validations, dynamic actions, classic report columns, interactive report columns, and button.

  6. To view a specific report, click the number to the right of the component type or template.

See Also:

"Identifying At Risk Password Items"

6.13.3 Upgrading an Application to Include New Components

Developers can upgrade an existing application to include new components available in the current release.

Topics:

6.13.3.1 About Upgrading to Include New Components

Using Upgrade Application on the Utilities page upgrades the following components:

  • Upgrade AnyChart charts to Oracle JET charts.

  • Upgrade Yes and No radio groups and select lists to a switch.

  • Upgrade tabular form to interactive grid.

    The following attributes are not migrated:

    • Default column sort sequence and direction

    • When No Data Found message

    • When When More Data Found message

    • Maximum Row Count

See Also:

"Running Upgrade Application"

6.13.3.2 Running Upgrade Application

To upgrade an existing application:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Upgrade Application.
  6. Follow the on-screen instructions.

See Also:

"About Upgrading to Include New Components"

6.13.4 Viewing the Recently Updated Pages Report

The Recently Updated Pages report displays a report of pages recently updated by the current user.

To view the Recently Updated Pages report:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Recently Updated Pages.

    A Search bar displays at the top of the page.

6.13.5 Viewing the Change History Report

The Change History report displays a summary report of edits to the current applications by developer, component type, and page number.

To view the Change History report:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Change History.

6.13.6 Using the Database Object Dependencies Report

The Database Object Dependencies report identifies database objects referenced by the current application. Review this report to determine what objects to move when deploying an application.

To view the Database Object Dependencies report:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Database Object Dependencies.

    The Database Object Dependencies page appears.

  6. Click Compute Dependencies.

    Tip:

    Display of the report may take a moment depending on the size and complexity of your application.

    The Database Object Dependencies report appears.

6.13.7 Accessing Application Express Views

Application Express Views are data dictionary views that expose the metadata for applications. In Application Express Views, you cannot only see the view, but you can also see the data they contain.

To access the Application Express Views page:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.
  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Click Application Express Views.

    The Application Express Views page appears.

    A Search bar displays at the top of the page. Available controls include:

    • Select columns to search - Resembles a magnifying glass. Click this icon to narrow your search. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) to search for a view by name and click Go.

    • Go button - Executes a search or applies a filter.

    • View Icons - Displays each view as a large icon. To access a view, click the appropriate icon.

    • View Report - Displays each view as a line in a report. To access a view, click the name.

    • Actions menu - Use the Actions menu to customize the report view. See "About the Actions Menu."

  6. Select a view

To view the data within a view, select columns from the Select Column tab and click the Results button.

On the Results tab, expand the Query region to view the query that was executed. You can copy this query for reuse with SQL Commands or SQL Developer.

6.13.8 Accessing Page Specific Utilities

To access Page Specific Utilities page:

  1. Navigate to the Workspace home page.
  2. Click the App Builder icon.

    The App Builder home page appears.

  3. Select an application.

    The Application home page appears.

  4. Click Utilities.
  5. Under Page Specific Utilities, select one of the following:

    • Cross Page Utilities

    • Page Groups

    • Region Utilities

    • Button Utilities

    • Item Utilities

    • Computations Utilities

    • Validation Utilities

    • Process Utilities

    • Dynamic Action Utilities

    • Branch Utilities

See Also:

"Accessing Cross Page Utilities"

6.13.9 Accessing Cross Page Utilities

To access the Cross Page Utilities page:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
  3. Click Utilities.
  4. From Page Specific Utilities, click Cross Page Utilities.

    The Cross Page Utilities page provides access to the following tools and reports:

    • Grid Edit of all Pages. Use this report to edit the page name, alias, title, page template, and security options. To link to a specific page, click the Edit icon adjacent to the page number. To save your changes, click Apply Changes.

    • Delete Multiple Pages. Delete multiple pages at once.

    • Page Attributes. View a report of details for all pages in the current application including the page name, page title, defined groups, type and number of components and controls, and application logic. To customize the report, use the search bar at the top of the page. To link to a specific page, click the page number.

    • Page Locks. Use Page Locks to prevent conflicts during application development. By locking a page, you prevent other developers from editing it. See and

See Also:

6.13.10 Accessing Cross Application Reports

Use the links on the Cross Application Reports page to view and edit information across multiple applications in the current workspace. You access cross application reports from Workspace Utilities page.

To access cross application reports:

  1. Sign in to Oracle Application Express.

    The Workspace home page appears.

  2. Click the App Builder icon.

    The App Builder home page appears.

  3. Click the Workspace Utilities icon.
  4. Locate Cross Application Reports on the right side of the window.
  5. Under, Cross Application Reports, click All Reports to view the Cross Application Reports page.
  6. Select a report to view.

6.13.11 Using Interactive Report Utilities

This section describes options under Interactive Report Utilities on the right side of the Utilities page.

Topics:

6.13.11.1 Deleting Saved Interactive Reports

The Saved Interactive Reports page lists saved interactive reports in the currently selected application.

To manage saved interactive reports:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.

    The Application home page appears.

  3. Click Utilities.
  4. Under Interactive Report Utilities, select Saved Reports.

    The report displays all of the saved report for the application which are not primary defaults. Each row includes the page number, region name, report type, report name, report alias, and owner.

  5. To view private saved reports, deselect the checkbox for the Primary Default filter located below the search bar.
  6. To delete a report, select the check box adjacent to the page number and click Delete Checked.
  7. To view the page containing the report, click the page number.

See Also:

6.13.11.2 Viewing Subscriptions

End users can receive updated versions of a report by subscribing to it. Workspace administrators can view and manage these subscriptions on the Subscriptions page.

To manage saved interactive reports:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.

    The Application home page appears.

  3. Click Utilities.
  4. Under Interactive Report Utilities, select Subscriptions.

    A report appears.