1/44

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 18.2
  • New Features
  • Deprecated and Desupported Features
  • Other Changes
• Changes in Oracle Application Express Release 18.1
  • Deprecated and Desupported Features
  • Other Changes

1 Workspace and Application Administration

• 1.1 Understanding Workspace Administration
  • 1.1.1 What is a Workspace Administrator?
  • 1.1.2 Accessing the Workspace Administration Page
  • 1.1.3 Workspace Administration Page
  • 1.1.4 Resetting Your Password
  • 1.1.5 Viewing Product Release and Environment Information
  • 1.1.6 Managing Exported Files
  • 1.1.7 Managing Saved Interactive Reports
    • 1.1.7.1 About Saved Interactive Reports
    • 1.1.7.2 Viewing and Deleting Saved Interactive Reports
    • 1.1.7.3 Managing Interactive Report Subscriptions
  • 1.1.8 Viewing a Workspace Summary
    • 1.1.8.1 Viewing the Workspace Utilization Report
    • 1.1.8.2 Emailing the Workspace Utilization Report
  • 1.1.9 Removing and Validating Websheet Database Objects
  • 1.1.10 Requesting a New Workspace Manually
• 1.2 Monitoring Activity Within a Workspace
  • 1.2.1 Accessing the Monitor Activity Page
  • 1.2.2 Viewing Application Changes by Developer
  • 1.2.3 Viewing Application Changes by Day
  • 1.2.4 Viewing Active Sessions
    • 1.2.4.1 What is an Active Session?
    • 1.2.4.2 Viewing the Active Sessions Report
  • 1.2.5 Viewing Schema Reports
• 1.3 Using the Manage Service Page
  • 1.3.1 Accessing the Manage Service Page
  • 1.3.2 Manage Service Page
• 1.4 Making a Service Request
  • 1.4.1 Requesting a New Schema
  • 1.4.2 Requesting More Storage
  • 1.4.3 Terminating a Workspace
  • 1.4.4 Determining the Amount of Space Available in Your Workspace
    • 1.4.4.1 Viewing the Detailed Tablespace Utilization Report
  • 1.4.5 Signing Up for Another Workspace
• 1.5 Configuring Workspace Preferences
  • 1.5.1 Creating Account Login Controls for a Workspace
    • 1.5.1.1 About Login Controls
    • 1.5.1.2 Configuring Workspace Account Login Controls
  • 1.5.2 Controlling Access to App Builder
  • 1.5.3 Controlling Access to SQL Workshop
  • 1.5.4 Disabling PL/SQL Program Unit Editing for a Workspace
  • 1.5.5 Enabling RESTful Services for a Workspace
  • 1.5.6 Managing Team Development
    • 1.5.6.1 Enabling Team Development for a Workspace
    • 1.5.6.2 Enabling Workspace-level Support for File Upload in Team Development
• 1.6 Defining a Workspace Message
  • 1.6.1 About Workspace Messages
  • 1.6.2 Creating and Editing a Workspace Message
• 1.7 Managing Users in a Workspace
  • 1.7.1 About Application Accounts Authentication
  • 1.7.2 About Application Express User Roles
  • 1.7.3 Creating User Accounts
    • 1.7.3.1 Creating a New User Account
    • 1.7.3.2 Creating Multiple Users Simultaneously
  • 1.7.4 Editing Existing User Accounts
  • 1.7.5 Locking and Unlocking a User Account
  • 1.7.6 Changing a User Account Password
  • 1.7.7 Deleting User Accounts
    • 1.7.7.1 Deleting a Single User Account
    • 1.7.7.2 Deleting Multiple Users at Once
  • 1.7.8 Viewing the Users Dashboard
  • 1.7.9 Using Groups to Manage Application Express Users
    • 1.7.9.1 About Groups
    • 1.7.9.2 Creating a Group
    • 1.7.9.3 Editing an Existing User Group
    • 1.7.9.4 Adding and Removing Users from a Group
    • 1.7.9.5 Assigning a Group to Another Group
    • 1.7.9.6 Viewing Group Assignments
• 1.8 Purging the Developer Activity and Click Count Log Files
  • 1.8.1 Purging the Developer Activity Log
  • 1.8.2 Purging the External Click Count Log
