Oracle APEX Limitations on Autonomous Database

This section summarizes restrictions and limitations of Oracle APEX included in Oracle Autonomous Database, including for the APEX Service.

Tip:

This section does not apply to co-managed databases (for example, OCI Base Database Service) and Oracle Autonomous Database on Dedicated Exadata Infrastructure.

In a fully managed environment (such as Oracle Autonomous Database Serverless), certain limitations are required to protect the security and performance of your Oracle APEX environment.

• Administration Services - The following Oracle APEX Administration Services configuration options are disabled, or have been predefined by Oracle and cannot be altered.

  • Manage Instance, Feature Configuration:

    • Monitoring - Web Service Activity Logging, Enable Application Tracing

  • Manage Instance, Security, Security Settings:

    • Security - Instance Proxy, Instance No Proxy Domains, Unhandled Errors

    • Authentication Control:

      • HTTP Protocol - Require Outbound HTTPS

      • General - Single Sign-On Logout URL

  • Manage Instance, Manage Logs and Files:

    • SQL Workshop Log

    • Page View Activity Log

    • Developer Activity Log

    • External Click Counting Log

    • Login Access Log

    • Web Service Activity Log

    • REST Synchronization Log

    • Automation Log

  • Manage Instance, Instance Settings:

    • Storage - All tablespace settings

    • Wallet

  • Manage Instance, Workspace Purge Settings

  • Manage Workspaces, Existing Workspaces, Edit Workspace Information:

    • Login Control

    • Session Timeout

    • Workspace Isolation

• Only the following APEX_INSTANCE_ADMIN procedures and functions are supported:

  • ADD_AUTHORIZED_URL
  • ADD_SCHEMA
  • ADD_WORKSPACE
  • CREATE_OR_UPDATE_ADMIN_USER
  • DISABLE_WORKSPACE
  • ENABLE_WORKSPACE
  • FREE_WORKSPACE_APP_IDS
  • GET_AUTHORIZED_URLS
  • GET_PARAMETER
  • GET_SCHEMAS
  • REMOVE_APPLICATION
  • REMOVE_AUTHORIZED_URL
  • REMOVE_SAVED_REPORTS
  • REMOVE_SAVED_REPORT
  • REMOVE_SCHEMA
  • REMOVE_SUBSCRIPTION
  • REMOVE_WORKSPACE
  • RESERVE_WORKSPACE_APP_IDS
  • SET_LOG_SWITCH_INTERVAL
  • SET_PARAMETER
  • UNLOCK_USER
  • VALIDATE_EMAIL_CONFIG

  See APEX_INSTANCE_ADMIN in Oracle APEX API Reference.

• The following application authentication schemes are supported with limitations:

  • HTTP Header Variable: Only after configuring a vanity URL.

    See Access Oracle APEX, Oracle REST Data Services, and Developer Tools Using a Vanity URL for more information.

  • LDAP Directory, including APEX_LDAP API: With the same restrictions that apply to the DBMS_LDAP package.

    See PL/SQL Packages Notes for Autonomous Database for more information.

  • SAML Sign-In: Only when using a customer managed ORDS.

    See About Customer Managed Oracle REST Data Services on Autonomous Database for more information.

• Disabled options in SQL Workshop:

  The ability to create and manage database links in Object Browser is disabled. To create a database link, use the DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK PL/SQL API.

  See Use Database Links with Autonomous Database for more information.

• Runtime environment:

  Oracle APEX is only available as a Full Development environment. Converting into a Runtime environment, which minimizes the installed software footprint and removes UI components such as App Builder and Administration Services, is not supported.

  See About the Differences Between Runtime and Full Development Environments in Oracle APEX App Builder User’s Guide to learn more.