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