• 1.9 Managing Session State for a Workspace
  • 1.9.1 About Session State
  • 1.9.2 Removing Session State After Reviewing Session Details
  • 1.9.3 Viewing Session State for the Current Session
  • 1.9.4 Purging Sessions by Age
  • 1.9.5 Purging Session State for the Current Session
• 1.10 Managing User Preferences
  • 1.10.1 Setting User Preferences
    • 1.10.1.1 Setting User Preferences by Creating a Page Process
    • 1.10.1.2 Setting the Source of an Item Based on a User Preference
    • 1.10.1.3 Setting User Preferences Programmatically
  • 1.10.2 Viewing Preferences by User
  • 1.10.3 Viewing Current User Preferences
  • 1.10.4 Purging Preferences for a Specific User
  • 1.10.5 Purging Preferences for the Current User
  • 1.10.6 Removing User Preferences Programmatically
  • 1.10.7 Resetting User Preferences Using a Page Process
• 1.11 Managing Page and Region Caching
  • 1.11.1 Purging Cached Regions and Pages
• 1.12 Changing Build Status for Multiple Applications
  • 1.12.1 About Changing Application Build Status?
  • 1.12.2 Managing Build Status in Workspace Administration
• 1.13 Viewing Workspace Dashboards
  • 1.13.1 Accessing the Workspace Dashboards
  • 1.13.2 Workspace Dashboard
  • 1.13.3 Users Dashboard
  • 1.13.4 Activity Dashboard
  • 1.13.5 Developer Activity Dashboard
  • 1.13.6 Performance Dashboard
  • 1.13.7 Websheets Dashboard
  • 1.13.8 Applications Dashboard
  • 1.13.9 Database Dashboard
• 1.14 Leveraging App Builder Defaults
  • 1.14.1 About App Builder Defaults
  • 1.14.2 Configuring App Builder Defaults

2 Oracle Application Express Administration Services

• 2.1 What Is an Instance Administrator?
• 2.2 Signing In To Oracle Application Express Administration Services
• 2.3 Overview of Oracle Application Express Administration Services
  • 2.3.1 Instance Administration Home Page
  • 2.3.2 Manage Instance Page
  • 2.3.3 Manage Workspaces Page
• 2.4 Managing Workspace and Change Requests
  • 2.4.1 About Workspace Requests and Change Requests
  • 2.4.2 Viewing Requests on the Instance Administration Home Page
  • 2.4.3 Viewing Pending Requests
  • 2.4.4 Managing Workspace Requests
    • 2.4.4.1 About the Workspace Request Approval Process
    • 2.4.4.2 Approving or Declining a Pending Workspace Request
    • 2.4.4.3 Changing the Status of an Existing Workspace Request
    • 2.4.4.4 Deleting a Workspace Request
  • 2.4.5 Managing Change Requests
    • 2.4.5.1 Approving or Declining a Pending Change Request
