Oracle APEX Advisor is a utility that scans your application (either completely or by a specific page) to check its integrity and quality based on the underlying metadata. It functions like a compiler or LINT and flags suspicious behavior or errors and reports on deviations from best practices. Before deploying your application, you can use this utility to perform various sanity checks on your application. The Advisor checks for errors, security issues, performance bottlenecks, quality assurance, and other best practices that can help reduce errors in your application before it goes into production. It makes finding certain types of errors much easier than digging through the code. For example, the Advisor can quickly tell you whether you have implemented an authorization scheme in your application pages.
Execute the following steps to access the Advisor utility:
1. Select the application.
2. On the Application home page, click Utilities.
3. Click Advisor.
4. On the Advisor page, expand Checks to Perform (A) and review the selected options. Select
and deselect options as appropriate to get the information you need. You have
the option to restrict the pages that the Advisor reviews by defining a
comma-delimited list of pages to search for in the Pages(s) text box (B) provided at the top
of this window. To check all pages, leave this text box blank.
5. Click the Perform Check button
(C). The results page, as illustrated in the following figure, appears to provide a list of detailed issues that the Advisor finds. Click
the View button under each
finding to access the corresponding issue on that particular page.
