2.4 Managing Workspace and Change Requests

Approve and decline workspace service requests and change requests on the Manage Request page.

2.4.1 About Workspace Requests and Change Requests

Instance administrators are responsible for approving or declining service requests made by workspace administrators.

Service requests fall into one of two categories. A Workspace Request enables users to request workspaces directly in a self-service fashion. For example, users could click a link on the login page to access a request form. Once the Instance administrator approves the workspace request, each user is automatically emailed the appropriate login information. To use workspace requests, an Instance administrator must select the Self Service Provisioning Status, Request on the Instance Settings page.

A Change Request enables users to modify an existing workspace (for example, add a new schema or increase the disk space limit).

2.4.2 Viewing Requests on the Instance Administration Home Page

View a summary of pending new service and change requests on the Instance Administration home page. The total number of pending requests displays in the Pending Requests region.

To view a summary of new service and change requests on the Instance Administration home page:

  1. Sign in to Oracle Application Express Administration Services.

    The Pending Requests region lists the total number of new service requests and service change requests.

  2. To view pending new service requests, click the New Service number.

    The All Workspace Requests report appears listing the workspace name, schema, size, request date, and status.

    • To approve or decline the request, click Provision in the Action column.
    • To edit the provisioning request, click the Workspace name.
  3. To view pending change requests, click the Service Change number.

    The All Change Requests report displays.

    • To view a pending change requests, click View Request.
    • Approve and deny the request as is appropriate.

2.4.3 Viewing Pending Requests

View pending service requests on the Manage Requests page.

To view pending service requests from the Manage Service Requests page:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Requests.

    The Manage Service Requests page appears and has three tabs:

    • Open Requests displays all pending service requests and change requests.

    • All Workspace Requests displays pending workspace requests.

    • All Change Requests displays pending change requests.

  3. Click Open Requests to view a pending new service requests and change requests.
    • To approve or decline a new request, click the Edit icon to the left of the request description.
    • Approve and deny the request as is appropriate.
  4. Click All Workspace Requests to view a pending workspace requests..

    The All Workspace Requests report appears listing the workspace name, schema, size, request date, and status.

    • To approve or decline the request, click Provision in the Action column.
    • To edit the provisioning request, click the Workspace name.
  5. Click All Change Requests to view pending changes to existing services.

    All Change Requests report appears listing the workspace name, request change description, requestor, and status.

    To approve the request, click Add Space. To decline the request, click Deny Request.

    • To view a request, click View Request. The View Change Request page appears.
    • Approve and deny the request as is appropriate.

2.4.4 Managing Workspace Requests

A Workspace Request enables a user to request a workspace by clicking a link on the login page to access a request form. Once submitted, the Instance administrator can review the request and either approve or decline it.

2.4.4.1 About the Workspace Request Approval Process

The Instance administrator determines how workspace request process works depends on the defined Provisioning Status.

To determine how provisioning works, an Instance Administrator selects one of the following Provisioning Status options on the Instance Settings page:

  • Manual - An Instance administrator creates new workspaces and notifies the Workspace administrator of the login information.

  • Request - Users request workspaces directly in a self-service fashion. Users click a link on the login page to access a request form. After the workspace request has been granted, users are automatically emailed the appropriate login information.

  • Request with Email Verification - In this mode, users request workspaces directly by clicking a link on the Sign In page to access a request form. Each user receives an initial email containing a verification link. When the user clicks the verification link, the request is processed. The user can then access the workspace using the Sign In page.

To enable users to request a workspace using a link on the Sign In page, the Instance administrator must choose the provisioning status of Request or Request with Email Verification . If the provisioning status is set to Manual, no link appears on the sign in page.

About Request with Email Verification

If your workspace uses the Provisioning Status Request with Email Verification when an Instance administrator approves a workspace request, the following events occur:

  1. An email containing a verification link is sent to the user.

  2. When user clicks the verification link, the workspace is created.

  3. Another email is sent to the user containing login credentials (that is, the workspace name, username, and password).

  4. The status of the workspace request changes from Accepted to Approved.

What Happens When an Error Occurs?

If an error occurs during the workspace creation process, the status of the request reverts to Requested and an email is sent to the user containing the following message:

Please contact administrator.

Once the issue is resolved, the administrator can again repeat the previous procedure and approve the request.

2.4.4.2 Approving or Declining a Pending Workspace Request

Approve or decline pending workspace requests on the All Workspace Requests page.

To approve or decline a pending workspace request:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Requests.
  3. Click the All Workspace Requests tab.

    The All Workspace Requests report appears listing the workspace name, schema, size, request date, and status.

  4. To approve a request:
    1. Click Provision in the Actions column.
    2. On the Provisioning Administration page, click Approve.
    3. Review the email message.
    4. If needed, update the message and click Approve and Send Email.
  5. To decline a request:
    1. Click Provision in the Actions column.
    2. On the Provisioning Administration page, click Decline.
    3. Review the email message.
    4. If needed, update the message, for example to add the reason for declining a request, and click Decline and Send Email.

      The email is sent to the user notifying them the request was declined.

    Tip:

    If the instance has the Provisioning Status, Email Verification, an email containing a verification link is sent to the user. To create the workspace, the user must click the verification link to create the workspace. See "About Specifying How Workspaces Are Created."

2.4.4.3 Changing the Status of an Existing Workspace Request

Change the status of an existing workspace request on the All Workspace Requests page.

To change the status of an existing workspace request:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Requests.
  3. Click the All Workspace Requests tab.

    The All Workspace Requests report appears listing the workspace name, schema, size, request date, and status.

  4. To review all workspace requests, deselect the filter Status_Code = '1'.
  5. Locate a request to review.
  6. Click Adjust in the Actions column.

    The Adjust Request page appears.

  7. From the Project Status list, select a new status.
  8. Click Apply Changes.

Note:

Be careful when setting the Project Status to Requested. Although Requested enables you to provision a workspace, it could result in data corruption due to the manner in which accounts are provisioned. The provisioning system assumes Requested workspace requests do not have the corresponding schemas and dictionary entries for a Workspace administrator or developers. If you must change the Project Status for an Approved workspace to Requested, terminate the service first and then change the status to Requested.

2.4.4.4 Deleting a Workspace Request

Delete workspace requests on the All Workspace Requests page.

To delete a workspace request:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Requests.
  3. Click the All Workspace Requests tab.

    The All Workspace Requests report appears listing the workspace name, schema, size, request date, and status.

  4. Click the workspace name.
  5. On the Edit Provisioning Request page, select the appropriate button:
    • If the Project Status is Approved, click Terminate or Delete.

    • If the Project Status is Declined, Requested, Terminated, or Accepted, click Delete.

  6. Click Delete Request.

2.4.5 Managing Change Requests

A Change Request enables users to modify an existing workspace (for example, by adding a new schema or increasing the available disk space). Once submitted, the Instance administrator reviews and either approves or declines the change request

2.4.5.1 Approving or Declining a Pending Change Request

Approve or decline pending change requests on the All Workspace Requests page.

To approve or decline a pending change request:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Requests.
  3. Click the All Change Requests tab.
  4. Locate the request and click View Request under the Action column.

    The View Change Request page appears. Note that the buttons that display depend upon the nature of the change request.

  5. To approve the request, click one of the following:
    • Create Schema - Approves a schema request.

    • Deny Request - Denies the current change request.

    • Add Space - Approves a request for additional disk space.

    • Terminate Service - Approves a request to terminate the service.