• 2.5 Managing Instance Settings
  • 2.5.1 Managing Feature Configuration
    • 2.5.1.1 Disabling PL/SQL Program Unit Editing for an Instance
    • 2.5.1.2 Enabling the Creation of Demonstration Objects in New Workspaces
    • 2.5.1.3 Enabling the Creation of Websheet Objects in New Workspaces
    • 2.5.1.4 Enabling and Disabling SQL Access in Websheets
    • 2.5.1.5 Configuring Application Installation Options
    • 2.5.1.6 Configuring SQL Workshop
    • 2.5.1.7 Enabling Database Monitoring
    • 2.5.1.8 Enabling Application Activity Logging
    • 2.5.1.9 Enabling Web Service Activity Logging
    • 2.5.1.10 Enabling Application Tracing
    • 2.5.1.11 Enabling REST for an Instance
    • 2.5.1.12 Enabling Service Requests
    • 2.5.1.13 Enabling Instance-level Support for File Upload in Team Development
  • 2.5.2 Configuring Security
    • 2.5.2.1 Configuring Service-level Security Settings
      • 2.5.2.1.1 Controling If Cookies Populate the Login Form
      • 2.5.2.1.2 Disabling Access to Oracle Application Express Administration Services
      • 2.5.2.1.3 Enabling Access to Oracle Application Express Administration Services
      • 2.5.2.1.4 Disabling Workspace Login Access
      • 2.5.2.1.5 Controlling Public File Upload
      • 2.5.2.1.6 Restricting User Access by IP Address
      • 2.5.2.1.7 Configuring a Proxy Server for an Instance
      • 2.5.2.1.8 Selecting a Checksum Hash Function
      • 2.5.2.1.9 Configuring Rejoin Sessions for an Instance
      • 2.5.2.1.10 Configuring Unhandled Errors
    • 2.5.2.2 Configuring HTTP Protocol Attributes
      • 2.5.2.2.1 About SSL
      • 2.5.2.2.2 Requiring HTTPS
      • 2.5.2.2.3 Reversing Require HTTPS
      • 2.5.2.2.4 Reversing Require Outbound HTTPS
      • 2.5.2.2.5 Configuring Additional Response Headers
    • 2.5.2.3 Enabling Real Application Security
    • 2.5.2.4 Configuring Session Timeout
    • 2.5.2.5 Isolating All Workspaces in an Instance
      • 2.5.2.5.1 About Isolating Workspaces to Prevent Browser Attacks
      • 2.5.2.5.2 Configuring Instance-Level Workspace Isolation Attributes
    • 2.5.2.6 Defining Excluded Domains for Regions and Web Services
    • 2.5.2.7 Configuring Authentication Controls for an Instance
      • 2.5.2.7.1 About Authentication Controls
      • 2.5.2.7.2 Configuring Security for Developer and End User Login
      • 2.5.2.7.3 Configuring Security Settings for Workspace Administrator and Developer Accounts
      • 2.5.2.7.4 Editing Development Environment Authentication Scheme
    • 2.5.2.8 Creating Strong Password Policies
      • 2.5.2.8.1 About Strong Password Policies
      • 2.5.2.8.2 Configuring Password Policies
    • 2.5.2.9 Restricting Access to Oracle Application Express by Database Access Descriptor (DAD)
      • 2.5.2.9.1 About Enforcing Access Restrictions Per DAD
      • 2.5.2.9.2 About Changing and Recompiling wwv_flow_epg_include_local
      • 2.5.2.9.3 Specifying Allowed Named Procedures
      • 2.5.2.9.4 Altering the Product Schema
    • 2.5.2.10 Managing Authorized URLs
      • 2.5.2.10.1 Defining a List of Authorized URLs
      • 2.5.2.10.2 Editing a Defined Authorized URL
      • 2.5.2.10.3 Deleting Defined Authorized URL
  • 2.5.3 Configuring Instance Settings
    • 2.5.3.1 About Configuring Self Service Workspace Provisioning
    • 2.5.3.2 Disabling Email Provisioning
    • 2.5.3.3 Configuring Storage
      • 2.5.3.3.1 Requiring a New Schema
      • 2.5.3.3.2 Enabling Auto Extend Tablespaces
      • 2.5.3.3.3 Enabling Bigfile Tablespaces
      • 2.5.3.3.4 Enabling Encrypted Tablespaces
      • 2.5.3.3.5 Deleting Uploaded Files
    • 2.5.3.4 Configuring Email
      • 2.5.3.4.1 About Enabling Network Services
      • 2.5.3.4.2 Configuring Email in a Full Development Environment
      • 2.5.3.4.3 Configuring Email in a Runtime Environment
      • 2.5.3.4.4 Determining Email Settings in a Runtime Environment
    • 2.5.3.5 Configuring Wallet Information
      • 2.5.3.5.1 About SSL and Wallet Creation
      • 2.5.3.5.2 Configuring a Wallet in a Full Development Environment
      • 2.5.3.5.3 Configuring a Wallet in a Runtime Environment
      • 2.5.3.5.4 Determining Wallet Settings in a Runtime Environment
    • 2.5.3.6 Configuring Report Printing
      • 2.5.3.6.1 About Configuring Report Printing
      • 2.5.3.6.2 Configuring Report Printing in a Full Development Environment
      • 2.5.3.6.3 Configuring Report Printing Settings in a Runtime Environment
      • 2.5.3.6.4 Determining Report Printing Settings in a Runtime Environment
    • 2.5.3.7 Configuring the Help Menu
    • 2.5.3.8 Configuring Workspace Size Options for Requests
    • 2.5.3.9 Managing Application ID Range
  • 2.5.4 Purging Inactive Workspaces
    • 2.5.4.1 Configuring Workspace Purge Settings
  • 2.5.5 Using the REST Administration Interface to View Usage Statistics
    • 2.5.5.1 About the REST Administration Interface
    • 2.5.5.2 Enabling the REST Administration Interface
    • 2.5.5.3 Registering REST Client Applications
    • 2.5.5.4 Viewing REST Client Details
    • 2.5.5.5 Removing a REST Client
    • 2.5.5.6 Disabling the REST Administration Interface
