2.3 Overview of Oracle Application Express Administration Services

Key pages in the Oracle Application Express Administration Services application include: Instance Administration home, Manage Instance, and Manage Workspaces.

  • Instance Administration Home Page
    The Instance Administration home page is the starting point for managing an entire Oracle Application Express instance.
  • Manage Instance Page
    Instance administrators use the Manage Instance page to control and configure key features of an Oracle Application Express instance. Many of these links also display on the Instance Administration home page.
  • Manage Workspaces Page
    Instance administrators use the Manage Workspaces page to manage workspaces for an Oracle Application Express instance. A workspace is a shared work area where multiple developers can create applications. Each workspace has the privilege to parse as one or more database schemas.

See Also:

"Managing Workspace and Change Requests" and "Monitoring Activity Across a Development Instance"

2.3.1 Instance Administration Home Page

The Instance Administration home page is the starting point for managing an entire Oracle Application Express instance.

The top of the Instance Administration home page features four icons:

  • Manage Requests. Approve and decline workspace service requests and change requests.

  • Manage Instance. Control and configure key features of the Oracle Application Express instance.

  • Manage Workspaces. Create, remove and lock workspaces, manage workspace schema assignments, manage developers and users, view workspace reports, import and export workspaces, and manage application behaviors.

  • Monitor Activity. View various reports on applications, developers, and session activity.

Description of GUID-42B527B5-3344-4AF2-B354-A64A3B8D7C2C-default.png follows
Description of the illustration GUID-42B527B5-3344-4AF2-B354-A64A3B8D7C2C-default.png

System Message Region

The System Message region displays in the center of the page. Instance administrators can use this region to communicate with other users in the workspace. To add a system message, click the Edit System Message icon.

Instance Tasks Region

The Instance Tasks region displays on the right side of the page and features the following links:

  • Feature Configuration. Manage configuration settings that apply to an entire Oracle Application Express instance.

  • Security. Manage security settings that apply to an entire Oracle Application Express instance.

  • Instance Settings. Manage settings that apply to an entire Oracle Application Express instance such as enabling self service workspace provisioning, configuring storage, and configuring support for email, wallets, and report printing.

  • Workspace Purge Settings. Configure purge behavior for inactive workspaces.

Workspace Tasks Region

Use the Workspace Tasks region also displays on the right side of the page and features the following links:

  • Create Workspace. Links to the Create Workspace Wizard.

  • Create Multiple Workspaces. Links to the Create Multiple Workspace Wizard.

  • Find a Workspace. Displays a searchable report of all workspaces.

  • Manage Workspaces. Links to the Manage Workspaces page.

  • Create User. Enables you to create a new user.

  • Find a User. Displays a searchable report of all users in the current instance.

  • Reset User Password. Links to the Manage Developer and Users page. To reset a user, click the user, edit the attributes under Password, and click Apply Changes.

Available Updates

The Available Updates region indicates if updates are available for Oracle Application Express and the Oracle REST Data Services. If your installation is current the following message displays:

System is up-to-date

To configure updates, click Set Preferences for Available Updates icon which resembles a gear. The Available Updates dialog appears. You can enable or disable updates by selecting Yes or No from Check for Available Updates. To learn more, see field-level Help.

Tip:

To perform this check Application Express transmits the version number of Oracle Application Express and other system components to Oracle Corporation. To continuously improve our products, Oracle is interested in learning about product usage. To that end, statistics can occasionally be sent to Oracle describing the product features in use. No personally identifiable information is sent. To review Oracle's privacy policy, see:

http://www.oracle.com/us/legal/privacy/overview/index.html

Accessibility Mode

Use the Accessibility Mode list to select the accessibility mode for the current Oracle Application Express instance. Options include:

  • Standard

  • Screen Reader - Optimizes the Oracle Application Express development environment, Websheet runtime, and database applications for screen readers.

See Also:

"Using Screen Reader Mode in Your Database Applications" and "Using High Contrast Mode in Your Database Applications" in Oracle Application Express App Builder User’s Guide

2.3.2 Manage Instance Page

Instance administrators use the Manage Instance page to control and configure key features of an Oracle Application Express instance. Many of these links also display on the Instance Administration home page.

Instance Settings

Instance Settings contains the following links:

  • Feature Configuration. Manage configuration settings that apply to an entire Oracle Application Express instance.

  • Security. Manage security settings that apply to an entire Oracle Application Express instance.

  • Instance Settings. Manage settings that apply to an entire Oracle Application Express instance such as enabling self service workspace provisioning, configuring storage, and configuring support for email, wallets, and report printing.

  • Workspace Purge Settings. Configure purge behavior for inactive workspaces.

