Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Changes in This Release
  • Deprecated and Desupported Features
• Workspace and Application Administration
  • Understanding Workspace Administration
    • What is a Workspace Administrator?
    • Accessing the Workspace Administration Page
    • Workspace Administration Page
      • System Message Region
      • Workspace Administration Icons
      • Workspace Message
      • Tasks Region
    • Resetting Your Password
    • Viewing the About Oracle APEX Page
    • Managing Saved Interactive Reports
      • About Saved Interactive Reports
      • Viewing and Deleting Saved Interactive Reports
      • Managing Interactive Report Subscriptions
    • Viewing a Workspace Summary
      • Viewing the Workspace Utilization Report
      • Emailing the Workspace Utilization Report
    • Requesting a Workspace in Workspace Administration
  • Using the Manage Service Page
    • Accessing the Manage Service Page
    • Manage Service Page
      • Dashboards
      • Manage Meta Data
  • Making a Service Request
    • Determining the Space Available in a Workspace
      • Viewing the Detailed Tablespace Utilization Report
    • Viewing the Service Request History for the Workspace
    • Requesting a New Schema
    • Requesting More Storage
    • Requesting Another Workspace
    • Terminating a Workspace
    • Requesting an Increase to the Web Service Limit
  • Configuring Workspace Preferences
    • Managing Workspace Account Login Controls
      • About Login Controls
      • Configuring Workspace Account Login Controls
    • Controlling Access to App Builder
    • Controlling Access to SQL Workshop
    • Configuring Email Credentials for a Workspace
    • Disabling PL/SQL Program Unit Editing for a Workspace
    • Enabling RESTful Services and Defining a Path Prefix for a Workspace
    • Configuring Team Development in an Existing Workspace
    • Configuring Session Timeout for a Workspace
  • Defining a Workspace Message
    • About Workspace Messages
    • Defining and Editing Workspace Messages
  • Configuring an Environment Banner for a Workspace
  • Managing Links on the Extension Menu
    • About the Extension Menu
      • Supported Link Substitution Strings
    • Adding, Editing, and Deleting Extension Menu Links
      • Adding Extension Menu Links
      • Editing Extension Menu Links
      • Deleting Extension Menu Links
    • Managing Extension Subscriptions
      • Enabling Extension Menu Subscriptions
      • Subscribing to Extension Menu Links
      • Editing or Unsubscribing to Extension Subscriptions
  • Managing Users in a Workspace
    • About Oracle APEX Accounts Authentication
    • About Oracle APEX User Roles
    • Creating User Accounts
      • Creating a New User Account
      • Creating Multiple Users Simultaneously
    • Editing Existing User Accounts
    • Locking and Unlocking a User Account
    • Changing a User Account Password
    • Deleting User Accounts
      • Deleting a Single User Account
      • Deleting Multiple Users at Once
    • Viewing the Users Dashboard
    • Using Groups to Manage Oracle APEX Users
      • About Groups
      • Creating a Group
      • Editing an Existing User Group
      • Adding and Removing Users from a Group
      • Assigning a Group to Another Group
      • Viewing Group Assignments
  • Accessing the Data Dictionary Cache Report from Workspace Administration
    • About the Data Dictionary Cache Report
    • Viewing or Refreshing Data Dictionary Cache in Workspace Administration
  • Purging the Developer Activity and Click Count Log Files
    • Purging the Developer Activity Log
    • Purging the External Click Count Log
  • Managing Session State for a Workspace
    • About Session State
    • Removing Session State After Reviewing Session Details
    • Viewing Session State for the Current Session
    • Purging Sessions by Age
    • Purging Session State for the Current Session
  • Managing User Preferences
    • Setting User Preferences
      • Setting User Preferences by Creating a Page Process
      • Setting the Source of an Item Based on a User Preference
      • Setting User Preferences Programmatically
    • Viewing Preferences by User
    • Viewing Current User Preferences
    • Purging Preferences for a Specific User
    • Purging Preferences for the Current User
    • Removing User Preferences Programmatically
    • Resetting User Preferences Using a Page Process
  • Managing Page and Region Caching
    • Purging Cached Regions and Pages
  • Changing Build Status for Multiple Applications
    • About Changing Application Build Status
      • Ways to Modify Build Status
    • Managing Build Status in Workspace Administration
  • Viewing File Utilization
  • Monitoring Activity Within a Workspace
    • Accessing the Monitor Activity Page in Workspace Administration
    • Viewing Application Changes by Developer
    • Viewing Application Changes by Day
    • Viewing Active Sessions
      • What is an Active Session?
      • Viewing the Active Sessions Report
    • Viewing Schema Reports and Other Reports
  • Viewing Workspace Dashboards
    • Accessing the Workspace Dashboards
    • Workspace Dashboard
    • Users Dashboard
    • Activity Dashboard
    • Developer Activity Dashboard
    • Performance Dashboard
    • Applications Dashboard
    • Database Dashboard
