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.