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