Go to main content
1/43
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release
Changes in Oracle Application Express Release 18.1
Deprecated and Desupported Features
Other Changes
1
Workspace and Application Administration
Understanding Workspace Administration
What is a Workspace Administrator?
Accessing the Workspace Administration Page
Workspace Administration Page
Resetting Your Password
Viewing Product Release and Environment Information
Managing Exported Files
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
Removing and Validating Websheet Database Objects
Requesting a New Workspace Manually
Monitoring Activity Within a Workspace
Accessing the Monitor Activity Page
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
Using the Manage Service Page
Accessing the Manage Service Page
Manage Service Page
Making a Service Request
Requesting a New Schema
Requesting More Storage
Terminating a Workspace
Determining the Amount of Space Available in Your Workspace
Viewing the Detailed Tablespace Utilization Report
Signing Up for Another Workspace
Configuring Workspace Preferences
Creating Account Login Controls for a Workspace
About Login Controls
Configuring Workspace Account Login Controls
Controlling Access to App Builder
Controlling Access to SQL Workshop
Disabling PL/SQL Program Unit Editing for a Workspace
Enabling RESTful Services for a Workspace
Managing Team Development
Enabling Team Development for a Workspace
Enabling Workspace-level Support for File Upload in Team Development
Defining a Workspace Message
About Workspace Messages
Creating and Editing a Workspace Message
Managing Users in a Workspace
About Application Accounts Authentication
About Application Express 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 Application Express 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
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?
Managing Build Status in Workspace Administration
Viewing Workspace Dashboards
Accessing the Workspace Dashboards
Workspace Dashboard
Users Dashboard
Activity Dashboard
Developer Activity Dashboard
Performance Dashboard
Websheets Dashboard
Applications Dashboard
Database Dashboard
Leveraging
App Builder
Defaults
About
App Builder
Defaults
Configuring
App Builder
Defaults
2
Oracle Application Express Administration Services
What Is an Instance Administrator?
Signing In To Oracle Application Express Administration Services
Overview of Oracle Application Express Administration Services
Instance Administration Home Page
Manage Instance Page
Manage Workspaces Page
Managing Workspace and Change Requests
About Workspace Requests and Change Requests
Viewing Requests on the Instance Administration 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 Instance Settings
Managing Feature Configuration
Disabling PL/SQL Program Unit Editing for an Instance
Enabling the Creation of Demonstration Objects in New Workspaces
Enabling the Creation of Websheet Objects in New Workspaces
Enabling and Disabling SQL Access in Websheets
Configuring Packaged Application Installation Options
Configuring SQL Workshop
Enabling Database Monitoring
Enabling Application Activity Logging
Enabling Web Service Activity Logging
Enabling Application Tracing
Enabling REST for an Instance
Enabling Service Requests
Enabling Instance-level Support for File Upload in Team Development
Configuring Security
Configuring Service-level Security Settings
Controling If Cookies Populate the Login Form
Disabling Access to Oracle Application Express Administration Services
Enabling Access to Oracle Application Express Administration Services
Disabling Workspace Login Access
Controlling Public File Upload
Restricting User Access by IP Address
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
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 Security for Developer and End User Login
Configuring Security Settings for Workspace Administrator and Developer Accounts
Editing Development Environment Authentication Scheme
Creating Strong Password Policies
About Strong Password Policies
Configuring Password Policies
Restricting Access to Oracle Application Express by Database Access Descriptor (DAD)
About Enforcing Access Restrictions Per DAD
About Changing and Recompiling wwv_flow_epg_include_local
Specifying Allowed Named Procedures
Altering the Product Schema
Managing Authorized URLs
Defining a List of Authorized URLs
Editing a Defined Authorized URL
Deleting Defined Authorized URL
Configuring Instance Settings
About Configuring Self Service Workspace Provisioning
Disabling Email Provisioning
Configuring Storage
Requiring a New Schema
Enabling Auto Extend Tablespaces
Enabling Bigfile Tablespaces
Enabling Encrypted Tablespaces
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
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
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 the Help Menu
Configuring Workspace Size Options for Requests
Managing Application ID Range
Purging Inactive Workspaces
Configuring Workspace Purge Settings
Using the REST Administration Interface to View Usage Statistics
About the REST Administration Interface
Enabling the REST Administration Interface
Registering REST Client Applications
Viewing REST Client Details
Removing a REST Client
Disabling the REST Administration Interface
Managing Custom Applications, Packaged Applications, and Public Themes
Managing Custom Applications
About Making Custom Applications Available to Users
Accessing the Packaged Applications Repository
Uploading a Custom Application to the Packaged Applications Repository
Editing Custom Application Details
Deleting a Custom Application
Managing Public Themes
Adding a Public Theme to the Theme Repository
Deleting a Public Theme
Modifying a Public Theme
About Exporting a Public Theme
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
Sending and Deleting Messages in the Mail Queue
Viewing Installed Translations
Deleting Interactive Report Subscriptions
Installing Exported Applications in a Runtime Environment
About the Advantages of Using Runtime Environment
Installing an Exported Application in to a Runtime Environment
Managing Messages
Defining a Login Message
About Login Messages
Creating a Login Message
Editing or Removing a Login Message
Defining a System Message
About System Messages
Creating and Editing a System Message
Creating a Site-Specific Tasks List
Adding a New Task
Editing an Existing Task
Deleting a Task
Managing Logs and Files
Deleting SQL Workshop Logs
Deleting Page View Activity Log Entries
About Page View Activity Logs
Truncating Page View Activity Logs Manually
Deleting Developer Activity Log Entries
Managing Developer Log Retention
Deleting Click Counting Log Entries
Deleting Web Service Log Entries
Deleting the Login Access Log
Managing Log Intervals
Archiving the Activity Log
Including an Agreement or Survey When Running the Signup Wizard
Defining an Agreement
Defining a Signup Survey
Running a New Service Signup Wizard
Managing Schemas
What Is the Oracle Application Express Engine Schema?
Determining the Oracle Application Express 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
About Workspaces
About Specifying How Workspaces Are Created
Selecting a Provisioning Mode
How Oracle-Managed Files Effects 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
Viewing Existing Workspace Information
Deleting a Workspace
Identifying and Deleting Inactive Workspaces
How to Identify Inactive Workspaces
Identifying Inactive Workspaces By Checking Recent Updates
Viewing Workspaces with Only a Sample Application
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
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
Defining a Workspace Message in Administration Services
Performing a Workspace Search
Isolating a Workspace to Prevent Browser Attacks
About Isolating a Workspace to Prevent Browser Attacks
Configuring Workspace Isolation Attributes
Viewing the Workspace Summary Report
Viewing Workspace Database Privileges
Viewing File Size and File Count by Workspace
Finding and Emailing Workspace Summary
Exporting and Importing a Workspace
About Exporting and Importing a Workspace
Importing a Workspace in Administration Services
Exporting a Workspace in Administration Services
Exporting Applications and Workspaces from a Command-line
APEXExport Program
APEXExportSplitter Program
Viewing Application Attributes
Changing Application Build Status in Administration Services
About Changing Application Build Status
Changing Build Status in Administration Services
Viewing the Parsing Schemas Report
Managing Users Across an Application Express Instance
About the Advantages of Managing Users at the Instance Level
About Application Accounts Authentication
About Application Express 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 a Development Instance
Monitoring Activity
Viewing the Signup Survey Report
A
DBMS_SCHEDULER Jobs
List of DBMS_SCHEDULER Jobs
Index
Scripting on this page enhances content navigation, but does not change the content in any way.