3.5 Utilizing Packaged App Administration

Administrators use Packaged App Administration to manage and monitor packaged apps in their workspace.

See Also:

"Workspace and Application Administration" in Oracle Application Express Administration Guide

3.5.1 Making a Service Request

Create a service request for additional storage or terminate a workspace.

Tip:

Only users with administrator rights can access this functionality.

To make a service request for more storage or to terminate service:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Make a Service Request.
  5. To identify the type of service you would like to request, select one of the following:
    • Request Storage

    • Request Termination

      Tip:

      To see the amount of free space available in a workspace, expand Tablespace Utilization and select Detailed Tablespace Utilization Report (may take several seconds).

  6. Follow the on-screen instructions.

3.5.2 Setting Workspace Preferences

Configure account login controls such as account expiration and locking, maximum login failures, and end user account lifetime (in days).

Tip:

Only users with administrator rights can access this functionality.

.

To set workspace preferences:

  1. Sign in to Oracle Application Express.

  2. Click Packaged Apps.

  3. Click Administration.

  4. Click Set Workspace Preferences.

  5. Under Account Login Control:

    Tip:

    To learn more about any attribute, see field-level Help.

    1. Account Expiration and Locking - Make a selection to determine whether Application Express end user accounts can be expired or locked. This feature applies only to end-user accounts created using the Application Express user management interface.

    2. Maximum Login Failures Allowed - Enter a positive integer for the maximum number of consecutive unsuccessful authentication attempts allowed before an end-user account is locked. If you do not specify a value in this field, the instance-level setting for Maximum Login Failures Allowed is used.

    3. End User Account Lifetime (days) - Enter a positive integer for the maximum number of days an end-user account password may be used before the account expires. If you do not specify a value in this field, the instance-level setting for Account Password Lifetime is used.

  6. Click Apply Changes.

3.5.3 Managing Users

Administrators in a Packaged Apps Only workspace can create new user accounts, manage existing user accounts, and change user passwords.

A Packaged Apps Only workspace enables developers to share packaged applications with other developers and administrators. It does not include any access to development tools such as App Builder or SQL Workshop. A Packaged Apps Only workspace includes the Packaged Apps page and the Packaged App Administration page.

Tip:

Only users with administrator rights can access this functionality. This option is only available in a Packaged Apps Only workspace, but not in full workspace.

To manage users in a Packaged Apps Only workspace:

  1. Sign in to the Packaged Apps Only workspace.
  2. Click Packaged App Administration.
  3. Click Manage Users.

    Managing users works the same in a Packaged Apps Only workspace as it does at the workspace-level.

3.5.4 Managing Saved Interactive Reports

View and delete saved interactive reports created by users of packaged apps.

To manage saved interactive reports:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Saved Reports.

    Managing saved interactive reports works the same in a Packaged Apps Only workspace as it does at the workspace-level.

See Also:

"Viewing and Deleting Saved Interactive Reports" in Oracle Application Express Administration Guide

3.5.5 Managing Interactive Report Subscriptions

View and manage interactive report subscriptions created by users of packaged apps.

To manage interactive report subscriptions:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Subscriptions.

    Managing interactive report subscriptions works the same in a Packaged Apps Only workspace as it does at the workspace-level.

See Also:

"Managing Interactive Report Subscriptions" in Oracle Application Express Administration Guide

3.5.6 Viewing Activity Reports

View a monthly calendar of packaged app activity that details users and total page views by day.

To view Packaged App Activity report:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Packaged App Activity.

    A monthly calendar of application activity appears.

3.5.7 Viewing Page Views

View a report of packaged app page views detailing the app, page, user, and elapsed time.

To view the Page View report:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Page Views.

3.5.8 Viewing Top Users

View a report of packaged app page views aggregated by user.

To view the Top Users report:

  1. Sign in to Oracle Application Express.
  2. Click Packaged Apps.
  3. Click Administration.
  4. Click Top Users.