• 2.6 Using the Productivity and Sample Applications Repository
  • 2.6.1 Accessing the Productivity and Sample Applications Repository
  • 2.6.2 Managing Custom Applications
    • 2.6.2.1 About Making Custom Apps Available to Users
    • 2.6.2.2 Uploading a Custom App to the Repository
    • 2.6.2.3 Editing Custom Application Details
    • 2.6.2.4 Deleting a Custom Application
• 2.7 Managing Public Themes
  • 2.7.1 Adding a Public Theme to the Theme Repository
  • 2.7.2 Deleting a Public Theme
  • 2.7.3 Modifying a Public Theme
  • 2.7.4 About Exporting a Public Theme
• 2.8 Managing Meta Data
  • 2.8.1 Managing Session State for an Instance
    • 2.8.1.1 About Session State
    • 2.8.1.2 Viewing Session Details Before Purging
    • 2.8.1.3 Purging Sessions by Age
    • 2.8.1.4 Viewing Session Statistics Before Purging
  • 2.8.2 Managing the Mail Queue
    • 2.8.2.1 Sending and Deleting Messages in the Mail Queue
  • 2.8.3 Viewing Installed Translations
  • 2.8.4 Deleting Interactive Report Subscriptions
• 2.9 Installing Exported Applications in a Runtime Environment
  • 2.9.1 About the Advantages of Using Runtime Environment
  • 2.9.2 Installing an Exported Application in to a Runtime Environment
• 2.10 Managing Messages
  • 2.10.1 Defining a Login Message
    • 2.10.1.1 About Login Messages
    • 2.10.1.2 Creating a Login Message
    • 2.10.1.3 Editing or Removing a Login Message
  • 2.10.2 Defining a System Message
    • 2.10.2.1 About System Messages
    • 2.10.2.2 Creating and Editing a System Message
  • 2.10.3 Creating a Site-Specific Tasks List
    • 2.10.3.1 Adding a New Task
    • 2.10.3.2 Editing an Existing Task
    • 2.10.3.3 Deleting a Task
• 2.11 Managing Logs and Files
  • 2.11.1 Deleting SQL Workshop Logs
  • 2.11.2 Deleting Page View Activity Log Entries
    • 2.11.2.1 About Page View Activity Logs
    • 2.11.2.2 Truncating Page View Activity Logs Manually
  • 2.11.3 Deleting Developer Activity Log Entries
  • 2.11.4 Managing Developer Log Retention
  • 2.11.5 Deleting Click Counting Log Entries
  • 2.11.6 Deleting Web Service Log Entries
  • 2.11.7 Deleting the Login Access Log
  • 2.11.8 Managing Log Intervals
  • 2.11.9 Archiving the Activity Log
• 2.12 Creating a Service Signup Wizard
  • 2.12.1 Defining a Service Signup Wizard
  • 2.12.2 Running a New Service Signup Wizard
• 2.13 Managing Schemas
  • 2.13.1 What Is the Oracle Application Express Engine Schema?
  • 2.13.2 Determining the Oracle Application Express Engine Schema
  • 2.13.3 Understanding Oracle Default Schema Restrictions
    • 2.13.3.1 About Assigning Oracle Default Schemas to Workspaces
    • 2.13.3.2 Granting the Privilege to Assign Oracle Default Schemas
    • 2.13.3.3 Revoking the Privilege to Assign Oracle Default Schemas
    • 2.13.3.4 Working with Restricted Schemas
      • 2.13.3.4.1 Removing Workspace Exceptions for a Schema
      • 2.13.3.4.2 Removing Schema Exceptions for a Workspace
      • 2.13.3.4.3 Designating Specific Workspaces as Exceptions
    • 2.13.3.5 Determining the Privilege Status