Manage Shared Components

Manage Shared Components contains the following links:

  • Packaged Applications. Manage packaged application available in an Oracle Application Express instance.

  • Public Themes. Create and manage public themes for an instance.

Manage Meta Data

Manage Meta Data contains the following links:

  • Session State. Monitor and manage the session state repository.

  • Mail Queue. Monitor the email messages in the mail queue.

  • Installed Translations. Links to the Installed Translation report which indicates which translations have been loaded for the Oracle Application Express instance.

  • Interactive Report Subscriptions.  View and manage subscriptions created by end users using interactive reports in the instance.

Messages

Messages contains the following links:

  • Define Login Message. Enables an instance administrator to create and manage login message.

  • Define System Message. Enables an instance administrator to create and manage system message.

  • Manage Site-Specific Tasks. Create and manage a Site-Specific Tasks lists. These links display on the Workspace home page and on the Workspace Login page.

Manage Logs and Files

Manage Logs and Files contains the following links:

  • SQL Workshop Log. View SQL Workshop logs and delete log entries.

  • Page View Activity Log. View and delete User Activity log entries.

  • Developer Activity Log. View and delete Developer Activity log entries.

  • External Click Counting Log. View and delete External Click Counting log entries.

  • Login Access Log. View and delete Login Access log entries.

  • Archive Activity Log. Create an archive of Application Express Activity log.

Self Service Sign Up

Self Service Sign Up contains the following links:

  • Manage New Service Signup Wizard. Create and manage the New Service Signup Wizard. This wizard requires users fill out a justification and accept an agreement submits a workspace request.

  • Run New Service Signup Wizard. Run the New Service Signup Wizard.

2.3.3 Manage Workspaces Page

Instance administrators use the Manage Workspaces page to manage workspaces for an Oracle Application Express instance. A workspace is a shared work area where multiple developers can create applications. Each workspace has the privilege to parse as one or more database schemas.

Workspace Actions

Manage Workspaces contains the following links:

  • Create Workspace. Create a new workspace using the Create Workspace wizard.

  • Create Multiple Workspaces. Create multiple workspaces using the Create Multiple Workspaces wizard.

  • Remove Workspace. Remove a workspace.

  • Lock Workspace. Lock a workspace. Locking a workspace disables all workspace administrator, developer, and user accounts in the workspace and makes all applications unavailable.

  • Manage Workspace to Schema Assignments. View a report that lists the schemas in which a given workspace can build. When developers create new applications they must choose a schema from the list of schemas assigned to the workspace.

  • Manage Developers and Users. To access the Oracle Application Express development environment, users sign in to a shared work area called a workspace. Use the Manage Developers and Users page to create, edit, and delete users.

  • Manage Component Availability. View a report of Workspace Settings by workspace. To override the current settings, click the workspace name and edit the setting on the Workspace Settings page.

Workspace Reports

Use Workspace Reports to access the following links:

  • Existing Workspaces. View a report of provisioned workspaces. Click the workspace name for a details of a specific workspace. Click Delete in the action column to start the Remove Workspace Wizard.

  • Workspace Details. Select a workspace and click Edit, Schema Assignments, and Manage Users to view key attributes about the workspace.

  • Workspace Database Privileges. View a report of workspace database privilege details. To edit a workspace, click the workspace name.

  • Workspaces with Only Sample Application. View a report of workspaces containing only Sample Database Application. Use this report to gauge workspace activity.

  • Manage File Utilization. View the File Utilization by Workspace report. This report lists the workspace name, total file size, file counts, and the relative age of the newest and oldest files. Use this report to gauge workspace activity.

  • Find and Email Workspace Summary. View the Workspace Search report. Click the workspace name to view workspace details and email the report.

Export Import

Use Export Import to access the following links:

  • Import Workspaces. Links to the Import Workspace Wizard. Use this wizard to import a workspace into the export repository.

  • Export Workspaces. Links to the Export Workspace page. Use this page to select a workspace and access the Export Workspace Wizard.

Manage Applications

Use Manage Applications to access the following links:

  • Application Attributes. Links to the Application Attributes page key application attributes including the workspace name and ID, application ID, parsing schema, number of application pages, logging status, build status, application status, and application alias.

  • Build Status. Dislays the Build Status report. Use this report to review and change the Build Status attribute of any application in any workspace.

  • Parsing Schemas. Displays the Parsing Schema report. Use this report to identify the current parsing schema of each application in any workspace.