DW_LABOR_DIST_EXCEPTION_MAP_G (Preview)

This table requires activation of Project Labor Distribution functional area. 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.