Skip to Main Content
Feature Request FR-4675
Product Area Application Builder
Status OPEN

2 Voters

Integrating APEX Advisor Checks into Application Deployment

karkuvelraja thangamariappan Public · Sep 27 2025

Idea Summary

Oracle APEX Advisor is one of the most powerful yet underrated features of the platform. It helps identify best practice violations, accessibility gaps, performance issues, and potential security risks within applications. However, its current usage is optional and often overlooked by developers, especially during the deployment phase.

To improve application quality and enforce best practices, APEX Advisor checks should be integrated directly into the deployment workflow. Before an app is deployed, the Advisor should run automatically and generate a score. Deployment should only proceed if the application achieves a predefined minimum score (e.g., 70%). Administrators should also be able to configure this threshold percentage based on organizational standards.

Use Case

A development team is preparing to deploy a mission-critical APEX application to production. Developers may skip running APEX Advisor manually, leading to missed performance bottlenecks, accessibility issues, or weak coding practices.

Preferred Solution (Optional)

With integrated Advisor checks, the system automatically validates the app during deployment. If the score meets or exceeds the required threshold (e.g., 70%), deployment continues. If not, the deployment is blocked, and developers are provided with actionable feedback to improve the app.

Benefits

- Ensures consistent application quality.

- Promotes adherence to Oracle APEX best practices.

- Reduces the risk of performance, security, or accessibility issues reaching production.

- Saves time in post-deployment bug fixing and support.

This idea is open.

Comments

Comments

  • parthiban OP 31 hours ago

    This is a good idea. Currently, some pages are not working in the production environment without adviser verification. Implementing this option will help ensure error-free application performance.

  • fac586 OP 28 hours ago

    To improve application quality and enforce best practices, APEX Advisor checks should be integrated directly into the deployment workflow. Before an app is deployed, the Advisor should run automatically and generate a score.

    What is meant by “deployment workflow”? There are multiple ways to deploy an application, and except for One-Click Remote Application Deployment, they don't necessarily involve points at which an Advisor scan be triggered.

    Deployment should only proceed if the application achieves a predefined minimum score (e.g., 70%). Administrators should also be able to configure this threshold percentage based on organizational standards.

    Such scoring does not make sense. The application could pass 99% of the Advisor checks, but if the one it fails is a PL/SQL compilation error on the application-level Authorization scheme then deployment is pointless.

    FR-1949 is a simpler and more practical idea to ensure that Advisor checks are regularly performed at the page level, which could be combined with a feature to schedule application-wide checks at suitable intervals, with error and warning counts shown for each application and page in the App Builder UI.