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