A Oracle APEX Application Development Specific Limitations

This sections summarizes key restrictions and limitations in Oracle APEX Application Development (APEX Service).

Autonomous Database Limitations in APEX Service

This sections summarizes key restrictions and limitations of Oracle Autonomous Database - Shared Infrastructure in APEX Service.

These restrictions are removed for an APEX Service instance when it is upgraded to Oracle Autonomous Transaction Processing - Shared Infrastructure.

  • Restrictions on autonomous capabilities:

    • No support for Oracle Database clients. Oracle Net Services (SQL*Net) connectivity is not available.

    • Full and metadata instance (database) cloning is supported, but refreshable clones are not.

    • Oracle Machine Learning (OML) Zeppelin notebook not included.

    • No support for registering as an Oracle DataSafe endpoint. If you upgrade from Always Free Oracle Autonomous Transaction Processing to APEX Service, and the Oracle Autonomous Transaction Processing instance was registered as a DataSafe endpoint previously, then the user is required to de-register as part of the upgrade process.

    • No ability to set up Autonomous Data Guard standbys.

    • Directly accessing the pre-configured REST-SQL endpoint (with URL ending in /sql) is prohibited.

  • Restrictions on service packaging and licensing:

    • No BYOL license type

    • No Always Free version

    • No Dedicated Infrastructure version

    • No Government version available, and no footprint in Government/National Security OCI Data Regions

    • Not included in Oracle Cloud@Customer offerings

Application Express Limitations in APEX Service

The section summarizes restrictions and limitations of Oracle Application Express included with APEX Service. These limitations are required to protect the security and performance of your Oracle Application Express environment.

  • Disabled options in Administration Services:

    Some Application Express Administration Services configuration options are disabled. The following are examples of configuration options that have been predefined by Oracle and cannot be altered:

    • Authentication scheme used to access App Builder ("Database Accounts").

    • Manage Requests - Ability to enable, submit, and approve self-service workspace requests and change requests. For example, Manage Instance, Self-Service Sign Up.

    • Manage Instance, Instance Settings - Security, Instance Settings, Workspace Purge Setting, and Workspace Isolation:

      • Security (HTTP Protocol, Real Application Security, Session Time Out, Workspace Isolation, Region and Web Service Excluded Domains, Authentication Control, Password Policy).

      • Instance Settings (Workspace Creation Provisioning, Email Provisioning, Storage, Email, Wallet, Report Printing, Help, New Workspace Request Size, Workspace Change Request Size, Application ID Range, Background Jobs).

      • Workspace Purge Settings.

      • REST Administration Interface.

  • Disabled options in Workspace Administration:

    • Make a Service Request - Ability to make service requests for schemas, storage, and termination.

  • Application authentication schemes not supported:

    • HTTP Header Variable

    • LDAP Directory

    • Oracle Application Server Single Sign-On

  • APEX_INSTANCE_ADMIN: Only the following APEX_INSTANCE_ADMIN procedures and functions are supported.

    • ADD_SCHEMA

    • ADD_WORKSPACE

    • GET_PARAMETER

    • REMOVE_SCHEMA

    • REMOVE_WORKSPACE

    • SET_PARAMETER

    • VALIDATE_EMAIL_CONFIG

    See APEX_INSTANCE_ADMIN in Oracle Application Express API Reference.

  • SMTP Application Express Instance parameters:

    SMTP Application Express instance parameters and certain others may be set using the APEX_INSTANCE_ADMIN package.

    See Available Parameter Values in Oracle Application Express API Reference for more information.
  • Oracle Application Express Runtime environment is not supported:

    Oracle Application Express is only available as a Full Development environment. Converting into a Runtime environment is not supported.

  • Vanity URLs or custom domain names are not natively supported.

  • Deployment of the customer managed Oracle REST Data Services is not supported.

  • Oracle Cloud Infrastructure Web Application Firewall (WAF) service is not natively supported.