5.14 Using Application Utilities

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

• Accessing Application Utilities
  Access the Application 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, Debug Messages, Application Express Views, Export Repository, Manage Backups, and the Embedded Code Utility.
• Viewing the Application Dashboard
  View a report that summarizes application components and attributes.
• Running Application Upgrade
  After upgrading to a new release, the Application Upgrade wizard can help you to bulk update your application to leverage new features instead of deprecated ones or to automatically enable new functionality for existing components.
• 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
• Accessing Application Express Views
  Query various views against Application Express metadata.
• Managing Application Backups
  Review backup history, perform manual backups, or restore an application from a backup.
• Using the Embedded Code Utility
  Review all embedded code used in an Application Express application on one page. Embedded code is defined as code (such as SQL, PL/SQL and JavaScript) entered in the App Builder but does not include code such as PL/SQL packages or JavaScript libraries that code may reference.
• Viewing Page and Application Checksums
  View page and application checksums to compare to compare different application deployments and determine if the application or pages are different.
• Accessing Font APEX
  View the Font APEX page to search for Font APEX icons and view HTML markup.
• 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"

5.14.1 Running Application Upgrade

After upgrading to a new release, the Application Upgrade wizard can help you to bulk update your application to leverage new features instead of deprecated ones or to automatically enable new functionality for existing components.

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

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 Upgrade Application page appears displaying the available upgrade types and the number of objects that can be upgraded.
6. To review the candidate objects, click the number link under the Candidate Objects column.
7. On the Upgrade page, select the objects to upgrade and click Upgrade.
8. Run and test your application.