22.1 Running Advisor to Check Application Integrity

The Oracle Application Express Advisor (Advisor) enables you to check the integrity and quality of your Oracle Application Express application. Oracle Application Express Advisor functions like a compiler or LINT and flags suspicious behavior or errors. Running Advisor checks the integrity of your application based on the underlying metadata.

Topics:

22.1.1 About Oracle Application Express Advisor

Before deploying your application, you can use the Oracle Application Express Advisor to perform various sanity checks on your application. The Advisor checks for errors, security issues, performance bottlenecks, quality assurance, and other best practices.

22.1.2 Running Advisor on an Entire Application

To run Advisor on an entire application:

  1. Navigate to the appropriate application:
    1. On the Workspace home page, click the App Builder icon.

      The App Builder home page appears.

    2. Select the application.

      The Application home page appears.

  2. Click Utilities.
  3. Click Advisor.

    The Advisor page appears.

  4. Under Checks to Perform:
    1. Expand Checks to Perform.
    2. Review the selected options. Select and deselect options as appropriate.
  5. In Pages(s), enter a comma separated list of pages in the field provided. To check all pages, leave this option blank.
  6. Click Perform Check at the top of the page.

    A Results page appears.

    Tip:

    Current Advisor settings are used next time the check is performed.

  7. To alter the existing preferences:
    1. Under Filter Result, deselect the appropriate options.
    2. Click Apply Filter.
  8. To run Advisor again, click Perform Check.

22.1.3 Running Advisor on a Single Page

To run Advisor on a single page:

  1. Navigate to the appropriate page.
  2. Click the Utilities menu and select Advisor.

    Advisor appears.

  3. Under Checks to Perform, review the selected options. Select and deselect options as appropriate.
  4. Click Perform Check at the top of the page.

    A Results page appears.

  5. To alter the existing preferences:
    1. Under Filter Result, deselect the appropriate options.
    2. Click Apply Filter
  6. To re-run the Advisor and see if reported problems are fixed, click Perform Check.