Kintana Script : List Steps without Statuses

Purpose

Forgetting to specify a step status name for a step is all too easy.

The workflow verify button catches a lot of problems, but missing step status
names aren't one of them.

Kintana

Tested with Kintana v6.0.

Usage

Paste the script into SQL Runner

Omit the comment, spool, and linesize statements unless you're using a PL-SQL editor. SQL Runner only supports select statements and you'll get a KNTA-10648 error. If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

spool c:\steps_without_statuses_yyyymmdd.txt
set linesize 1000

select ww.workflow_name,
       wws.sort_order "step#", wws.step_name, wws.step_type_code,
       wws.parent_status "Request Status", wws.enabled_flag "Step Enabled"
from KWFL_WORKFLOW_STEPS wws, KWFL_WORKFLOWS ww
where wws.workflow_id = ww.workflow_id
  and ww.workflow_name = 'My Workflow Name'  -- Limit to one workflow
  and wws.parent_status is NULL
  and wws.step_type_code in ( 'APPROVAL', 'EXECUTION')
-- order by parent_status, step_type_code, sort_order

spool off

WORKFLOW_NAME   Step#  STEP_NAME             STEP_TYPE_CODE  REQUEST_STATUS  Step Enabled
Main Inventory    5    Inspection Inwards    APPROVAL            [NULL]        Y
Main Inventory   62    Restock Packaging     APPROVAL            [NULL]        Y
Main Inventory   24    RFID update           DECISION            [NULL]        Y
...

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste.

Download

kintanascripts.doc (312 Kb)