Take Control of Workflow with Workflow Analyzer!

Posted by user793553 on Oracle Blogs See other posts from Oracle Blogs or by user793553
Published on Tue, 13 Nov 2012 02:40:09 +0000 Indexed on 2012/11/13 5:08 UTC
Read the original article Hit count: 498

Filed under:

Take Control of Workflow with Workflow Analyzer!
Immediate Analysis and Output of your EBS Workflow Environment

The EBS Workflow Analyzer is a script that reviews the current Workflow Footprint, analyzes the configurations, environment, providing feedback, and recommendations on Best Practices and areas of concern.

Go to Doc ID 1369938.1  for more details and script download with a short overview video on it.

Proactive Benefits:

  • Immediate Analysis and Output of Workflow Environment
    • Identifies Aged Records
    • Identifies Workflow Errors & Volumes
    • Identifies looping Workflow items and stuck activities
    • Identifies Workflow System Setup and configurations
    • Identifies and Recommends Workflow Best Practices
  • Easy To Add Tool for regular Workflow Maintenance
  • Execute Analysis anytime to compare trending from past outputs

The Workflow Analyzer presents key details in an easy to review graphical manner.   See the examples below.

Workflow Runtime Data Table Gauge
The Workflow Runtime Data Table Gauge will show critical (red), bad (yellow) and good (green) depending on the number of workflow items (WF_ITEMS).

 

Workflow Error Notifications Pie Chart
A pie chart shows the workflow error notification types.

Workflow Error Notifications Pie Chart 

Workflow Runtime Table Footprint Bar Chart
A pie chart shows the workflow error notification types and a bar chart shows the workflow runtime table footprint.

Workflow Error Notifications Pie Chart 

The analyzer also gives detailed listings of setups and configurations. As an example the workflow services are listed along with their status for review:

Workflow Error Notifications Pie Chart 

The analyzer draws attention to key details with yellow and red boxes highlighting areas of review:

Workflow Error Notifications Pie Chart 

You can extend on any query by reviewing the SQL Script and then running it on your own or making modifications for your own needs:

Workflow Error Notifications Pie Chart   

Find more details in these notes:

  • Doc ID 1369938.1 Workflow Analyzer script for E-Business Suite Worklfow Monitoring and Maintenance
  • Doc ID 1425053.1 How to run EBS Workflow Analyzer Tool as a Concurrent Request

Or visit the My Oracle Support EBS - Core Workflow Community  

© Oracle Blogs or respective owner

Related posts about /Oracle/ATG