Oracle Workflow Manager is a component of Oracle Applications Manager that allows system administrators to manage Oracle Workflow for multiple Oracle Applications instances from a single console.
Using Oracle Workflow Manager, administrators can control Workflow system services, such as background engines, the Notification Mailer, agent listeners, queue propagation, and purging obsolete Workflow data. Administrators can also monitor work item processing by viewing the distribution of all work items by status and drilling down to additional information. Additionally, they can monitor event message processing for local Business Event System agents by viewing the distribution of event messages by status and drilling down to additional agent information. With this ability to monitor work items and event messages, a system administrator can identify possible bottlenecks easily.
To access Oracle Workflow Manager, log into Oracle Applications Manager and select an applications system. Then, you can follow one of the following navigation paths:
Choose Workflow Manager from the pull-down menu in the Applications Dashboard page and click the Go button.
Click the Sitemap tab, and then click the Workflow Manager link in the Integrated Applications region of the Sitemap page.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go
The Workflow System Status page provides a high-level view of the status of your Oracle Workflow instance.
Oracle Workflow Manager shows the status of the following Workflow processes:
For each kind of process, Oracle Workflow Manager displays the process name, the process type, an overall status, and the current number of processes of that kind.
To view details for a process, either click the process link in the Process column, or select the process and click the View Details button.
To submit a concurrent request through Oracle Self-Service Web Applications for a process that is a concurrent program, choose the process you want from the Submit Request For pull-down menu and click the Go button. You can submit requests for the following processes:
Background Engine
Agent Listener
Purge
This region displays information about database initialization parameters required for Oracle Workflow.
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 parameter, the list shows the parameter name, actual parameter value, recommended value, and description. If the actual value is less than the recommended value, the parameter information is shown in red, and the description is marked with an asterisk (*). The following parameters are shown:
JOB_QUEUE_PROCESSES - This parameter defines the number of SNP job queue processes for your instance. Oracle Workflow requires job queue processes to handle propagation of Business Event System event messages by AQ queues. The recommended number of processes for Oracle Workflow is eleven or more.
AQ_TM_PROCESSES - This parameter enables the time manager process in Oracle Advanced Queuing (AQ). The time manager process is required by Oracle Workflow to monitor delay events in queues, as in the case of the Oracle Workflow standard Wait activity. The recommended number of time manager processes for Oracle Workflow is at least one.
This region displays summary information about work items and Business Event System agent activity.
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.
This graph displays the distribution of all work items with the following statuses: Active, Deferred, Suspended, and Error.
To view the distribution of item types within a status, either click the bar for that status in the graph, or click the status name link.
To view the number of work items with a particular status, position the mouse pointer over the bar for that status in the graph.
Note: A work item can be counted in more than one status. For example, all work items that do not have an end date are counted as Active work items, including deferred, suspended, and errored work items as well as running work items. Also, if an activity within an item is deferred, and the work item as a whole is suspended, the work item is included in the count for both the Deferred and Suspended statuses. Consequently, the total of the counts for all the statuses is greater than the actual number of work items.
This graph displays the distribution of all event messages on Business Event System agents with the following statuses: Ready, Waiting, Expired, Undeliverable, and Error.
Note: Messages are not explicitly assigned a status of Error. The Error bar in the graph represents messages of any status on the WF_ERROR agent.
To view the distribution of event messages with different statuses on different agents, either click the for a status in the graph, or click an event message status name link.
To view the number of event messages with a particular status, position the mouse pointer over the bar for that status in the graph.
Click the Completed Work Items link to view the distribution of completed work items across different item types.
Click the Notification Mailer Throughput link to view the Notification Mailer throughput. This graph shows the throughput of the Notification Mailer by displaying the distribution of notifications with the following statuses:
Processed - Outbound notifications for which an e-mail message has been sent by either the Workflow Mailer or the Workflow Summary Mailer.
Waiting - Outbound notifications for which an e-mail message has not yet been sent.
To view the number of notifications with a particular status, position the mouse pointer over the bar for that status in the graph.
Navigation: Applications Dashboard > (pull-down menu) Workflow Manager > (B) Go > Notification Mailer > (B) Configuration > (B) View Throughput