Kintana Script : Decisions Required 'All' Bottlenecks

Purpose

When you design a workflow with 'Decisions Required = All' steps you are building in potential bottlenecks.

If at all possible you should use the 'Decisions Required = 'At_Least_One' alternative.

This script lists the workflows and workflow steps where these decision types exist.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

select ww.workflow_name, wws.sort_order "Seq", wws.step_name,
       wa.approvals_required_code
from KWFL_WORKFLOW_STEPS wws,
     KWFL_APPROVALS wa,
     KWFL_WORKFLOWS ww
where wws.step_type_code = 'APPROVAL'
  and wws.step_source_id = wa.approval_id
  and wa.approvals_required_code in ( 'ALL', 'AT_LEAST_ONE' )
  and wws.workflow_id = ww.workflow_id
  and ww.enabled_flag = 'Y'
  and wws.enabled_flag = 'Y'
order by ww.workflow_name, wws.sort_order

WORKFLOW_NAME                   SEQ  STEP_NAME     APPROVALS_REQUIRED_CODE
Circuit Board Assembly Workflow   6  Certification ALL
...

Download

KintanaScripts.zip (58 Kb)