• 2.14 Creating Workspaces
  • 2.14.1 About Workspaces
  • 2.14.2 About Specifying How Workspaces Are Created
  • 2.14.3 Selecting a Provisioning Mode
  • 2.14.4 How Oracle-Managed Files Effects Workspace Provisioning
  • 2.14.5 Creating a Workspace Manually
    • 2.14.5.1 Creating Workspace Manually in a Full Development Environment
    • 2.14.5.2 Creating a Workspace Manually in a Runtime Environment
  • 2.14.6 Creating Multiple Workspaces
• 2.15 Managing Existing Workspaces
  • 2.15.1 Viewing Existing Workspace Information
  • 2.15.2 Deleting a Workspace
    • 2.15.2.1 Identifying and Deleting Inactive Workspaces
      • 2.15.2.1.1 How to Identify Inactive Workspaces
      • 2.15.2.1.2 Identifying Inactive Workspaces By Checking Recent Updates
      • 2.15.2.1.3 Viewing Workspaces with Only a Sample Application
      • 2.15.2.1.4 Removing the Resources Associated with Inactive Workspaces
      • 2.15.2.1.5 Deleting Inactive Workspaces
    • 2.15.2.2 Deleting Workspaces in a Full Development Environment
    • 2.15.2.3 Deleting Workspaces in a Runtime Development Environment
  • 2.15.3 Locking a Workspace
  • 2.15.4 Managing Workspace to Schema Assignments
    • 2.15.4.1 Viewing Schema and Workspace Assignments in a Development Environment
    • 2.15.4.2 Viewing Schema and Workspace Assignments in a Runtime Environment
    • 2.15.4.3 Editing Existing Schema and Workspace Assignments
    • 2.15.4.4 Associating Schemas in a Full Development Environment
    • 2.15.4.5 Associating Additional Schemas in a Runtime Environment
    • 2.15.4.6 Removing a Schema Mapping from a Workspace in a Runtime Environment
  • 2.15.5 Managing Component Availability for an Instance
  • 2.15.6 Defining a Workspace Message in Administration Services
  • 2.15.7 Performing a Workspace Search
  • 2.15.8 Isolating a Workspace to Prevent Browser Attacks
    • 2.15.8.1 About Isolating a Workspace to Prevent Browser Attacks
    • 2.15.8.2 Configuring Workspace Isolation Attributes
  • 2.15.9 Viewing the Workspace Summary Report
  • 2.15.10 Viewing Workspace Database Privileges
  • 2.15.11 Viewing File Size and File Count by Workspace
  • 2.15.12 Finding and Emailing Workspace Summary
  • 2.15.13 Exporting and Importing a Workspace
    • 2.15.13.1 About Exporting and Importing a Workspace
    • 2.15.13.2 Importing a Workspace in Administration Services
    • 2.15.13.3 Exporting a Workspace in Administration Services
    • 2.15.13.4 Exporting Applications and Workspaces from a Command-line
      • 2.15.13.4.1 APEXExport Program
      • 2.15.13.4.2 APEXExportSplitter Program
    • 2.15.13.5 Viewing Application Attributes
  • 2.15.14 Changing Application Build Status in Administration Services
    • 2.15.14.1 About Changing Application Build Status
    • 2.15.14.2 Changing Build Status in Administration Services
  • 2.15.15 Viewing the Parsing Schemas Report
• 2.16 Managing Users Across an Application Express Instance
  • 2.16.1 About the Advantages of Managing Users at the Instance Level
  • 2.16.2 About Application Accounts Authentication
  • 2.16.3 About Application Express User Roles
  • 2.16.4 Creating New User Accounts in Administration Services
  • 2.16.5 Editing an Existing User Account in Administration Services
  • 2.16.6 Deleting User Accounts in Administration Services
• 2.17 Monitoring Activity Across a Development Instance
  • 2.17.1 Monitoring Activity
  • 2.17.2 Viewing the Signup Survey Report

A DBMS_SCHEDULER Jobs

• A.1 List of DBMS_SCHEDULER Jobs

Index