The Oracle Applications Manager console helps you easily maintain the Workflow database tables. Oracle Workflow accesses several tables that can grow quite large with obsolete workflow information that is stored for all completed workflow processes. The size of these tables and indexes can adversely affect performance. These tables should be purged on a regular basis, using the Purge Obsolete Workflow Runtime Data concurrent program.
The Workflow Purge page shows summary information about the next scheduled and last completed purge requests and about completed work items.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Purge
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Related Metrics > Completed Work Items
To view work items with a different status, choose the status you want from the View pull-down menu and click the Go button. You can view items with the following statuses:
Completed Work Items
This region displays summary information about the next scheduled and last completed Purge Obsolete Workflow Runtime Data concurrent requests.
To show information in this region if it is hidden, click the Show link.
To hide information in this region if it is shown, click the Hide link.
For the next scheduled Purge Obsolete Workflow Runtime Data concurrent request, Oracle Workflow Manager displays the request ID, requestor, status, requested start time, wait time, and parameters.
To view detail information for Purge Obsolete Workflow Runtime Data concurrent requests, click the View Purge Requests link.
For the last completed Purge Obsolete Workflow Runtime Data concurrent request, Oracle Workflow Manager displays the request ID, requestor, status, completed time, duration, and parameters.
To view the log file for the request, click the Request Log link.
This region displays the distribution of completed work items across different item types.
To show information in this region if it is hidden, click the Show link
To hide information in this region if it is shown, click the Hide link.
For each work item type in the Completed Work Items list, Oracle Workflow Manager displays the work item type name, the persistence type, the retention period in days, the number of completed work items of that type, and the number of items of that type that are available for purging. Click any column heading to sort the list by that column.
To filter the item types displayed in the list, select an item type property and an operator from the Filter By pull-down menus, enter a filter value in the text field, and click the Go button. You can filter by the following properties:
Work item type display name
Work item type internal name
Persistence type
Retention period
Number of completed work items of this type
Number of items of this type available for purging
To view details for work items of a particular item type, either click the item type link in the Work Item Type column, or select the item type and click the View Details button.
You perform purging by submitting the Purge Obsolete Workflow Runtime Data concurrent program (FNDWFPR). You can enter restrictions to specify the data that you want to purge.
To submit a request for the Purge Obsolete Workflow Runtime Data concurrent program through Oracle Self-Service Web Applications, either click the Purge button in the Completed Work Items region of the Workflow Purge page, or choose Purge from the Submit Request For pull-down menu in the Workflow System Status page and click the Go button.
To view Purge Obsolete Workflow Runtime Data concurrent requests, either click the View Purge Requests link in the Summary region of the Workflow Purge page, or click the View Purge Requests button in the Completed Work Items region of the Workflow Purge page.
When you submit the Purge Obsolete Workflow Runtime Data concurrent program, specify the following parameters.
Specify the item type to purge. Leave this field blank to purge the runtime data for all item types.
Specify the item key to purge. The item key is a unique identifier for an item within an item type. Leave this field blank to purge the runtime data for all items of the specified item type.
Specify the minimum age of data to purge, in days, if you are purging items with a Temporary persistence type. The default is 0 days.
Specify the persistence type of the data you want to purge, either Permanent or Temporary. The default is Temporary.
When you view the Purge Obsolete Workflow Runtime Data concurrent requests, the Search Results page shows standard request detail information for these requests. For each request, the list displays the request ID, program short name, description, application short name, phase, status, requestor, duration, and wait time. Click a column heading to sort the list by that column.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Purge > (B) View Purge Requests
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Related Metrics > Completed Work Items > (B) View Purge Requests
To show the details for a request if they are hidden, click the Show link in the Details column. Oracle Applications Manager displays details about the request depending on the status of the request. You can also perform actions, such as placing a hold on a request, canceling a request, viewing diagnostic information, viewing manager details, viewing logs, or viewing request output, by clicking the corresponding button. The actions that are available depend on the status of the request.
To hide the details for a request if they are shown, click the Hide link in the Details column.
To search for concurrent requests with different criteria, click the New Search button.
To modify the search criteria from this search, click the Modify Search button.
This page shows details about completed work items of a particular item type.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Purge > (B) View Details
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Related Metrics > Completed Work Items > (B) View Details
To view work items with a different status, choose the status you want from the View pull-down menu and click the Go button. You can view items with the following statuses:
Completed Work Items
This region displays the distribution of completed work items that ended at various activity stages within the workflow process. For each activity stage, the list displays the activity internal name and result, and the number of completed work items that ended at that stage. Click any column heading to sort the list by that column.
By default, the list shows completed work items that ended within the last 30 days. To view completed work items that ended within a different period, enter a number of days in the Filter Results By End Date Within Last _ Days option and click the Go button.
To view details about the work items that ended at a particular activity stage, either click the activity stage link in the Work Item Activity Stage column, or select the activity stage and click the View Details button.
This page shows details about completed work items that ended at a particular activity stage within a particular item type.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Purge > (B) View Details > (B) View Details
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Related Metrics > Completed Work Items > (B) View Details > (B) View Details
To view work items with a different status, choose the status you want from the View pull-down menu and click the Go button. You can view items with the following statuses:
Completed Work Items
Oracle Workflow Manager displays a list of all completed work items of the selected item type that ended at the selected activity stage. By default, the list shows completed work items that ended within the last 30 days. For each work item, the list displays the internal name of the activity at which the work item ended, the activity start date, end date, user assigned to perform the activity, and item key. Click any column heading to sort the list by that column.
Oracle Workflow Manager displays a list of all deferred activities of the selected stage for work items of the selected item type. By default, the list shows deferred work items that started within the last 30 days. For each activity, the list displays the activity internal name, start date, due date, user assigned to perform the activity, and item key of the work item. Click any column heading to sort the list by that column.
To filter the work items displayed in the list, select an activity property from the Filter Results By pull-down menu, enter a filter value in the text field, and click the Go button. You can filter by the following properties:
Internal name of the activity at which the work item ended
Start date within a specified number of days
End date within a specified number of days
User assigned to perform the activity
Item key of the work item
To launch the Workflow Monitor for a work item, select the work item and click the Launch Workflow Monitor button.
Note: If you perform an action in the Workflow Monitor that changes the status of the work item, then you must refresh your Oracle Workflow Manager web page in order to see the updated information.