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

62 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-2007
FR-2007 Advisor on new empty App finds a lot of errors
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
FR-4675
FR-4675 Integrating APEX Advisor Checks into Application Deployment
FR-4740
FR-4740 Page inconsistency analysis and update in the application.

Comments

Comments

  • phillip.grimshaw OP 3.6 years ago

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

  • stew stryker OP 3.4 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 2.4 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 2.3 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 2.3 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. :-)

  • jamiemsutcliffe OP 4 weeks ago

    +1 for exporting the advisor report. This is useful for example when someone is reviewing or testing the changes or event just to audit what you fixed. Once the issue has been rectified then you can no longer see the issues. You can take screenshots but this is very cumbersome. Also suggest different levels of audit print, e.g. verbose, standard and summary.

  • gabriel.diaz.arias OP 10 days ago

    Any news on this one? It would be really interesing in combination with ApexLang in 26.1

  • vincent morneau Admin OP 10 days ago

    This is high on the list. We have plans for APEXlang specifically too.

  • andreas wismann / when others OP 10 days ago

    And the Advisor reports something like “String too long” if Report Layouts are included in the Application

    (if memory serves me right… I will be on-site at the customer's location tomorrow to determine the exact error message and the circumstances.)

  • jamiemsutcliffe OP 4 days ago

    In terms of outputting the advisor report I've noticed that as of version 26.1 of Apex it is possible to select and copy the text from the report (and import e.g. into a word doc or similar) which is a welcome improvement. Proper e.g. csv exports in a future release will be better of course.