KNTA_EXCEPTIONS

This table stores Exceptions for projects, tasks and rollup exceptions. Whenever an exception Rule is violated an Exception is raised by the Exception Engine and it is stored in this table. (In future this will be used by Requests, Packages and Package lines also.)

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_EXCEPTION_RULES_NLS

EXCEPTION_RULE_ID

EXCEPTION_RULE_ID

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

EXCEPTION_ID

NOT NULL

NUMBER

System-generated 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

EXCEPTION_RULE_ID

NOT NULL

NUMBER

Exception rule identifier

SOURCE_ENTITY_ID

NOT NULL

NUMBER

Source type identifier, could be an entity identifier of a project, task, request, package or package line

SOURCE_ID

NOT NULL

NUMBER

Source identifier, could be an identifier of a project, task, request, package or package line

EXCEPTION_MESSAGE

NULLABLE

VARCHAR2(2000)

Exception message text

VIOLATION

NULLABLE

VARCHAR2(250)

Violation attribute

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_EXCEPTIONS_N1

NONUNIQUE

1

SOURCE_ENTITY_ID

KNTA_EXCEPTIONS_N1

NONUNIQUE

2

SOURCE_ID

KNTA_EXCEPTIONS_N2

NONUNIQUE

1

EXCEPTION_RULE_ID

KNTA_EXCEPTIONS_N3

NONUNIQUE

1

EXCEPTION_ID

Sequences

Sequence Name

Sequence Type

KNTA_EXCEPTIONS_S

EXCEPTION_ID