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.