Share this page

# KDLV_PENDING_PACKAGES

This table stores records of executions that submit concurrent requests to Oracle Applications such as AOL and GL migrations.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KWFL_PENDING_EXEC_OBJECTS | BATCH_ID | BATCH_ID
KENV_ENVIRONMENTS | ENVIRONMENT_ID | DEST_ENVIRONMENT_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KDLV_PACKAGES | PACKAGE_ID | PACKAGE_ID
KDLV_PACKAGE_LINES | PACKAGE_LINE_ID | PACKAGE_LINE_ID
KWFL_STEP_TRANSACTIONS | STEP_TRANSACTION_ID | STEP_TRANSACTION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PACKAGE_ID | NOT NULL | NUMBER | Package ID. Refers to KDLV_PACKAGES
BATCH_ID | NOT NULL | NUMBER | Execution batch ID used to launch the concurrent request. Refers to KWFL_PENDING_EXEC_OBJECTS
CONC_REQUEST_ID | NOT NULL | NUMBER | Concurrent request ID submitted to the Oracle Applications concurrent request manager. May not be unique in this table if you have multiple concurrent requests, and some go to different DB Links.
STEP_TRANSACTION_ID | NOT NULL | NUMBER | Identifies the step transaction in KWFL_STEP_TRANSACTIONS that resulted in the concurrent request submission. STEP_TRANSACTION_ID is required to write back status results to the KWFL_STEP_TRANSACTIONS table.
DB_LINK | NULLABLE | VARCHAR2(128) | Database Link used to get the status of concurrent requests submitted to other remote databases running Oracle Applications
CONC_REQ_SUBMISSION_CODE | NOT NULL | VARCHAR2(30) | Combination of Status and Phase used by Oracle Applications to track the status of concurrent requests submissions. If 'INVALID' then this request has not been submitted.
STATUS | NOT NULL | VARCHAR2(30) | Status of the concurrent request. If 'COMPLETED' then result_value must not be null. 'NEW' means it has not yet been submitted. 'IN_PROGRESS' means it has already been submitted but not yet completed.
RESULT_VALUE | NULLABLE | VARCHAR2(200) | Holds the hidden result value from a successfully completed workflow step. Valid values in this field are determined by the validation associated with the given workflow step.
VISIBLE_USER_STATUS_VALUE | NULLABLE | VARCHAR2(200) | Holds the result value to be displayed to the user from a successfully completed workflow step. Valid values in this field are determined by the validation associated with the given workflow step
CHANGED_FLAG | NOT NULL | VARCHAR2(1) | When set to 'Y' the status has changed since last checking the Oracle tables for the status of the concurrent request. This signals that the data in KDLV_CONC_REQUESTS should by synchronized with the workflow status tables
CREATION_DATE | NOT NULL | DATE | If status is 'NEW' then this is the record creation date. If status is not 'NEW' then this is the date this job was submitted to the concurrent manager.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
NUM_OF_CHECKS | NOT NULL | NUMBER | Used to keep track of how many times the status of a pending request is checked. If the number is too great, it will error out the request
PACKAGE_LINE_ID | NULLABLE | NUMBER | Package Line ID. Refers to KDLV_PACKAGE_LINES
DEST_ENVIRONMENT_ID | NULLABLE | NUMBER | Environment ID of the environment to which the job was submitted. Refers to KENV_ENVIRONMENTS. This column is null if this was a single environment execution. If it is for an environment group, it contains one destination environment ID from the group.
TOP_INSTANCE_SOURCE_TYPE_CODE | NOT NULL | VARCHAR2(30) | Indicates the type of workflow that submitted this concurrent request (package, distribution)
DIST_LINE_INSTANCE_ID | NULLABLE | NUMBER | (Obsolete) Distribution Line Instance ID. Refers to KREL_DIST_LINE_INSTANCES. Is null if top_instance_source_type_code is not 'DIST'.
NOTIFICATION_COUNT | NULLABLE | NUMBER | Holds the number of attempts to notify the listener upon completion of concurrent requests
NULL_EXECONTEXT_NODE_NUMBER | NULLABLE | NUMBER | Stores the number of nodes which does not contain exeContext object

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDLV_PENDING_PACKAGES_N1 | NONUNIQUE | 1 | PACKAGE_ID
KDLV_PENDING_PACKAGES_N2 | NONUNIQUE | 1 | STEP_TRANSACTION_ID
KDLV_PENDING_PACKAGES_N3 | NONUNIQUE | 1 | STATUS

## Sequences

This table uses no sequences.

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: