Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: