Skip to Main Content
Feature Request FR-2233
Product Area Installation and Administration
Status ROADMAP

57 Voters

General Improvements to APEX Advisor

pjones_dev Public · Dec 3 2021

Idea Summary
This potentially could/should be broken down in to separate ideas as appreciate we may not be able to have them all at once but I can think of a number of improvements to the Advisor which would be great.

  • The ability to mark things as False Positives (and give a reason) to exclude them from results.
  • The advisor pays attention to if the component it is checking (or the page it is on) has a server side condition of NEVER or a currently excluded build option so it doesn't show them in the results.
  • It appears to advise more than once for the same thing when highlighting deprecated components (e.g. old Date picker)
  • The advisor doesn't appear to work properly for everything in the Interactive Grid (e.g. in an SQL query which references a column with Bind Variable syntax)
  • The ability to add your own checks declaratively (I have done this previously in an unsupported manner)
  • More checks (e.g. things found with APEXSec)
  • The ability to export the report generated.

Use Case
Helpful for developers

Preferred Solution (Optional)
Described in the Summary

This is currently on the roadmap for a future release of Oracle APEX.

Known Duplicates

Known duplicates

FR-2185
FR-2185 APEX Advisor "References with Bind Variable Syntax" - Support for Page Items / Variables > 30 Characters
FR-3228
FR-3228 Advisor - Fix selected rows
FR-2918
FR-2918 Add non-critical messages functionality to page designer to report on deprecated components being used
FR-2672
FR-2672 Queries supplied for deprecated/de-supported components
FR-3985
FR-3985 Ability to "accept" some warnings from APEX Advisor
FR-3730
FR-3730 Support the RDBMS 12.x 128 byte db col size versus the current 30 byte limit
FR-4504
FR-4504 Exportable Advisory Report
FR-4419
FR-4419 Advisor should not scan items that aren't rendered

Comments

Comments

  • phillip.grimshaw OP 2.7 years ago

    And stop reporting “item might not exist” when link points to items in another app.

  • stew stryker OP 2.5 years ago

    And stop throwing errors like (which I see in Apex 19.2):

    ORA-01426: numeric overflow

    That page doesn't tell you what went wrong, you have to dig them out of Monitor Activity→Application Errors

    In my latest failure, it was in:

    Error Messasge: APEX - ORA-01426: numeric overflow - Contact your application administrator. ORA-06512: at "APEX_190200.WWV_FLOW_ERROR", line 1443 ORA-06512: at "APEX_190200.WWV_FLOW_ERROR", line 1478

    Context: WWV_FLOW_SECURITY

    Component: FINAL_EXCEPTION_HANDLER

  • markus hohloch OP 1.5 years ago

    And it would be great if you could call the Advisor from outside via API (APEX_ADVISOR?). For example, to analyse several applications and create a report about them or to run a check before creating a build.

  • guillaume.penderia OP 1.4 years ago

    @markus hohloch This is technically possible as apex itself uses packages to do so, but it requires unsupported manipulations to be able to use this from the outside. 

    There is a thread here about it.

  • markus hohloch OP 1.4 years ago

    Thank you, I know that this is possible and I did it years ago. It's laborious and far from standard. Hence my desire for an official way. :-)