Note:
Functionality in the Administration Services application is not available in Oracle Database Cloud Service (Database Schema).This section describes how an Instance administrator manages workspace requests and change requests.
An Instance administrator is responsible for reviewing and managing workspace requests and change requests.
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).
To view new and pending service requests on the Instance Administration home page:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
The Pending Requests region lists the total number of new service requests and service change requests.
To view a more detailed report, click the Service Change number.
The All Change Requests report displays. This report lists all service requests by date.
To view a specific request, click View Request.
Tip:
To view the new Service Requests report page, see "Monitoring Activity Across a Development Instance"To view pending service requests from the Manage Service Requests page:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
The Manage Service Requests page has three tabs:
Open Requests
All Workspace Requests
All Change Requests
Tip:
All Change Requests pages display as interactive reports. You can customize the appearance of each page using the Search bar at the top of each page.Open Requests displays new service requests and change requests.
To approve or decline a new request, click the Edit icon to the left of the request description.
Click the All Workspace Requests tab.
All Workspace Requests lists requests by workspace name, schema, size, and request date.
To edit the request, click the Edit icon. To approve or decline the request, click Provision in the Action column.
Click All Change Requests.
All Change Requests lists requests by workspace name, request change description, requestor, and status.
To view a request, click View Request. The View Change Request page appears. To approve the request, click Add Space. To decline the request, click Deny Request.
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.
See Also:
"About Workspace Requests and Change Requests" and "About Specifying How Workspaces Are Created"If you are using Email Verification, when an Instance administrator approves a workspace request, the following events occur:
An email containing a verification link is sent to the user.
When user clicks the verification link, the workspace is created.
Another email is sent to the user containing login credentials (that is, the workspace name, username, and password).
The status of the workspace request changes from Accepted to Approved.
If the user fails to click the verification link, you can quickly delete the request by clicking the DELETE link in the Action column.
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.
To approve or decline a pending workspace request:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
Click the All Workspace Requests tab.
The Workspace Requests page displays as an interactive report. To customize the report, use the Search bar at the top of the page.
To approve a request:
Click Provision in the Actions column.
On the Provisioning Administration page, click Approve.
Review the email message.
If needed, update the message and click Approve and Send Email.
If you selected 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."
To decline a request:
Click Provision in the Actions column.
On the Provisioning Administration page, click Decline.
Review the email message.
To add information, such as the reason for declining a request, update the message and then click Decline and Send Email.
The email is sent to the user notifying them the request was declined.
To change the status of an existing workspace request:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
Click the All Workspace Requests tab.
The Workspace Requests page displays as an interactive report. To customize the report, use the Search bar at the top of the page.
To review all workspace requests, deselect the filter Status_Code = '1'.
Locate a request to review.
Click the Adjust link in the Actions column.
The Adjust Request page appears.
From the Project Status list, select a new status.
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.To delete a workspace request:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
Click All Workspace Requests.
The Open Requests page appears.
Click the Edit icon adjacent to the request to be deleted.
On the Provision Request page, click 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.
Click Delete Request.
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.
To view all change request:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
Under Manage Requests, click the All Change Requests tab.
This page displays as an interactive report. To customize the report, use the Search bar at the top of the page.
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.
Approve or deny the change request. See "Approving or Declining a Pending Change Request."
To approve or decline a pending change request:
Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."
Click Manage Requests.
Under Manage Requests, click the All Change Requests tab.
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.
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.