The table that holds ITPAM workflow instances to Request ID mapping

Products

• CA Service Management - Service Desk Manager
• CA Service Catalog
• CA Process Automation Base

Issue/Introduction

What is the CA Service Catalog table where the relationship with ITPAM flow and their states are stored?

Environment

CA Service Management 17.1 and higher.

Resolution

Table: usm_object_wf_instance_ref

• object_id1 - Refers to Request ID
• object_id2 - Refers to Subscription Detail ID

Object_type:

• OBJ_TYPE_OFFERING = 1; // Request item/offering object type
• OBJ_TYPE_REQUEST_ITEM = 2; // Request item object type
• OBJ_TYPE_REQUEST = 3; // Request object type

Workflow_type:

1. CA Workflow
2. PAM
3. Policy

public static final int WF_TY_CA_WF = 1;
public static final int WF_TY_CA_ITPAM = 2;
public static final int WF_TY_CA_POLICY_ENGINE = 3;