Share this page

# KNTA_INTERFACE_ERRORS

This table stores error information on each of the interface tables. When an error occurs in a record of any of these tables, there will be a corresponding record in the KNTA_INTERFACE_ERRORS table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS_INT | TRANSACTION_ID | INTERFACE_SOURCE_ID
KCRT_REQUESTS_INT | TRANSACTION_ID | INTERFACE_SOURCE_ID
KDLV_TRANSACTIONS_INT | TRANSACTION_INTERFACE_ID | INTERFACE_SOURCE_ID
KDLV_PACKAGES_INT | PACKAGE_INTERFACE_ID | INTERFACE_SOURCE_ID
KDLV_PACKAGE_NOTES_INT | PACKAGE_NOTE_INTERFACE_ID | INTERFACE_SOURCE_ID
KCRT_CONTACTS_INT | CONTACT_INTERFACE_ID | INTERFACE_SOURCE_ID
KDLV_PACKAGE_LINES_INT | PACKAGE_LINE_INTERFACE_ID | INTERFACE_SOURCE_ID
KWFL_STEP_TRANSITIONS_INT | TRANSACTION_ID | INTERFACE_SOURCE_ID
KCRT_REQUEST_DETAILS_INT | TRANSACTION_ID | INTERFACE_SOURCE_ID
KNTA_MESSAGE_TYPES_NLS | MESSAGE_TYPE_ID | MESSAGE_TYPE_ID
KWFL_TRANSACTIONS_INT | TRANSACTION_ID | INTERFACE_SOURCE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
INTERFACE_ERROR_ID | NOT NULL | NUMBER | System-generated identifier
INTERFACE_TABLE_NAME | NOT NULL | VARCHAR2(30) | Name of the interface table that caused the error
INTERFACE_SOURCE_ID | NOT NULL | NUMBER | ID of the interface table record that caused the error
GROUP_ID | NOT NULL | NUMBER | Group ID of the interface table record that caused the error
CREATION_DATE | NOT NULL | DATE | Date record was created
MESSAGE_TYPE_ID | NOT NULL | NUMBER | ID of error message
MESSAGE_NAME | NULLABLE | VARCHAR2(100) | Name of the error message
MESSAGE | NULLABLE | VARCHAR2(2000) | Error message

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_INTERFACE_ERRORS_N1 | NONUNIQUE | 1 | GROUP_ID
KNTA_INTERFACE_ERRORS_N1 | NONUNIQUE | 2 | INTERFACE_SOURCE_ID
KNTA_INTERFACE_ERRORS_N2 | NONUNIQUE | 1 | INTERFACE_SOURCE_ID
KNTA_INTERFACE_ERRORS_N2 | NONUNIQUE | 2 | GROUP_ID
KNTA_INTERFACE_ERRORS_N3 | NONUNIQUE | 1 | INTERFACE_ERROR_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_INTERFACE_ERRORS_S | INTERFACE_ERROR_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: