Share this page

# 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

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: