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.