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 |
