Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
• 1 Changes in Release 23.2 for Oracle APEX Administration Guide
• 2 Workspace and Application Administration
  • 2.1 Understanding Workspace Administration
    • 2.1.1 What is a Workspace Administrator?
    • 2.1.2 Accessing the Workspace Administration Page
    • 2.1.3 Workspace Administration Page
    • 2.1.4 Resetting Your Password
    • 2.1.5 Viewing Product Release and Environment Information
    • 2.1.6 Managing Export Files in the Current Workspace
    • 2.1.7 Managing Saved Interactive Reports
      • 2.1.7.1 About Saved Interactive Reports
      • 2.1.7.2 Viewing and Deleting Saved Interactive Reports
      • 2.1.7.3 Managing Interactive Report Subscriptions
    • 2.1.8 Viewing a Workspace Summary
      • 2.1.8.1 Viewing the Workspace Utilization Report
      • 2.1.8.2 Emailing the Workspace Utilization Report
    • 2.1.9 Requesting a Workspace in Workspace Administration
  • 2.2 Using the Manage Service Page
    • 2.2.1 Accessing the Manage Service Page
    • 2.2.2 Manage Service Page
  • 2.3 Making a Service Request
    • 2.3.1 Determining the Space Available in a Workspace
      • 2.3.1.1 Viewing the Detailed Tablespace Utilization Report
    • 2.3.2 Viewing the Service Request History for the Workspace
    • 2.3.3 Requesting a New Schema
    • 2.3.4 Requesting More Storage
    • 2.3.5 Requesting Another Workspace
    • 2.3.6 Terminating a Workspace
  • 2.4 Configuring Workspace Preferences
    • 2.4.1 Managing Workspace Account Login Controls
      • 2.4.1.1 About Login Controls
      • 2.4.1.2 Configuring Workspace Account Login Controls
    • 2.4.2 Controlling Access to App Builder
    • 2.4.3 Controlling Access to SQL Workshop
    • 2.4.4 Disabling PL/SQL Program Unit Editing for a Workspace
    • 2.4.5 Enabling RESTful Services and Defining a Path Prefix for a Workspace
    • 2.4.6 Configuring Team Development in an Existing Workspace
    • 2.4.7 Configuring Session Timeout for a Workspace
  • 2.5 Defining a Workspace Message
    • 2.5.1 About Workspace Messages
    • 2.5.2 Defining and Editing Workspace Messages
  • 2.6 Configuring an Environment Banner for a Workspace
  • 2.7 Managing Links on the Extension Menu
    • 2.7.1 About the Extension Menu
    • 2.7.2 Adding Links to the Extension Menu
    • 2.7.3 Editing Extension Menu Links
    • 2.7.4 Deleting Extension Menu Links
  • 2.8 Managing Users in a Workspace
    • 2.8.1 About Oracle APEX Accounts Authentication
    • 2.8.2 About Oracle APEX User Roles
    • 2.8.3 Creating User Accounts
      • 2.8.3.1 Creating a New User Account
      • 2.8.3.2 Creating Multiple Users Simultaneously
    • 2.8.4 Editing Existing User Accounts
    • 2.8.5 Locking and Unlocking a User Account
    • 2.8.6 Changing a User Account Password
    • 2.8.7 Deleting User Accounts
      • 2.8.7.1 Deleting a Single User Account
      • 2.8.7.2 Deleting Multiple Users at Once
    • 2.8.8 Viewing the Users Dashboard
    • 2.8.9 Using Groups to Manage Oracle APEX Users
      • 2.8.9.1 About Groups
      • 2.8.9.2 Creating a Group
      • 2.8.9.3 Editing an Existing User Group
      • 2.8.9.4 Adding and Removing Users from a Group
      • 2.8.9.5 Assigning a Group to Another Group
      • 2.8.9.6 Viewing Group Assignments
  • 2.9 Accessing the Data Dictionary Cache Report from Workspace Administration
    • 2.9.1 Viewing or Refreshing the Workspace Data Dictionary Cache
  • 2.10 Purging the Developer Activity and Click Count Log Files
    • 2.10.1 Purging the Developer Activity Log
    • 2.10.2 Purging the External Click Count Log
  • 2.11 Managing Session State for a Workspace
    • 2.11.1 About Session State
    • 2.11.2 Removing Session State After Reviewing Session Details
    • 2.11.3 Viewing Session State for the Current Session
    • 2.11.4 Purging Sessions by Age
    • 2.11.5 Purging Session State for the Current Session
  • 2.12 Managing User Preferences
    • 2.12.1 Setting User Preferences
      • 2.12.1.1 Setting User Preferences by Creating a Page Process
      • 2.12.1.2 Setting the Source of an Item Based on a User Preference
      • 2.12.1.3 Setting User Preferences Programmatically
    • 2.12.2 Viewing Preferences by User
    • 2.12.3 Viewing Current User Preferences
    • 2.12.4 Purging Preferences for a Specific User
    • 2.12.5 Purging Preferences for the Current User
    • 2.12.6 Removing User Preferences Programmatically
    • 2.12.7 Resetting User Preferences Using a Page Process
  • 2.13 Managing Page and Region Caching
    • 2.13.1 Purging Cached Regions and Pages
  • 2.14 Changing Build Status for Multiple Applications
    • 2.14.1 About Changing Application Build Status
    • 2.14.2 Managing Build Status in Workspace Administration
  • 2.15 Monitoring Activity Within a Workspace
    • 2.15.1 Accessing the Monitor Activity Page in Workspace Administration
    • 2.15.2 Viewing Application Changes by Developer
    • 2.15.3 Viewing Application Changes by Day
    • 2.15.4 Viewing Active Sessions
      • 2.15.4.1 What is an Active Session?
      • 2.15.4.2 Viewing the Active Sessions Report
    • 2.15.5 Viewing Schema Reports and Other Reports
  • 2.16 Viewing Workspace Dashboards
    • 2.16.1 Accessing the Workspace Dashboards
    • 2.16.2 Workspace Dashboard
    • 2.16.3 Users Dashboard
    • 2.16.4 Activity Dashboard
    • 2.16.5 Developer Activity Dashboard
    • 2.16.6 Performance Dashboard
    • 2.16.7 Applications Dashboard
    • 2.16.8 Database Dashboard
