Kintana Script : Locate package lines with null app codes.

Purpose

User failure to enter an app code will nearly always cause a line migration to fail.

This query will locate such lines for you.

Tested

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

Usage

Paste the script into Toad or SQL Runner

select nu.first_name || ' ' || nu.last_name "User",
       ww.workflow_name,
       dpl.object_name,
       dpl.creation_date,
       dpl.package_id,
       dpl.seq "Line",
       dpl.app_code
from KDLV_PACKAGE_LINES dpl,
     KNTA_USERS nu,
     KDLV_OBJECT_TYPES dot,
     KDLV_PACKAGES dp,
     KWFL_WORKFLOWS ww
where  dpl.app_code is NULL
   and dpl.object_type_id = dot.object_type_id
   and dpl.package_id = dp.package_id
   and dp.workflow_id = ww.workflow_id
   and nu.user_id = dpl.created_by and nu.end_date is NULL   -- Limit to active users
--
-- Limit to a specified date range
-- and dpl.creation_date >= to_date('01-01-2008 01:00:00 AM', 'mm-dd-yyyy hh:mi:ss AM')
-- and dpl.creation_date <= to_date('12-31-2008 12:59:00 PM', 'mm-dd-yyyy hh:mi:ss PM')
--
order by 1 asc

Download

KintanaScripts.zip (64 Kb)