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"

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. See "Managing Workspace and Change 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 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. See "Defining a System Message."

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. 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 enabling self service workspace provisioning, configuring storage, and configuring support for email, wallets, and report printing. See "Using the Productivity and Sample Applications Repository."

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

• REST Administration Interface. Enable or disable REST Instance Administration Services.

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

• 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

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. 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 enabling self service workspace provisioning, 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 REST Instance Administration Services.

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 "Creating 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."

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

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

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

• 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

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. 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 Summary 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."

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

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

• Build Status. Dislays 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 Schemas. 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."