Share this page

# KWFL_PENDING_EXEC_OBJECTS

This table stores information that is used by the Workflow Engine to set up command executions to be distributed by the Execution Dispatcher to various ExecutionManagers. After inserting rows, the Workflow Engine explicitly calls the EventDispatcher with the event group ID of the rows that it had written.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KCRT_REQUESTS | REQUEST_ID | SOURCE_ID
KNTA_REPORT_SUBMISSIONS | REPORT_SUBMISSION_ID | SOURCE_ID
KDLV_PACKAGE_LINES | PACKAGE_LINE_ID | SOURCE_ID
KWFL_STEP_TRANSACTIONS | STEP_TRANSACTION_ID | STEP_TRANSACTION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PENDING_EXEC_OBJECT_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
EVENT_GROUP_ID | NOT NULL | NUMBER | This identifies a set of command execution transactions that were triggered directly or indirectly by the same event.
BATCH_ID | NOT NULL | NUMBER | This identifies a set of command executions being performed together. Step transactions directly triggered by the same event will share a batch ID This column is used by the execution manager performs and organizes the execution of these rows as a set (sorting appropriately by Package Line SEQ and so on)
STEP_TRANSACTION_ID | NOT NULL | NUMBER | This identifies the step transaction to which this execution belongs.
CLASS_NAME | NOT NULL | VARCHAR2(100) | This identifies the java class that should be run to perform the executions in the batch. The class is a subclass of ExecutionManager
SOURCE_ID | NOT NULL | NUMBER | This identifies the entity using the workflow. This can be a foreign key into the KDLV_PACKAGE_LINES, KCRT_REQUESTS, OR KNTA_REPORT_SUBMISSIONS tables.
SOURCE_TABLE | NOT NULL | VARCHAR2(30) | This is one of KDLV_PACKAGE_LINES, KCRT_REQUESTS, OR KNTA_REPORT_SUBMISSIONS. This column identifies the table on which SOURCE_ID is a foreign key.
START_DATE | NULLABLE | DATE | Not used
COMPLETION_DATE | NULLABLE | DATE | Not used

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_PENDING_EXEC_OBJECTS_N1 | NONUNIQUE | 1 | BATCH_ID
KWFL_PENDING_EXEC_OBJECTS_N2 | NONUNIQUE | 1 | EVENT_GROUP_ID
KWFL_PENDING_EXEC_OBJECTS_N3 | NONUNIQUE | 1 | STEP_TRANSACTION_ID
KWFL_PENDING_EXEC_OBJECTS_U1 | UNIQUE | 1 | PENDING_EXEC_OBJECT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KWFL_EVENT_GROUP_ID_S | EVENT_GROUP_ID
KWFL_EXEC_OBJECT_BATCH_ID_S | BATCH_ID
KWFL_PENDING_EXEC_OBJECTS_S | PENDING_EXEC_OBJECT_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: