7.14 Using Application Utilities

Access the Utilities page to view useful application summaries and reports.

• Accessing the Utilities Page
  Access the Utilities page by selecting the application and then clicking the Utilities icon.
• Application Utilities Page
  Use the Application Utilities page to access the Application Dashboard, Advisor, Upgrade Application, Recently Updated Pages, Attribute Dictionary, Change History, Database Object Dependencies, Debug Messages, Application Express Views, Export Repository, and Manage Backups.
• Viewing the Application Dashboard
  View a report that summarizes application components and attributes.
• Upgrading an Application to Include New Components
  Upgrade an existing application to include new components available in the current release.
• Viewing the Recently Updated Pages Report
  Displays a report of pages recently updated by the current user.
• 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
• 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.
• Accessing Application Express Views
  Query various views against Application Express metadata.
• Accessing Page Specific Utilities
  Use the links in the Page Specific Utilities region to access Cross Page Utilities and Page Groups as well as access handy utilities for regions, buttons, items, computations, validations, process, dynamic actions, and branches.
• Accessing Cross Page Utilities
  Use Cross Page Utilities to perform edits across pages in the application.
• Using Interactive Report Utilities
  View and delete saved interactive reports and interactive report subscriptions.

See Also:

"Creating Custom Activity Reports Using APEX_ACTIVITY_LOG"

7.14.1 Accessing the Utilities Page

Access the Utilities page by selecting the application and then clicking the Utilities icon.

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 application Utilities page appears.

See Also:

• "Application Utilities Page"

• "Accessing Page Specific Utilities"

7.14.2 Application Utilities Page

Use the Application Utilities page to access the Application Dashboard, Advisor, Upgrade Application, Recently Updated Pages, Attribute Dictionary, Change History, Database Object Dependencies, Debug Messages, Application Express Views, Export Repository, and Manage Backups.

The following table describes the links on the application Utilities page.

Link	Description	To Learn More
Application Dashboard	View a summary of application components and attributes	See: "Viewing the Application Dashboard"
Advisor	Performs various checks on your application, including checks for programming errors, security issues, quality assurance, and other best practice	See: "Running Advisor to Check Application Integrity"
Upgrade Application	Upgrade the current application to a new release. Review components eligible for upgrading to include the latest features.	See: "Running Upgrade Application"
Recently Updated Pages	View a history of page updates made to this application.	See "Viewing the Recently Updated Pages Report"
Attribute Dictionary	Manage item and column user interface defaults for a selected page.	See: "Using the Attribute Dictionary"
Change History	View a report of component updates made in this application.	See: "Viewing the Change History Report"
Database Object Dependencies	View a report of database object referenced by this application.	See: "Using the Database Object Dependencies Report"
Debug Messages	Review debug messages generated by this application.	See: "Debugging an Application"
Application Express Views	Query various views against Application Express metadata.	See: "Accessing Application Express Views"
Export Repository	Manage Export Files in the Export Repository.	See: "Installing Export Files"
Manage Backups	View and manage application backups in the current workspace. Backups provide a simple way to recover applications that may have been unexpectedly modified or deleted.	See: "Managing Application Backups"
Page Specific Utilities	Page Specific Utilities display in a region on the right-side of the Utilities page. Use the links in the Page Specific Utilitiesregion to access Cross Page Utilities and Page Groups as well as access handy utilities for managing regions, buttons, items, computations, validations, process, dynamic actions, and branches.	See: "Accessing Page Specific Utilities" "Accessing Cross Page Utilities"
Interactive Report Utilities	Interactive Report Utilities display in a region on the lower right-side of the Utilities page.. Click Saved Reports to delete saved interactive reports in the current application. Click Subscriptions to manage interactive report subscriptions.	See: "Using Interactive Report Utilities"

7.14.3 Viewing the Application Dashboard

View a report that summarizes 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.

   • Native Region Component Utilization charts the total number of all types of region components used in the app. This is a visualization of the information provided in the Pages by Type section, the Page Components, and others.

   • Plugin Region Utilization charts the total number of plug-ins used in the app.

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

See Also:

"Identifying At Risk Password Items"

7.14.4 Upgrading an Application to Include New Components

Upgrade an existing application to include new components available in the current release.

• About Upgrading to Include New Components
  
• Running Upgrade Application
  

7.14.4.1 About Upgrading to Include New Components

The Upgrade Application page displays the available upgrade types along with the number of objects that can be upgraded. Click on the number under Candidate Object to review the candidates and upgrade.

7.14.4.2 Running Upgrade Application

To upgrade an application to use new components:

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.
   The available upgrade types display along with the number of objects that can be upgraded.
6. To review the candidates and upgrade, click the number link under Candidate Objects.
7. Follow the on-screen instructions.

7.14.5 Viewing 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.
   The Recently Updated Pages report appears.

7.14.6 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.
   The Change History report appears. Use the Since list to control the amount of time to include in your report.
6. From Since at the top of the page, select the amount of time to include in your report and click Set. 

7.14.7 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.

7. To view the components that reference a specific database object, click the number under Reference Count.

7.14.8 Accessing Application Express Views

Query various views against Application Express metadata.

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 report appears. Use the Search bar at the top of the page to customize the display.

   Tip:

   Click Tree View to switch to a relational view of this information with expandable parent and children entries.

6. Select a view.
7. On Selected Columns, select columns from Select Columns and click the Results button.
   The Results report appears.
8. On Results:
   • To view the query that was executed, expand the Query region . You can copy this query for reuse with SQL Commands or SQL Developer.
   • Click Download, to download to a file.

7.14.9 Accessing Page Specific Utilities

Use the links in the Page Specific Utilities region to access Cross Page Utilities and Page Groups as well as access handy utilities for regions, buttons, items, computations, validations, process, dynamic actions, and branches.

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"

7.14.10 Accessing Cross Page Utilities

Use Cross Page Utilities to perform edits across pages in the application.

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:

• "Locking and Unlocking a Page"

• "Deleting Multiple Pages"

• "Using Application Utilities"

7.14.11 Using Interactive Report Utilities

View and delete saved interactive reports and interactive report subscriptions.

• Deleting Saved Interactive Reports
  View and delete saved interactive reports in the current application.
• Viewing Subscriptions
  View and delete interactive report subscriptions.

7.14.11.1 Deleting Saved Interactive Reports

View and delete saved interactive reports in the current application.

To delete 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:

• "Linking to Shared Interactive Reports"

• "Saving Interactive Reports"

• "Managing Saved Interactive Reports" in Oracle Application Express Administration Guide

7.14.11.2 Viewing Subscriptions

View and delete interactive report 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 interactive report subscriptions:

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.
   The Subscriptions report appears.
5. To delete a subscriptions, select the check box adjacent to the page number and click Delete Checked.