Share this page

# KDLV_TRANSACTIONS_INT

The KDLV_TRANSACTIONS_INT interface table is used to provide transaction information.

This table and other interface tables will be processed through the Java™ report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allow for scheduled processing.

Table A-24. KDLV_TRANSACTIONS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_INTERFACE_ID | I/O | NUMBER | System-generated identifier
GROUP_ID | I/O | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PROCESS_PHASE | I/O | NUMBER | Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS | I/O | NUMBER | Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME.
CREATED_BY_USERNAME | I/O | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank. If both are left blank, the value is set to the user currently running the report.
CREATION_DATE | I/O | DATE | Indicates the date that the record was created. If left blank, the current date is used.
SOURCE_CODE | I/O | VARCHAR2 | Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
PACKAGE_ID | I/O | NUMBER | Provides an identifier for a package and makes the association between the package and package lines. Derived from the KDLV_PACKAGES_S sequence. For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records. For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package.
PACKAGE_NUMBER | I/O | VARCHAR2 | Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string.
PACKAGE_LINE_ID | I/O | NUMBER | Provides the identifier for a package line. This is normally left blank and the value is derived from the KDLV_PACKAGE_LINES_S sequence.
PACKAGE_LINE_SEQ | I/O | NUMBER | Provides the identifier for a package line. Derived from the KDLV_PACKAGE_LINES_S sequence. Use if the transaction is for a package line.
WORKFLOW_INSTANCE_STEP_ID | I/O | NUMBER | Specifies the instance step ID.
WORKFLOW_STEP_ID | I/O | NUMBER | Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS). Supply this, WORKFLOW_STEP_NAME, or WORKFLOW_STEP_SEQ.
WORKFLOW_STEP_NAME | I/O | VARCHAR2 | Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS). Supply this or P_WORKFLOW_STEP_SEQ.
RESULT_VALUE | I/O | VARCHAR2 | Indicates the result of the step. This is normally not displayed to the user; therefore it may be an ID or internal code.
VISIBLE_RESULT_VALUE | I/O | VARCHAR2 | Indicates the result of the step. This is the result value that a user normally sees.
EXECUTE_FLAG | I/O | VARCHAR2 | Indicates whether or not a specific step is executable.
COMMENTS | I/O | VARCHAR2 | Specifies comments for the transaction. Any comments are appended to the notes for the package or request.
SCHEDULE_DATE | I/O | DATE | Indicates the date that the execution step is scheduled to run.

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: