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 |