KWFL_TRANSACTIONS_INT
This table is used when you are migrating a Workflow from one instance to another.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
CURRENT_STEP_TRANSACTION_ID |
KNTA_USERS |
USER_ID |
DELEGATED_TO_USER_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_ID |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
INSTANCE_SOURCE_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_SET_ID |
KDLV_PACKAGES |
PACKAGE_ID |
INSTANCE_SOURCE_SET_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KWFL_WORKFLOWS_NLS |
WORKFLOW_STEP_ID |
TO_WORKFLOW_STEP_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 |
---|---|---|---|
TRANSACTION_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NULLABLE |
DATE |
Date record was created |
CREATED_USERNAME |
NOT NULL |
VARCHAR2(200) |
User that created the record |
CREATED_BY |
NULLABLE |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NULLABLE |
DATE |
Date record was last updated |
LAST_UPDATED_USERNAME |
NOT NULL |
VARCHAR2(200) |
User that last updated the record |
LAST_UPDATED_BY |
NULLABLE |
NUMBER |
Identifier for the user who last updated the record |
EVENT |
NOT NULL |
VARCHAR2(40) |
Identifies the transaction that the record is indented to perform |
GROUP_ID |
NULLABLE |
NUMBER |
Typical use is that a group_id is returned to the caller of run_interface procedure. This can be used to re-submit the records. |
WORKFLOW_ENGINE_BATCH_ID |
NULLABLE |
NUMBER |
Internal use only |
PROCESS_PHASE |
NOT NULL |
NUMBER |
Internal use only |
PROCESS_STATUS |
NOT NULL |
NUMBER |
Describes the current status of the record. For example, In Progress and Error. |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Internal use only |
SOURCE |
NULLABLE |
VARCHAR2(100) |
A alpha-numeric string can be provided to indicate a group of records that need to be processed. |
INSTANCE_SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Describes the product that the interface is invoked on. Typically internal use only. |
INSTANCE_SOURCE_SET_NUMBER |
NULLABLE |
VARCHAR2(40) |
Describes the source set number. For example, request number and package number. |
INSTANCE_SOURCE_SET_ID |
NULLABLE |
NUMBER |
Identifier for the source set. For example, request ID and package ID. |
INSTANCE_SOURCE_LINE_SEQ |
NULLABLE |
NUMBER |
Line sequence number for the package lines |
INSTANCE_SOURCE_ID |
NULLABLE |
NUMBER |
Identifier for the source line such as package line ID. |
WORKFLOW_STEP_NAME |
NULLABLE |
VARCHAR2(80) |
Step name of the workflow that needs to be processed. |
WORKFLOW_STEP_SEQ |
NULLABLE |
VARCHAR2(30) |
Step sequence of the workflow that needs to be processed. |
RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
Hidden result value of the workflow transaction that user is initiating. |
VISIBLE_RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
Visible result value of the workflow transaction that user is initiating. |
USER_COMMENTS |
NULLABLE |
VARCHAR2(200) |
Comments that the user wants to attach to the notes field while processing the transaction. |
DELEGATED_TO_USERNAME |
NULLABLE |
VARCHAR2(200) |
Describes the user name who this step needs to be delegated (In case the transaction is a delegation) |
DELEGATED_TO_USER_ID |
NULLABLE |
NUMBER |
Describes the user ID who this step needs to be delegated (In case the transaction is a delegation) |
SCHEDULE_DATE |
NULLABLE |
DATE |
While scheduling a task, this field will specify the date/time the task should start. |
WORKFLOW_ID |
NULLABLE |
NUMBER |
Internal use only |
WORKFLOW_INSTANCE_ID |
NULLABLE |
NUMBER |
Internal use only |
WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
Identifier of the workflow step that needs to be processed. |
WORKFLOW_INSTANCE_STEP_ID |
NULLABLE |
NUMBER |
Internal use only |
CURRENT_STEP_TRANSACTION_ID |
NULLABLE |
NUMBER |
Internal use only |
APPROVALS_REQUIRED_CODE |
NULLABLE |
VARCHAR2(30) |
Internal use only |
EVENT_GROUP_ID |
NULLABLE |
NUMBER |
Internal use only |
CMD_EXECUTION_SCHD_TASK_ID |
NULLABLE |
NUMBER |
Internal use only |
TO_WORKFLOW_STEP_SEQ |
NULLABLE |
VARCHAR2(30) |
In case of force transition event, this describes the workflow step sequence to transition to. |
TO_WORKFLOW_STEP_NAME |
NULLABLE |
VARCHAR2(80) |
In case of force transition event, this describes the workflow step name to transition to. |
TO_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
In case of force transition event, this describes the workflow ID sequence to transition to. |
DATA_LANG |
NULLABLE |
VARCHAR2(40) |
Internal use only |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_TRANSACTIONS_INT_N1 |
NONUNIQUE |
1 |
CMD_EXECUTION_SCHD_TASK_ID |
KWFL_TRANSACTIONS_INT_N1 |
NONUNIQUE |
2 |
PROCESS_STATUS |
KWFL_TRANSACTIONS_INT_N2 |
NONUNIQUE |
1 |
GROUP_ID |
KWFL_TRANSACTIONS_INT_N2 |
NONUNIQUE |
2 |
PROCESS_PHASE |
KWFL_TRANSACTIONS_INT_N2 |
NONUNIQUE |
3 |
PROCESS_STATUS |
KWFL_TRANSACTIONS_INT_N2 |
NONUNIQUE |
4 |
EVENT |
KWFL_TRANSACTIONS_INT_N3 |
NONUNIQUE |
1 |
WORKFLOW_ENGINE_BATCH_ID |
KWFL_TRANSACTIONS_INT_U1 |
UNIQUE |
1 |
TRANSACTION_ID |
Sequences
This table uses no sequences.