This table requires activation of Project Labor Distribution functional area. This table stores all exceptions in an allocation run
Module:
EXCEPTION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
EXCEPTION_ID | NUMBER | 38 | 0 | True | Uniqque identifier for Exception. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System generated unique identifier | ||||
RUN_ID | NUMBER | 38 | 0 | Allocation run identification number | |||
RULE_ID | NUMBER | 38 | 0 | Unique identifier for a distribution rule | |||
PROJECT_ID | NUMBER | 38 | 0 | Identifier of the project. | |||
TASK_ID | NUMBER | 38 | 0 | Identifier of the task. | |||
RUN_TARGET_ID | NUMBER | 38 | 0 | Run target ID | |||
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 | Expenditure item identifier | |||
EXCEPTION_TYPE | VARCHAR2 | 16 | Exception type | ||||
EXCEPTION_CODE | VARCHAR2 | 32 | Exception code to indicate exceptions | ||||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.