# DW_LABOR_DIST_EXCEPTION_MAP_G

This table stores all exceptions in an allocation run

## Details

Module:

## Key Columns

EXCEPTION_ID

## Columns

Columns
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, 2026, Oracle and/or its affiliates.