Share this page
KENV_GROUP_EXEC_RESULTS
This table stores the destination environments where the environment group execution has successfully migrated to. This information will be used by the next run of the same workflow step to determine if we need to migrate to all the environments in the destination environment group or just part of it.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
SOURCE_ID |
|
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
STEP_TRANSACTION_ID |
|
KENV_ENVIRONMENTS |
ENVIRONMENT_ID |
SUCCEEDED_DEST_ENV_ID |
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_STEP_ID |
WORKFLOW_STEP_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
GROUP_EXEC_RESULT_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 |
|
SOURCE_TABLE |
NOT NULL |
VARCHAR2(30) |
Name of the table that stores the entity initiating this environment group execution (for example, KDLV_PACKAGE_LINES, KCRT_REQUESTS, KREL_DIST_LINE_INSTANCES) |
|
SOURCE_ID |
NOT NULL |
NUMBER |
Primary key value in the SOURCE_TABLE (for example, the value for a PACKAGE_LINE_ID, REQUEST_ID, or DIST_LINE_INSTANCE_ID) |
|
WORKFLOW_STEP_ID |
NOT NULL |
NUMBER |
ID of the workflow step initiating this environment group execution. |
|
STEP_TRANSACTION_ID |
NOT NULL |
NUMBER |
ID of the workflow step transaction for this environment group execution. |
|
SUCCEEDED_DEST_ENV_ID |
NOT NULL |
NUMBER |
ID of an environment in the destination environment group to which the object has been successfully migrated. |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KENV_GROUP_EXEC_RESULTS_U1 |
UNIQUE |
1 |
GROUP_EXEC_RESULT_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KENV_GROUP_EXEC_RESULTS_S |
GROUP_EXEC_RESULT_ID |