• Oracle APEX Administration Services
  • Understanding Administration Services
    • What Is an Instance Administrator?
    • Signing In To Administration Services
    • Overview: Administration Services UI
      • Administration Services Home Page
        • System Message Region
        • Instance Tasks
        • Workspace Tasks
        • Available Updates
      • Manage Instance Page
        • Instance Settings
        • Manage Meta Data
        • Messages
        • Manage Logs and Files
        • Self Service Sign Up
      • Manage Workspaces Page
        • Workspace Actions
        • Workspace Reports
        • Export Import
        • Manage Applications
  • Managing Requests
    • About Workspace Requests and Change Requests
    • Viewing Requests on the Administration Services Home Page
    • Viewing Pending Requests
    • Managing Workspace Requests
      • About the Workspace Request Approval Process
      • Approving or Declining a Pending Workspace Request
      • Changing the Status of an Existing Workspace Request
      • Deleting a Workspace Request
    • Managing Change Requests
      • Approving or Declining a Pending Change Request
  • Managing Feature Configuration
    • Configuring Application Development Settings
      • Disabling PL/SQL Program Unit Editing for an Instance
      • Enabling the Creation of Demonstration Objects in New Workspaces
      • Configuring the Number of Application Backups
      • Disabling External Links
    • Configuring SQL Workshop
    • Configuring Monitoring
      • Enabling Database Monitoring
      • Enabling Application Activity Logging
      • Enabling Web Service Activity Logging
      • Enabling Application Tracing
    • Enabling RESTful Services for an Instance
    • Enabling Service Requests
    • Configuring Team Development for New Workspaces
  • Configuring Security
    • Configuring Service-level Security Settings
      • Controlling Workspace Cookies
      • Controlling Persistent Authentication
      • Disabling Access to Administration Services
      • Enabling Access to Oracle APEX Administration Services
      • Disabling Workspace Login Access
      • Disabling App Login Access
      • Controlling Public File Upload
      • Managing Support for AI Services for an Instance
      • Restricting User Access by IP Address
      • Configuring App Builder Proxy for AI Services
      • Enabling Allow DBMS Credentials Usage
      • Configuring a Proxy Server for an Instance
      • Selecting a Checksum Hash Function
      • Configuring Rejoin Sessions for an Instance
      • Configuring Unhandled Errors
    • Configuring HTTP Protocol Attributes
      • About SSL
      • Requiring HTTPS
      • Reversing Require HTTPS
      • Reversing Require Outbound HTTPS
      • Configuring Additional Response Headers
    • Enabling Real Application Security
    • Configuring Session Timeout for an Instance
    • Isolating All Workspaces in an Instance
      • About Isolating Workspaces to Prevent Browser Attacks
      • Configuring Instance-Level Workspace Isolation Attributes
    • Defining Excluded Domains for Regions and Web Services
    • Configuring Authentication Controls for an Instance
      • About Authentication Controls
      • Configuring Authentication Control General Settings
      • Configuring Authentication Control Development Environment Settings
      • Configuring Authentication Schemes for an Instance
        • About Configuring Authentication Schemes
        • Editing Oracle APEX Accounts
        • Editing Database Accounts
        • Editing HTTP Header Variable
        • Editing LDAP Directory
        • Editing Oracle Application Server Single Sign-On
        • Editing SAML Sign In
          • About SAML Sign In
          • About Response Signing when Using SAML
          • About Cross-Origin Resource Sharing when Using SAML
          • Configuring SAML Sign-In
        • Editing Social Sign-In
      • Configuring an Authentication Scheme for Data Reporter
    • Creating Strong Password Policies
      • About Strong Password Policies
      • Configuring Password Policies
    • Managing Authorized URLs
      • Defining a List of Authorized URLs
      • Editing a Defined Authorized URL
      • Deleting Defined Authorized URL
    • Configuring Web Service Limit Increase Size
  • Configuring Instance Settings
    • About Configuring Workspace Provisioning
    • Disabling Email Provisioning
    • Configuring Storage
      • Requiring a New Schema
      • Configuring Instance Tablespace
      • Enabling Auto Extend Tablespaces
      • Enabling Bigfile Tablespaces
      • Enabling Encrypted Tablespaces
      • Enabling Automatic Approval of Storage Requests
      • Deleting Uploaded Files
    • Configuring Email
      • About Enabling Network Services
      • Configuring Email in a Full Development Environment
      • Configuring Email in a Runtime Environment
      • Determining Email Settings in a Runtime Environment
    • Configuring Wallet Information
      • About SSL and Wallet Creation
        • Overview of Creating a Wallet
      • Configuring a Wallet in a Full Development Environment
      • Configuring a Wallet in a Runtime Environment
      • Determining Wallet Settings in a Runtime Environment
    • Configuring Report Printing for an Instance
      • About Configuring Report Printing
      • Configuring Report Printing in a Full Development Environment
      • Configuring Report Printing Settings in a Runtime Environment
      • Determining Report Printing Settings in a Runtime Environment
    • Configuring Workflow Settings
      • Configuring Task Retention
      • Configuring Workflow Retention
    • Configuring the Application Gallery
      • About the Application Gallery
      • Disabling Background Installations
      • Special Use Cases
        • Advanced Configuration
        • Hosting APEX Sample and Starter Apps Internally
        • Including Custom Apps in the Gallery
        • manifest.json Example
    • Configuring the Help Menu
    • Configuring Workspace Size Requests
    • Managing Application ID Range
    • Configuring Background Jobs
  • Managing Meta Data
    • Managing Session State for an Instance
      • About Session State
      • Viewing Session Details Before Purging
      • Purging Sessions by Age
      • Viewing Session Statistics Before Purging
    • Managing the Mail Queue
      • Mail Queue Overview
      • Sending and Deleting Messages in the Mail Queue
      • About the Mail Queue Metrics Dashboard
      • About the Operational and Triage Section
      • About the Trending Section
      • About the Monitoring Section
    • Managing the Push Notifications Queue
      • Monitoring the Push Notifications Queue
    • Viewing Installed Translations
    • Deleting Interactive Report Subscriptions
  • Communicating Using Messages, Banners, and Resources List
    • Defining a Login Message
      • About Login Messages
      • Creating or Editing the Login Message
    • Defining a System Message
      • About System Messages
      • Creating and Editing a System Message
    • Defining a Workspace Message in Administration Services
    • Configuring an Environment Banner in Administration Services
    • Managing a Site-Specific Resources List
      • Adding a New Task
      • Editing an Existing Task
      • Deleting a Task
  • Creating a Service Signup Wizard
    • Defining a Service Signup Wizard
    • Configuring Service Signup Wizard Email Restrictions
    • Running a New Service Signup Wizard
  • Managing Schemas
    • Related Topics
    • What Is the Oracle APEX Engine Schema?
    • Determining the Oracle APEX Engine Schema
    • Understanding Oracle Default Schema Restrictions
      • About Assigning Oracle Default Schemas to Workspaces
      • Granting the Privilege to Assign Oracle Default Schemas
      • Revoking the Privilege to Assign Oracle Default Schemas
      • Working with Restricted Schemas
        • Removing Workspace Exceptions for a Schema
        • Removing Schema Exceptions for a Workspace
        • Designating Specific Workspaces as Exceptions
      • Determining the Privilege Status
  • Creating Workspaces in Administration Services
    • About Workspaces
    • About Specifying How Workspaces Are Created
      • About Request and Automatic Provisioning
    • Selecting a Workspace Provisioning Mode
    • How Oracle-Managed Files Affects Workspace Provisioning
    • Creating a Workspace Manually
      • Creating Workspace Manually in a Full Development Environment
      • Creating a Workspace Manually in a Runtime Environment
    • Creating Multiple Workspaces
  • Managing Existing Workspaces
    • Related Topics
    • Performing a Workspace Search
    • Viewing Existing Workspace Information
    • Isolating a Workspace to Prevent Browser Attacks
      • About Isolating a Workspace to Prevent Browser Attacks
      • Configuring Workspace Isolation Attributes
    • Deleting a Workspace
      • Identifying and Deleting Inactive Workspaces
        • How to Identify Inactive Workspaces
        • Identifying Inactive Workspaces By Checking Recent Updates
        • Removing the Resources Associated with Inactive Workspaces
        • Deleting Inactive Workspaces
      • Deleting Workspaces in a Full Development Environment
      • Deleting Workspaces in a Runtime Development Environment
    • Locking a Workspace
    • Purging Inactive Workspaces
      • Configuring Workspace Purge Settings
    • Managing Workspace to Schema Assignments
      • Viewing Schema and Workspace Assignments in a Development Environment
      • Viewing Schema and Workspace Assignments in a Runtime Environment
      • Editing Existing Schema and Workspace Assignments
      • Associating Schemas in a Full Development Environment
      • Associating Additional Schemas in a Runtime Environment
      • Removing a Schema Mapping from a Workspace in a Runtime Environment
    • Managing Component Availability for an Instance
    • Exporting and Importing a Workspace
      • About Exporting and Importing a Workspace
      • Exporting a Workspace in Administration Services
      • Importing a Workspace in Administration Services
    • Installing Exported Applications in a Runtime Environment
      • About the Advantages of Using Runtime Environment
      • Installing an Exported Application in to a Runtime Environment
    • Exporting and Importing from a Command Line
    • Changing Application Build Status in Administration Services
      • About Changing Application Build Status
        • Ways to Modify Build Status
      • Changing Build Status in Administration Services
    • Viewing the Application Attributes Report
    • Viewing the Parsing Schemas Report
    • Accessing Workspace Reports
      • Viewing the Workspace Details Report
      • Viewing Workspace Database Privileges
      • Viewing File Size and File Count by Workspace
      • Finding and Emailing Workspace Summary
      • Accessing the Data Dictionary Cache Report from Administration Services
        • Viewing or Refreshing the Data Dictionary Cache
  • Using SQLcl with APEX
    • Downloading and Installing SQLcl
    • Starting SQLcl and Connecting to the Database
    • Exiting SQLcl
    • Listing Applications
      • Listing All Applications
      • Listing Applications in a Workspace To See Last Changed Date and Time
      • Listing Only Applications in a Workspace Changed On or After a Given Date
      • Listing Only Applications in a Workspace Changed by a Given User
    • Listing Components in an Application
      • Listing Components in an Application
      • Listing Components in an Application Changed On or After a Given Date
      • Listing Components in an Application Changed by a Given User
    • Exporting and Importing Using SQLcl
      • Exporting One or More Applications
        • Exporting an Application to a Single File
        • Exporting All Applications from a Workspace
        • Exporting an Application Split into Multiple Files
        • Why the Split Option is Preferable for Source Control
        • Exporting Only Selected Application Components
        • Additional Options for Controlling APEX Application Export
      • Exporting a Workspace
        • Additional Workspace Export Options
      • Exporting Workspace Static Files
      • Installing an Application
        • About the APEX_APPLICATION_INSTALL API
        • Installing an Application from an APEXlang Export
        • Importing Selected Files from an APEXlang Application
        • Installing an Application When Target Environment Mirrors the Source
        • Installing an Application When Target Environment Differs From Source
          • Setting Up the Installation Context
          • Running the SQL Script to Install an Application
      • Importing a Workspace
      • Importing Workspace Static Files
      • Synchronizing Feedback Among Environments
        • About Synchronizing Feedback Among Environments
        • Distinguishing Between DEV, TEST, and PROD Environments
        • Exporting Feedback from Testing or Production
        • Exporting Feedback from Development to Sync Back to Testing or Production
        • Performing Incremental Feedback Export
    • Displaying Application Usage
  • Managing Users Across an Oracle APEX Instance
    • About the Advantages of Managing Users at the Instance Level
    • About Oracle APEX Accounts Authentication
    • About Oracle APEX User Roles
    • Creating New User Accounts in Administration Services
    • Editing an Existing User Account in Administration Services
    • Deleting User Accounts in Administration Services
  • Monitoring Activity Across an Instance
    • About Web Server Logs
    • Accessing the Monitor Activity Page in Administration Services
    • Viewing the Administrator Digest
    • Viewing the Signup Survey Report
    • Viewing the Backup Log
  • Configuring and Deleting Logs and Log Entries
    • Managing Log Intervals
    • Archiving the Activity Log
    • Deleting SQL Workshop Log Entries
    • Deleting Page View Activity Log Entries
    • Managing the Developer Activity Log
    • Deleting Click Counting Log Entries
    • Deleting the Login Access Log
    • Deleting Web Service Activity Log Entries
    • Deleting REST Synchronization Log Entries
    • Deleting Automation Log Entries
    • Viewing Install and Upgrade Logs
• Appendix A: DBMS_SCHEDULER Jobs
  • List of DBMS_SCHEDULER Jobs