KNTA_PENDING_EXCEPTIONS

This table stores one record for each exception run that was not successful for a project. The system uses the information in this table to perform the exception run later.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

SOURCE_ENTITY_ID

PM_PROJECTS

PROJECT_ID

SOURCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SOURCE_ID

NOT NULL

NUMBER

Source identifier

SOURCE_ENTITY_ID

NOT NULL

NUMBER

Source entity identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

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

ATTEMPTS

NULLABLE

NUMBER

Number of times the system attempted to perform the exception run

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PENDING_EXCEPTIONS_U1

UNIQUE

1

SOURCE_ID

KNTA_PENDING_EXCEPTIONS_U1

UNIQUE

2

SOURCE_ENTITY_ID

Sequences

This table uses no sequences.