• 3 Oracle APEX Administration Services
  • 3.1 Understanding Administration Services
    • 3.1.1 What Is an Instance Administrator?
    • 3.1.2 Signing In To Administration Services
    • 3.1.3 Overview: Administration Services UI
      • 3.1.3.1 Administration Services Home Page
      • 3.1.3.2 Manage Instance Page
      • 3.1.3.3 Manage Workspaces Page
  • 3.2 Managing Requests
    • 3.2.1 About Workspace Requests and Change Requests
    • 3.2.2 Viewing Requests on the Administration Services Home Page
    • 3.2.3 Viewing Pending Requests
    • 3.2.4 Managing Workspace Requests
      • 3.2.4.1 About the Workspace Request Approval Process
      • 3.2.4.2 Approving or Declining a Pending Workspace Request
      • 3.2.4.3 Changing the Status of an Existing Workspace Request
      • 3.2.4.4 Deleting a Workspace Request
    • 3.2.5 Managing Change Requests
      • 3.2.5.1 Approving or Declining a Pending Change Request
  • 3.3 Managing Feature Configuration
    • 3.3.1 Configuring Application Development Settings
      • 3.3.1.1 Disabling PL/SQL Program Unit Editing for an Instance
      • 3.3.1.2 Enabling the Creation of Demonstration Objects in New Workspaces
      • 3.3.1.3 Configuring the Number of Application Backups
    • 3.3.2 Configuring SQL Workshop
    • 3.3.3 Configuring Monitoring
      • 3.3.3.1 Enabling Database Monitoring
      • 3.3.3.2 Enabling Application Activity Logging
      • 3.3.3.3 Enabling Web Service Activity Logging
      • 3.3.3.4 Enabling Application Tracing
    • 3.3.4 Enabling RESTful Services for an Instance
    • 3.3.5 Enabling Service Requests
    • 3.3.6 Configuring Team Development for New Workspaces
  • 3.4 Configuring Security
    • 3.4.1 Configuring Service-level Security Settings
      • 3.4.1.1 Controlling Workspace Cookies
      • 3.4.1.2 Controlling Persistent Authentication
      • 3.4.1.3 Disabling Access to Administration Services
      • 3.4.1.4 Enabling Access to Oracle APEX Administration Services
      • 3.4.1.5 Disabling Workspace Login Access
      • 3.4.1.6 Disabling App Login Access
      • 3.4.1.7 Controlling Public File Upload
      • 3.4.1.8 Restricting User Access by IP Address
      • 3.4.1.9 Configuring a Proxy Server for an Instance
      • 3.4.1.10 Selecting a Checksum Hash Function
      • 3.4.1.11 Configuring Rejoin Sessions for an Instance
      • 3.4.1.12 Configuring Unhandled Errors
    • 3.4.2 Configuring HTTP Protocol Attributes
      • 3.4.2.1 About SSL
      • 3.4.2.2 Requiring HTTPS
      • 3.4.2.3 Reversing Require HTTPS
      • 3.4.2.4 Reversing Require Outbound HTTPS
      • 3.4.2.5 Configuring Additional Response Headers
    • 3.4.3 Enabling Real Application Security
    • 3.4.4 Configuring Session Timeout for an Instance
    • 3.4.5 Isolating All Workspaces in an Instance
      • 3.4.5.1 About Isolating Workspaces to Prevent Browser Attacks
      • 3.4.5.2 Configuring Instance-Level Workspace Isolation Attributes
    • 3.4.6 Defining Excluded Domains for Regions and Web Services
    • 3.4.7 Configuring Authentication Controls for an Instance
      • 3.4.7.1 About Authentication Controls
      • 3.4.7.2 Configuring Security for Developer and End User Login
      • 3.4.7.3 Configuring Authentication Schemes for an Instance
        • 3.4.7.3.1 Editing Oracle APEX Accounts
        • 3.4.7.3.2 Editing Database Accounts
        • 3.4.7.3.3 Editing HTTP Header Variable
        • 3.4.7.3.4 Editing LDAP Directory
        • 3.4.7.3.5 Editing Oracle Application Server Single Sign-On
        • 3.4.7.3.6 Editing SAML Sign In
          • 3.4.7.3.6.1 About SAML Sign In
          • 3.4.7.3.6.2 About Response Signing when Using SAML
          • 3.4.7.3.6.3 About Cross-Origin Resource Sharing when Using SAML
          • 3.4.7.3.6.4 Configuring SAML Sign-In
        • 3.4.7.3.7 Editing Social Sign-In
      • 3.4.7.4 Configuring Security Settings for Workspace Administrator and Developer Accounts
    • 3.4.8 Creating Strong Password Policies
      • 3.4.8.1 About Strong Password Policies
      • 3.4.8.2 Configuring Password Policies
    • 3.4.9 Managing Authorized URLs
      • 3.4.9.1 Defining a List of Authorized URLs
      • 3.4.9.2 Editing a Defined Authorized URL
      • 3.4.9.3 Deleting Defined Authorized URL
  • 3.5 Configuring Instance Settings
    • 3.5.1 About Configuring Workspace Provisioning
    • 3.5.2 Disabling Email Provisioning
    • 3.5.3 Configuring Storage
      • 3.5.3.1 Requiring a New Schema
      • 3.5.3.2 Configuring Instance Tablespace
      • 3.5.3.3 Enabling Auto Extend Tablespaces
      • 3.5.3.4 Enabling Bigfile Tablespaces
      • 3.5.3.5 Enabling Encrypted Tablespaces
      • 3.5.3.6 Enabling Automatic Approval of Storage Requests
      • 3.5.3.7 Deleting Uploaded Files
    • 3.5.4 Configuring Email
      • 3.5.4.1 About Enabling Network Services
      • 3.5.4.2 Configuring Email in a Full Development Environment
      • 3.5.4.3 Configuring Email in a Runtime Environment
      • 3.5.4.4 Determining Email Settings in a Runtime Environment
    • 3.5.5 Configuring Wallet Information
      • 3.5.5.1 About SSL and Wallet Creation
      • 3.5.5.2 Configuring a Wallet in a Full Development Environment
      • 3.5.5.3 Configuring a Wallet in a Runtime Environment
      • 3.5.5.4 Determining Wallet Settings in a Runtime Environment
    • 3.5.6 Configuring Report Printing for an Instance
      • 3.5.6.1 About Configuring Report Printing
      • 3.5.6.2 Configuring Report Printing in a Full Development Environment
      • 3.5.6.3 Configuring Report Printing Settings in a Runtime Environment
      • 3.5.6.4 Determining Report Printing Settings in a Runtime Environment
    • 3.5.7 Configuring Workflow Settings
      • 3.5.7.1 Configuring Task Retention
      • 3.5.7.2 Configuring Workflow Retention
    • 3.5.8 Configuring the Application Gallery
      • 3.5.8.1 About the Application Gallery
      • 3.5.8.2 Disabling Background Installations
      • 3.5.8.3 Special Use Cases
        • 3.5.8.3.1 Advanced Configuration
        • 3.5.8.3.2 Hosting APEX Sample and Starter Apps Internally
        • 3.5.8.3.3 Including Custom Apps in the Gallery
        • 3.5.8.3.4 manifest.json Example
    • 3.5.9 Configuring the Help Menu
    • 3.5.10 Configuring Workspace Size Requests
    • 3.5.11 Managing Application ID Range
    • 3.5.12 Configuring Background Jobs
  • 3.6 Managing Public Themes
    • 3.6.1 Adding a Public Theme to the Theme Repository
    • 3.6.2 Deleting a Public Theme
    • 3.6.3 Modifying a Public Theme
    • 3.6.4 About Exporting a Public Theme
  • 3.7 Managing Meta Data
    • 3.7.1 Managing Session State for an Instance
      • 3.7.1.1 About Session State
      • 3.7.1.2 Viewing Session Details Before Purging
      • 3.7.1.3 Purging Sessions by Age
      • 3.7.1.4 Viewing Session Statistics Before Purging
    • 3.7.2 Managing the Mail Queue
      • 3.7.2.1 Sending and Deleting Messages in the Mail Queue
    • 3.7.3 Managing the Push Notifications Queue
      • 3.7.3.1 Monitoring the Push Notifications Queue
    • 3.7.4 Viewing Installed Translations
    • 3.7.5 Deleting Interactive Report Subscriptions
  • 3.8 Communicating Using Messages, Banners, and Resources List
    • 3.8.1 Defining a Login Message
      • 3.8.1.1 About Login Messages
      • 3.8.1.2 Creating or Editing the Login Message
    • 3.8.2 Defining a System Message
      • 3.8.2.1 About System Messages
      • 3.8.2.2 Creating and Editing a System Message
    • 3.8.3 Defining a Workspace Message in Administration Services
    • 3.8.4 Configuring an Environment Banner in Administration Services
    • 3.8.5 Managing a Site-Specific Resources List
      • 3.8.5.1 Adding a New Task
      • 3.8.5.2 Editing an Existing Task
      • 3.8.5.3 Deleting a Task
  • 3.9 Creating a Service Signup Wizard
    • 3.9.1 Defining a Service Signup Wizard
    • 3.9.2 Configuring Service Signup Wizard Email Restrictions
    • 3.9.3 Running a New Service Signup Wizard
  • 3.10 Managing Schemas
    • 3.10.1 What Is the Oracle APEX Engine Schema?
    • 3.10.2 Determining the Oracle APEX Engine Schema
    • 3.10.3 Understanding Oracle Default Schema Restrictions
      • 3.10.3.1 About Assigning Oracle Default Schemas to Workspaces
      • 3.10.3.2 Granting the Privilege to Assign Oracle Default Schemas
      • 3.10.3.3 Revoking the Privilege to Assign Oracle Default Schemas
      • 3.10.3.4 Working with Restricted Schemas
        • 3.10.3.4.1 Removing Workspace Exceptions for a Schema
        • 3.10.3.4.2 Removing Schema Exceptions for a Workspace
        • 3.10.3.4.3 Designating Specific Workspaces as Exceptions
      • 3.10.3.5 Determining the Privilege Status
  • 3.11 Creating Workspaces in Administration Services
    • 3.11.1 About Workspaces
    • 3.11.2 About Specifying How Workspaces Are Created
    • 3.11.3 Selecting a Workspace Provisioning Mode
    • 3.11.4 How Oracle-Managed Files Affects Workspace Provisioning
    • 3.11.5 Creating a Workspace Manually
      • 3.11.5.1 Creating Workspace Manually in a Full Development Environment
      • 3.11.5.2 Creating a Workspace Manually in a Runtime Environment
    • 3.11.6 Creating Multiple Workspaces
  • 3.12 Managing Existing Workspaces
    • 3.12.1 Performing a Workspace Search
    • 3.12.2 Editing Workspace Information
    • 3.12.3 Isolating a Workspace to Prevent Browser Attacks
      • 3.12.3.1 About Isolating a Workspace to Prevent Browser Attacks
      • 3.12.3.2 Configuring Workspace Isolation Attributes
    • 3.12.4 Deleting a Workspace
      • 3.12.4.1 Identifying and Deleting Inactive Workspaces
        • 3.12.4.1.1 How to Identify Inactive Workspaces
        • 3.12.4.1.2 Identifying Inactive Workspaces By Checking Recent Updates
        • 3.12.4.1.3 Removing the Resources Associated with Inactive Workspaces
        • 3.12.4.1.4 Deleting Inactive Workspaces
      • 3.12.4.2 Deleting Workspaces in a Full Development Environment
      • 3.12.4.3 Deleting Workspaces in a Runtime Development Environment
    • 3.12.5 Locking a Workspace
    • 3.12.6 Purging Inactive Workspaces
      • 3.12.6.1 Configuring Workspace Purge Settings
    • 3.12.7 Managing Workspace to Schema Assignments
      • 3.12.7.1 Viewing Schema and Workspace Assignments in a Development Environment
      • 3.12.7.2 Viewing Schema and Workspace Assignments in a Runtime Environment
      • 3.12.7.3 Editing Existing Schema and Workspace Assignments
      • 3.12.7.4 Associating Schemas in a Full Development Environment
      • 3.12.7.5 Associating Additional Schemas in a Runtime Environment
      • 3.12.7.6 Removing a Schema Mapping from a Workspace in a Runtime Environment
    • 3.12.8 Managing Component Availability for an Instance
    • 3.12.9 Exporting and Importing a Workspace
      • 3.12.9.1 About Exporting and Importing a Workspace
      • 3.12.9.2 Exporting a Workspace in Administration Services
      • 3.12.9.3 Importing a Workspace in Administration Services
    • 3.12.10 Installing Exported Applications in a Runtime Environment
      • 3.12.10.1 About the Advantages of Using Runtime Environment
      • 3.12.10.2 Installing an Exported Application in to a Runtime Environment
    • 3.12.11 Exporting and Importing from a Command Line
      • 3.12.11.1 Exporting and Importing Using SQLcl
        • 3.12.11.1.1 Downloading and Installing SQLcl
        • 3.12.11.1.2 Starting SQLcl and Connecting to the Database
        • 3.12.11.1.3 Exiting SQLcl
        • 3.12.11.1.4 Listing Applications
          • 3.12.11.1.4.1 Listing All Applications
          • 3.12.11.1.4.2 Listing Applications in a Workspace To See Last Changed Date and Time
          • 3.12.11.1.4.3 Listing Only Applications in a Workspace Changed On or After a Given Date
          • 3.12.11.1.4.4 Listing Only Applications in a Workspace Changed by a Given User
        • 3.12.11.1.5 Listing Components in an Application
          • 3.12.11.1.5.1 Listing Components in an Application
          • 3.12.11.1.5.2 Listing Components in an Application Changed On or After a Given Date
          • 3.12.11.1.5.3 Listing Components in an Application Changed by a Given User
        • 3.12.11.1.6 Exporting One or More Applications
          • 3.12.11.1.6.1 Exporting an Application to a Single File
          • 3.12.11.1.6.2 Exporting All Applications from a Workspace
          • 3.12.11.1.6.3 Exporting an Application Split into Multiple Files
          • 3.12.11.1.6.4 Why the Split Option is Preferable for Source Control
          • 3.12.11.1.6.5 Exporting Only Selected Application Components
          • 3.12.11.1.6.6 Additional Options for Controlling APEX Application Export
        • 3.12.11.1.7 Exporting a Workspace
        • 3.12.11.1.8 Exporting Workspace Static Files
        • 3.12.11.1.9 Installing an Application
          • 3.12.11.1.9.1 Installing an Application When Target Environment Mirrors the Source
          • 3.12.11.1.9.2 Installing an Application When Target Environment Differs From Source
        • 3.12.11.1.10 Importing a Workspace
        • 3.12.11.1.11 Importing Workspace Static Files
        • 3.12.11.1.12 Synchronizing Feedback Among Environments
          • 3.12.11.1.12.1 About Synchronizing Feedback Among Environments
          • 3.12.11.1.12.2 Distinguishing Between DEV, TEST, and PROD Environments
          • 3.12.11.1.12.3 Exporting Feedback from Testing or Production
          • 3.12.11.1.12.4 Exporting Feedback from Development to Sync Back to Testing or Production
          • 3.12.11.1.12.5 Performing Incremental Feedback Export
        • 3.12.11.1.13 Displaying Application Usage
    • 3.12.12 Changing Application Build Status in Administration Services
      • 3.12.12.1 About Changing Application Build Status
      • 3.12.12.2 Changing Build Status in Administration Services
    • 3.12.13 Viewing the Application Attributes Report
    • 3.12.14 Accessing Workspace Reports
      • 3.12.14.1 Viewing the Workspace Details Report
      • 3.12.14.2 Viewing Workspace Database Privileges
      • 3.12.14.3 Viewing File Size and File Count by Workspace
      • 3.12.14.4 Finding and Emailing Workspace Summary
      • 3.12.14.5 Accessing the Data Dictionary Cache Report from Administration Services
        • 3.12.14.5.1 Viewing or Refreshing the Data Dictionary Cache
    • 3.12.15 Viewing the Parsing Schemas Report
  • 3.13 Managing Users Across an Oracle APEX Instance
    • 3.13.1 About the Advantages of Managing Users at the Instance Level
    • 3.13.2 About Oracle APEX Accounts Authentication
    • 3.13.3 About Oracle APEX User Roles
    • 3.13.4 Creating New User Accounts in Administration Services
    • 3.13.5 Editing an Existing User Account in Administration Services
    • 3.13.6 Deleting User Accounts in Administration Services
  • 3.14 Monitoring Activity Across an Instance
    • 3.14.1 About Web Server Logs
    • 3.14.2 Accessing the Monitor Activity Page in Administration Services
    • 3.14.3 Viewing the Administrator Digest
    • 3.14.4 Viewing the Signup Survey Report
    • 3.14.5 Viewing the Backup Log
  • 3.15 Configuring and Deleting Logs and Log Entries
    • 3.15.1 Deleting SQL Workshop Logs
    • 3.15.2 Deleting Page View Activity Log Entries
      • 3.15.2.1 About Page View Activity Logs
      • 3.15.2.2 Truncating Page View Activity Logs Manually
    • 3.15.3 Deleting Developer Activity Log Entries
    • 3.15.4 Managing Developer Log Retention
    • 3.15.5 Deleting Click Counting Log Entries
    • 3.15.6 Deleting the Login Access Log
    • 3.15.7 Managing Log Intervals
    • 3.15.8 Archiving the Activity Log
    • 3.15.9 Deleting Web Service Log Entries
    • 3.15.10 Configuring or Deleting the REST Source Synchronization Log
    • 3.15.11 Configuring or Deleting the Automation Log
• A DBMS_SCHEDULER Jobs
  • A.1 List of DBMS_SCHEDULER Jobs
• Index