KWFL_PENDING_EXEC_CALLBACKS

This table is used by the Workflow Engine for storing data needed for future status updates. In particular, the Workflow Engine uses this table to update the parent Request when a Package completes; as well, the Engine uses this table to schedule a status update for a future time if the relevant rows are locked at this time. This table stores the relevant status and context data.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KDLV_PACKAGES

PACKAGE_ID

CHILD_PACKAGE_ID

KENV_ENVIRONMENTS

ENVIRONMENT_ID

DEST_ENVIRONMENT_ID

KWFL_PENDING_EXEC_OBJECTS

BATCH_ID

EXECUTION_BATCH_ID

KCRT_REQUESTS

REQUEST_ID

INSTANCE_SOURCE_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

SOURCE_ENVIRONMENT_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PENDING_EXEC_CALLBACK_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

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

INSTANCE_SOURCE_SET_ID

NOT NULL

NUMBER

This column identifies the ID of the entity to which this execution callback belongs. This is a foreign key into KDLV_PACKAGES, KCRT_REQUESTS, or KNTA_REPORT_SUBMISSIONS.

INSTANCE_SOURCE_TYPE_CODE

NOT NULL

VARCHAR2(30)

This column identifies whether the type of the entity using the workflow. Choices are "CR", "IR" and "REPORT" as specified by the lookup WF_INSTANCE_SOURCE_TYPE.

STEP_TXN_GROUP_IN_LIST

NOT NULL

VARCHAR2(2000)

This comma-separated list identifies the step transactions relevant to this execution callback.

WORKFLOW_STEP_ID

NOT NULL

NUMBER

This column identifies the step in the workflow to which this execution callback belongs.

RESULT_VALUE

NULLABLE

VARCHAR2(200)

If the execution completed successfully, this holds the hidden result value. Valid values in this field are specified by the validation WF - Standard Execution Results.

VISIBLE_RESULT_VALUE

NULLABLE

VARCHAR2(200)

If the execution completed successfully, this holds the result value to be displayed to the user. Valid values in this field are specified by the validation WF - Standard Execution Results.

ERROR_VALUE

NULLABLE

VARCHAR2(200)

If the execution completed in error, this holds the hidden error value. These values are chosen among the codes of lookup WF_ERROR.

VISIBLE_ERROR_VALUE

NULLABLE

VARCHAR2(200)

If the execution completed in error, this holds the visible error value. These values are chosen among the meaning values of lookup WF_ERROR.

ERROR_MESSAGE

NULLABLE

VARCHAR2(240)

If the execution completed in error, this holds the detailed information about the error.

VISIBLE_USER_STATUS_VALUE

NULLABLE

VARCHAR2(200)

This is the NVL of VISIBLE_RESULT_VALUE, VISIBLE_ERROR_VALUE, and visible status. Additionally, the scheduled date or spawned concurrent request ID, or spawned Package is appended to the VISIBLE_USER_STATUS_VALUE. This field is directly displayed in the status tabs of the request and Package Detail windows.

EXECUTION_BATCH_ID

NULLABLE

NUMBER

This identifies the set of command executions relevant to this callback.

CONCURRENT_REQUEST_ID

NULLABLE

NUMBER

This identifies the concurrent request (if any) that was spawned by the execution.

CHILD_PACKAGE_ID

NULLABLE

NUMBER

This identifies the Package (if any) that was spawned by the execution.

SOURCE_ENVIRONMENT_ID

NULLABLE

NUMBER

This identifies the workflow step source environment ID (if any) that was used during an execution.

DEST_ENVIRONMENT_ID

NULLABLE

NUMBER

This identifies the workflow step destination environment ID (if any) that was used during an execution.

CALLBACK_ATTEMPTS

NULLABLE

NUMBER

This specifies the number of times this callback row has been attempted thus far.

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_PENDING_EXEC_CALLBACKS_U1

UNIQUE

1

PENDING_EXEC_CALLBACK_ID

Sequences

Sequence Name

Sequence Type

KWFL_PENDING_EXEC_CALLBACKS_S

PENDING_EXEC_CALLBACK_ID