KWFL_STEP_TRANSACTIONS
There is one row in the KWFL_STEP_TRANSACTIONS table for each time that a step in a workflow is visited. This row contains the unique data for the step transaction, and denormalized context data for quicker querying.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KDLV_PACKAGES |
PACKAGE_ID |
CHILD_PACKAGE_ID |
KCRT_REQUESTS |
REQUEST_ID |
CHILD_REQUEST_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
DEST_ENVIRONMENT_ID |
KWFL_PENDING_EXEC_OBJECTS |
BATCH_ID |
EXECUTION_BATCH_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_ID |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
INSTANCE_SOURCE_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
INSTANCE_SOURCE_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
INSTANCE_SOURCE_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
INSTANCE_SOURCE_ID |
KDLV_PACKAGES |
PACKAGE_ID |
INSTANCE_SOURCE_SET_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_SET_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
INSTANCE_SOURCE_SET_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
INSTANCE_SOURCE_SET_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
INSTANCE_SOURCE_SET_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
PARAMETER_SET_CONTEXT_ID |
KWFL_PENDING_EXEC_OBJECTS |
PENDING_EXEC_OBJECT_ID |
PENDING_EXEC_OBJECT_ID |
KNTA_SCHEDULED_TASKS |
SCHEDULED_TASK_ID |
SCHEDULED_TASK_ID |
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
SOURCE_ENVIRONMENT_ID |
KCRT_REQUESTS |
REQUEST_ID |
TOP_INSTANCE_SOURCE_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
TOP_INSTANCE_SOURCE_ID |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
TOP_INSTANCE_SOURCE_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
TOP_INSTANCE_SOURCE_ID |
KDLV_PACKAGES |
PACKAGE_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KCRT_REQUESTS |
REQUEST_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
WORKFLOW_ID |
KWFL_WORKFLOW_INSTANCES |
WORKFLOW_INSTANCE_ID |
WORKFLOW_INSTANCE_ID |
KWFL_WORKFLOW_INSTANCE_STEPS |
WORKFLOW_INSTANCE_STEP_ID |
WORKFLOW_INSTANCE_STEP_ID |
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
WORKFLOW_STEP_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
STEP_TRANSACTION_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
WORKFLOW_INSTANCE_STEP_ID |
NOT NULL |
NUMBER |
This identifies the instance of the step to which this step transaction belongs. This is a foreign key into KWFL_WORKFLOW_INSTANCE_STEPS. |
WORKFLOW_INSTANCE_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the instance of the workflow to which this step transaction belongs. |
INSTANCE_SOURCE_SET_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the entity to which this step transaction belongs. This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS, or KWFL_STEP_TRANSACTIONS. |
INSTANCE_SOURCE_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
This denormalized column identifies whether the type of the entity using the workflow. Choices are "CR", "DIST", "IR", "REPORT", and "WORKFLOW" as specified by the lookup WF_INSTANCE_SOURCE_TYPE. |
INSTANCE_SOURCE_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the workflow. In the case of "IR", "DIST", "REPORT" and "WORKFLOW", the value in this column is identical to that in INSTANCE_SOURCE_SET_ID. |
TOP_INSTANCE_SOURCE_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
This denormalized column identifies whether the type of the entity using the Top-Level workflow (Non-Subworkflow). Choices are "CR", "DIST", "IR", and "REPORT". |
TOP_INSTANCE_SOURCE_SET_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS. |
TOP_INSTANCE_SOURCE_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). In the case of "IR", "DIST", "REPORT", the value in this column is identical to that in TOP_INSTANCE_SOURCE_SET_ID. |
WORKFLOW_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the workflow that is being run. |
WORKFLOW_STEP_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the step in the workflow to which this transaction belongs. |
GROUP_ID |
NULLABLE |
NUMBER |
This identifies a set of step transactions that were triggered directly by the same event. These Step Transaction rows necessarily also share the same WORKFLOW_STEP_ID. This column is used internally by the Workflow Engine to update these transactions en mass. |
STATUS |
NOT NULL |
VARCHAR2(30) |
This specifies the current status of the step transaction. Choices are specified by the seeded lookup WF_TXN_STATUS. |
RESET_FLAG |
NOT NULL |
VARCHAR2(1) |
This flag marks whether this step transaction resulted in a reset in the workflow instance. |
SUB_WORKFLOW_FLAG |
NOT NULL |
VARCHAR2(1) |
This flag marks whether this step transaction record is for a subworkflow step. |
USER_COMMENT |
NULLABLE |
VARCHAR2(400) |
This hold the comments entered by the users updating this step transaction. |
TIMEOUT_DATE |
NULLABLE |
DATE |
This specifies the final day by which this step transaction must complete. |
CONCURRENT_REQUEST_ID |
NULLABLE |
NUMBER |
This identifies the concurrent request (if any) that was spawned by this step transaction. |
RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
If this step transaction completed successfully, this holds the hidden result value. Valid values in this field are determined by the validation associated to the given workflow step. |
VISIBLE_RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
If this step transaction completed successfully, this holds the result value to be displayed to the user. Valid values in this field are determined by the validation associated to the given workflow step. |
ERROR_VALUE |
NULLABLE |
VARCHAR2(200) |
If this step transaction completed in error, this holds the hidden error value. These values are chosen among the codes of lookup WF_ERROR. |
VISIBLE_ERROR_VALUE |
NULLABLE |
VARCHAR2(200) |
If this step transaction completed in error, this holds error value to be displayed to the user. These values are chosen among the meaning values of lookup WF_ERROR. |
ERROR_MESSAGE |
NULLABLE |
VARCHAR2(240) |
If this step transaction completed in error, this holds the detailed information about the error. |
USER_STATUS_VALUE |
NULLABLE |
VARCHAR2(200) |
This is the NVL of RESULT_VALUE, ERROR_VALUE, and STATUS. |
VISIBLE_USER_STATUS_VALUE |
NULLABLE |
VARCHAR2(200) |
This is the NVL of VISIBLE_RESULT_VALUE, VISIBLE_ERROR_VALUE, and visible status. Additionally, the scheduled date or spawned concurrent request ID, or spawned Package is appended to the VISIBLE_USER_STATUS_VALUE. This field is directly displayed in the status tabs of the Issue and Package Detail windows. |
SCHEDULED_TASK_ID |
NULLABLE |
NUMBER |
This identifies the row in the KNTA_SCHEDULED_TASKS table that was created by this step transaction. A row is created in KNTA_SCHEDULED_TASKS when the user chooses to schedule an execution for a later date. |
PENDING_EXEC_OBJECT_ID |
NULLABLE |
NUMBER |
This identifies the command execution that was created by this step transaction. This is a foreign key into KWFL_PENDING_EXEC_OBJECTS. |
EXECUTION_BATCH_ID |
NULLABLE |
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 the items as a set. |
CHILD_REQUEST_ID |
NULLABLE |
NUMBER |
This identifies the request (if any) that was spawned by this step transaction. |
CHILD_PACKAGE_ID |
NULLABLE |
NUMBER |
This identifies the Package (if any) that was spawned by this step transaction. |
SOURCE_ENVIRONMENT_ID |
NULLABLE |
NUMBER |
This column specifies the source environment for the step transaction. It is read from the column SOURCE_ENVIRONMENT_ID in KWFL_WORKFLOW_STEPS. |
DEST_ENVIRONMENT_ID |
NULLABLE |
NUMBER |
This column specifies the destination environment for the step transaction. It is read from the column DEST_ENVIRONMENT_ID in KWFL_WORKFLOW_STEPS. |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on) |
SOURCE |
NULLABLE |
VARCHAR2(100) |
For records that have been updated by an interface or migrator, provides additional information about the source of the external update. |
PARAMETER_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
This identifies the context for this entity's parameters. |
PARAMETER1-25 |
NULLABLE |
VARCHAR2(200) |
Parameter set segment. This is used for command executions with parameters (for example, ai_create_request). |
VISIBLE_PARAMETER1-25 |
NULLABLE |
VARCHAR2(200) |
Parameter set segment |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_STEP_TRANSACTIONS_N1 |
NONUNIQUE |
1 |
GROUP_ID |
KWFL_STEP_TRANSACTIONS_N2 |
NONUNIQUE |
1 |
WORKFLOW_INSTANCE_ID |
KWFL_STEP_TRANSACTIONS_N2 |
NONUNIQUE |
2 |
WORKFLOW_INSTANCE_STEP_ID |
KWFL_STEP_TRANSACTIONS_N3 |
NONUNIQUE |
1 |
TIMEOUT_DATE |
KWFL_STEP_TRANSACTIONS_N3 |
NONUNIQUE |
2 |
STATUS |
KWFL_STEP_TRANSACTIONS_N5 |
NONUNIQUE |
1 |
INSTANCE_SOURCE_SET_ID |
KWFL_STEP_TRANSACTIONS_N6 |
NONUNIQUE |
1 |
STATUS |
KWFL_STEP_TRANSACTIONS_N6 |
NONUNIQUE |
2 |
TIMEOUT_DATE |
KWFL_STEP_TRANSACTIONS_N7 |
NONUNIQUE |
1 |
TOP_INSTANCE_SOURCE_ID |
KWFL_STEP_TRANSACTIONS_N8 |
NONUNIQUE |
1 |
TOP_INSTANCE_SOURCE_SET_ID |
KWFL_STEP_TRANSACTIONS_U1 |
UNIQUE |
1 |
STEP_TRANSACTION_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KWFL_STEP_TRANSACTIONS_S |
STEP_TRANSACTION_ID |
KWFL_STEP_TRANSACTION_GROUPS_S |
GROUP_ID |