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