3.1.3 Overview: Administration Services UI

Key pages in Administration Services include: Administration Services, Manage Instance, and Manage Workspaces.

• Administration Services Home Page
  The Administration Services 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 Administration Services 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 Requests"

• "Monitoring Activity Across a Development Instance"

3.1.3.1 Administration Services Home Page

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

Note:

To ensure the security and performance of your development environment, some Administration Services functionality is not available in Application Express instances running in Oracle Cloud.

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

• Manage Requests. Approve and decline workspace service requests and change requests. See "Managing Requests."

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

• 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. See "Manage Workspaces Page."

• Monitor Activity. View various reports on applications, developers, and session activity. See "Monitoring Activity Across a Development Instance."

Description of the illustration home_pg.png

System Message Region

The System Message region displays at the top of the page. Administrators can create a system message to communicate with other users within an instance. See "Defining a System Message."

Instance Tasks

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

• Jump to Workspace. Enter a workspace name to quickly access Edit Workspace Information page. See "Managing Existing Workspaces."

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

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

• Instance Settings. Manage settings that apply to an entire Oracle Application Express instance such as selecting the provisioning method for workspace creation, configuring storage, and configuring support for email, wallets, and report printing. See "Configuring Instance Settings."

• Workspace Purge Settings. Configure purge behavior for inactive workspaces. See "Purging Inactive Workspaces."

Workspace Tasks Region

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. See "Creating Workspaces in Administration Services."

  Note:

  You can also access the Create Workspace Wizard by clicking the Create Workspace button at the top of the page.

• Create Multiple Workspaces. Links to the Create Multiple Workspace Wizard. See "Creating Multiple Workspaces."

• Find a Workspace. Displays a searchable report of all workspaces. See "Performing a Workspace Search."

• Manage Workspaces. Links to the Manage Workspaces page. See "Managing Existing Workspaces."

• Create User. Enables you to create a new user. See "Creating New User Accounts in Administration Services."

• Find a User. Displays a searchable report of all users in the current instance. See "Managing Users Across an Application Express 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. See "Editing an Existing User Account in Administration Services."

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

3.1.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 Administration Services home page.

Instance Settings

Note:

To ensure the security and performance of your development environment, some Administration Services functionality is not available in Application Express instances running in Oracle Cloud.

Instance Settings contains the following links:

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

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

• Instance Settings. Manage settings that apply to an entire Oracle Application Express instance such as selecting the provisioning method for workspace creation, configuring storage, and configuring support for email, wallets, and report printing. See "Configuring Instance Settings."

• Workspace Purge Settings. Configure purge behavior for inactive workspaces. See "Purging Inactive Workspaces."

• REST Administration Interface. Enable or disable the REST Administration Interface, register REST Client applications, view REST client details, or remove a REST client. See "Using the REST Administration Interface."

Manage Shared Components

Manage Shared Components contains the following links:

• Productivity and Sample Applications. Manage productivity and sample applications available in an Oracle Application Express instance. See "Using the Productivity and Sample Applications Repository."

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

Manage Meta Data

Manage Meta Data contains the following links:

• Session State. Monitor and manage the session state repository. See "Managing Session State for an Instance."

• Mail Queue. Monitor the email messages in the mail queue. See "Managing the Mail Queue."

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

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

Messages

Messages contains the following links:

• Define Login Message. Enables an instance administrator to create and manage login message. See "Defining a Login Message."

• Define System Message. Enables an instance administrator to create and manage system message. See "Defining a 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. See "Managing a Site-Specific Tasks List."

Manage Logs and Files

Manage Logs and Files contains the following links:

• SQL Workshop Log. View SQL Workshop logs and delete log entries. See "Deleting SQL Workshop Logs."

• Page View Activity Log. View and delete User Activity log entries. See "Deleting Page View Activity Log Entries."

• Developer Activity Log. View and delete Developer Activity log entries. See "Deleting Developer Activity Log Entries."

• External Click Counting Log. View and delete External Click Counting log entries. See "Deleting Click Counting Log Entries."

• Login Access Log. View and delete Login Access log entries. See "Deleting the Login Access Log."

• Manage Log Interval. Set the minimum number of days to retain log information for log files. See "Managing Log Intervals."

• Archive Activity Log. Create an archive of Application Express Activity log. See "Archiving the Activity Log."

• Web Service Activity Log. Create an archive of Web Service activity.

• REST Source Synchronization Log. Configure when entries are purged or delete the REST Source Synchronization log. See "Configuring or Deleting the REST Source Synchronization Log."

• Automation Log. Configure when entries are purged or delete the Automation log. See "Configuring or Deleting the Automation 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. You can require users fill out a justification and accept an agreement and optionally respond to survey questions before the New Service Signup Wizard submits a request. See "Creating a Service Signup Wizard."

• Run New Service Signup Wizard. Run the New Service Signup Wizard. See "Running a New Service Signup Wizard."

3.1.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

Links displaying under Workspace Actions:

• Create Workspace. Create a new workspace using the Create Workspace wizard. See "Creating Workspaces in Administration Services."

• Create Multiple Workspaces. Create multiple workspaces using the Create Multiple Workspaces wizard. See "Creating Multiple Workspaces."

• Remove Workspace. Remove a workspace. See "Deleting 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. See "Locking a Workspace."

• 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. See "Managing Workspace to Schema Assignments."

• 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. See "Managing Users Across an Application Express Instance."

• 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. See "Managing Component Availability for an Instance."

Workspace Reports

Links displaying under Workspace Reports:

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

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

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

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

• 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. See "Viewing File Size and File Count by Workspace."

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

• Data Dictionary Cache. View the Data Dictionary Cache report to manually refresh the Data Dictionary Cache. Wizards use this information when creating new applications and pages. See "Viewing or Refreshing the Data Dictionary Cache."

Export Import

Links displaying under Export Import:

• Import Workspaces. Links to the Import Workspace Wizard. Use this wizard to import a workspace into the export repository. See "Importing a Workspace in Administration Services."

• Export Workspaces. Links to the Export Workspace page. Use this page to select a workspace and access the Export Workspace Wizard. See "Exporting a Workspace in Administration Services."

Manage Applications

Links displaying under Manage Applications:

• 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. See "Viewing the Application Attributes Report."

• Build Status. Displays the Build Status report. Use this report to review and change the Build Status attribute of any application in any workspace. See "Changing Application Build Status in Administration Services."

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