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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.