What's New in Oracle APEX AI Application Generator 26.2

Oracle APEX AI Application Generator 26.2 brings new capabilities for modern development, generative AI, and enterprise-grade security. The release expands APEXlang, advances AI Agents and AI Interactive Reports, introduces Oracle Deep Data Security integration, and simplifies secure access to OCI services, along with enhancements across workflows, Universal Theme, charts, administration, and platform APIs.

An Application Definition Language

APEXlang Enhancements

APEX 26.2 expands APEXlang with file-level import, enabling developers to update individual pages or shared components without redeploying the entire application. With enhanced support for source control, team development, CI/CD, translations, Working Copies, and lifecycle APIs, APEXlang makes development workflows faster, safer, and more flexible.

Read Blog Post

More Capable AI, with More Control

AI Capabilities

APEX 26.2 expands AI capabilities with support for the latest OpenAI, Google Gemini, and OCI Generative AI APIs. New Reasoning Effort controls give developers greater control over how AI Agents handle tasks. Additionally, a new secure application navigation enables AI Agents to recommend relevant pages while Oracle APEX declaratively constructs the target URL.

Read Blog Post
CRM Management System opportunities tracker screen showing sales opportunity records

A Smarter, More Modern Interactive Reports Experience

Interactive Reports

AI Interactive Reports have been enhanced to deliver faster conversational experiences and with zero AI. Conversational capabilities now support the creation of computed columns, while end-user dialogs offer a more modern experience.

Read Blog Post

Bring Data Security Closer to the Data

Deep Data Security Integration

APEX now provides declarative support for Oracle Deep Data Security. With Deep Data Security, you can enforce fine-grained access controls at the row, column, and value levels directly in the database. This enables you to move data security policies out of APEX and into the Oracle Database, helping ensure consistent protection across APEX components, MCP, AI agents, and other database clients. As an Oracle AI Database capability, Deep Data Security supports a centralized, best-practice approach to data security.

Additional Platform Enhancements

Secure Access to OCI Services with Managed Identities

Connect APEX applications to OCI services securely with managed identities, simplifying authentication while keeping access control centralized.

  • OCI Native Authentication
    Use DBMS_CLOUD credentials with Resource Principal or Database Tools Identity through APEX Web Credentials.
  • No Individual API Keys
    Access services such as OCI Object Storage and OCI Generative AI without storing a user’s API private key in APEX.
  • Centralized Access Control
    Let OCI IAM control resource access while the database manages the credentials used by APEX.
  • Simplified Credential Management
    Reduce credential maintenance with OCI-managed credentials and rotation for supported managed identities.
APEX Builder Experience screenshots

Workflow

Build and manage adaptable workflows and human tasks with greater control across design, deployment, and production.

  • Custom Task Outcome

    Use outcomes such as YES, NO, or UNDECIDED to drive workflow decisions and branching.

  • In-Flight Workflow Migration

    Move running workflow instances to newer model versions without restarting work already in progress.

  • Draft Workflow Activities

    Model processes before every step is implemented using Draft activities as placeholders for upcoming workflow logic.

  • Human Task Error Handling

    Respond to failed Human Tasks with Fail events that can trigger notifications, PL/SQL, or other recovery actions.

  • Workflow Diagram Export

    Export complete diagrams or visible views as PNG or SVG for documentation, presentations, and design reviews.

Universal Theme

Create more refined, flexible, and consistent application experiences with enhancements across Iris, Theme Roller, navigation, and Universal Theme components.

  • New Iris Appearances
    Choose from Pillar Light and Pillar Dark options for navigation and headers.
  • More Styling Control
    Customize applications further in Theme Roller, including control over the Header Pillar Strip.
  • Clearer Navigation
    Improved Iris Tree Navigation makes current, selected, and parent items easier to distinguish.
  • Refined Visuals
    Use new subtle color utilities and smoother processing indicators to create more polished interfaces.
  • Greater UI Consistency
    Benefit from improved styling and RTL support across typography, buttons, cards, forms, calendars, and navigation.

Administration

Simplify APEX administration and service management with better operational insights and streamlined self-service capabilities.

  • Enhanced Mail Queue Reporting
    Monitor email delivery with real-time metrics for delivery health, performance, failures, and workspace usage, making issues easier to identify and troubleshoot.
  • Simplified Service Requests
    Request Web Service Limit increases directly from the Manage Service wizard for a faster, more consistent self-service experience.

Security

Strengthen application and network security with granular outbound access controls and built-in protection against unwanted automated traffic.

  • Deep Data Security Integration
    APEX integrates declaratively with Oracle Deep Data Security to enforce fine-grained row-, column-, and value-level access controls consistently across APEX, MCP, AI agents, and other database clients.
  • Workspace-Level Network Access Control
    Control which external endpoints each workspace can access through workspace-level database network ACLs, providing greater isolation and reducing unauthorized outbound access.

Looking for what’s new in the previous release?

Oracle APEX AI Application Generator Roadmap

Generative Development

  • APEXlang single-file compilation to enhance generative development workflows
  • Continued investment in AI agent-based Generative Development with tools such as Codex and Claude
  • Improvements to public APEXlang skills distributed on github.com/oracle/skills
  • Improved public BNF grammar to enhance LLM generative capabilities
  • Additional pattens to prompt best practice UX out of the box



Components

  • Enhanced Interactive Report natural language reporting with and without LLMs
  • Natural language reporting with Faceted Search
  • Drill-down reporting option
  • Enhanced runtime AI agent & chat experience
  • Support for webLLM interactions
  • Improved RESTful data access and catalog support


Database Feature Integration

  • Integration wtih Deep Data Security including full identity propagation
  • Enhanced support for Duality Views
  • Enhanced Vector Search capabilities
  • Open Telemetry improvements


Application Lifecycle

  • Improved SQLcl command line orchestration
  • APEXlang static analysis via SQLcl
  • Synchronized releases with other Database Tools (ORDS, SQLcl & SQLdev)


Workflow

  • Decision modeling & execution capabilities
  • Very large model support


Oracle APEX 26.2 also delivers on 9 community submitted ideas!

This release turns highly requested feedback from the APEX community into practical improvements across the platform, making everyday development smoother, faster, and more productive.