While loading the rows from staging to fact, no duplicate rows will be processed. Duplicate rows will be identified and moved to the error table. You can either delete the duplicate rows from the error table or modify the rows to make each row unique. These rows will be processed in the next run.
Overview of Handling Duplicates
Use an aggregator operator to group_by the PK columns or merge columns and calculate the row count using the count(pk) method.
Join the resultant rows back to the main joiner based on the pk_columns.
Add a splitter condition for the duplicate rows as consider rows to be in error when then duplicate_count >1.
Error Code | Description | Reference Physical Column | Error Type |
---|---|---|---|
DUP | Duplicate rows | Duplicate rows | |
EQP | Missing Equipment reference | EQUIPMENT_FK | Referential Integrity |
SEG | Missing Segment reference | SEGMENT_FK | Referential Integrity |
UD1 | Missing User Dimension Key1 | USER_DIM1_FK | Referential Integrity |
UD2 | Missing User Dimension Key2 | USER_DIM2_FK | Referential Integrity |
UD3 | Missing User Dimension Key3 | USER_DIM3_FK | Referential Integrity |
UD4 | Missing User Dimension Key4 | USER_DIM4_FK | Referential Integrity |
UD5 | Missing User Dimension Key5 | USER_DIM5_FK | Referential Integrity |
ITM | Missing Item/Product reference | ITEM_FK, PRODUCT_FK | Referential Integrity |
PLT | Missing Plant reference | PLANT_FK | Referential Integrity |
WKO | Missing work order reference | WORKORDER_FK | Referential Integrity |
WDS | Missing Workday Shift reference | SHIFT_WORKDAY_FK | Referential Integrity |
RES | Missing Resource reference | RESOURCE_FK | Referential Integrity |
ENT | Missing Equipment dimension Entity reference or user dimension entity reference | ENTITY_FK | Referential Integrity |
CAT | Missing Category reference | CATEGORY_FK | Referential Integrity |
MTL | Missing Material reference | MATERIAL_FK | Referential Integrity |
FLC | Missing FND Lookup Code | STATUS (WO Status) | Referential Integrity |
MLC | Missing MTH Lookup code | Referential Integrity | |
SSG | Missing Sub Segment reference | SUB_SEGMENT_FK_KEY | Referential Integrity |
HRY | Missing Hierarchy reference | HIERARCHY_NAME | Referential Integrity |
PFK | Missing Parent reference for time, item, equipment and user dimensions | PARENT_FK | Referential Integrity |
LFK | Missing Level reference for time, item, equipment and user dimensions | LEVEL_FK | Referential Integrity |
DIM | Missing Dimension Reference | DIMENSION_NAME | Referential Integrity |
MCT | Missing Material Consumed Transaction reference | WO_MAT_TXN_PK_KEY | Referential Integrity |
MPT | Missing Material Produced Transaction reference | WO_COMP_PK_KEY | Referential Integrity |
ESD | Missing reference record in MTH_EQUIPMENT_SHIFTS_D table | Referential Integrity | |
ETC | Missing Event Type Code reference in the FND_LOOKUPS | EVENT_TYPE_CODE | Referential Integrity |
RCS | Missing Reason code reference in the MTH_EQUIPMENT_REASON_SETUP table | REASON_CODE | Referential Integrity |
ATC | Missing Action Type Code reference in the FND_LOOKUPS | ACTION_TYPE_CODE | Referential Integrity |
PER | Missing Personnel reference | PERSON_FK | Referential Integrity |
AHC | Missing Action Handler Code reference in the FND_LOOKUPS | ACTION_HANDLER_CODE | Referential Integrity |
DOM | Missing Domain Name reference in the FND_LOOKUPS | DOMAIN_NAME | Referential Integrity |
ERT | Wrong Reason Type in MTH_EQUIPMENT_REASON_SETUP table | REASON_TYPE | Wrong Data |
EUT | Expected uptime for Scrap Reason in MTH_EQUIPMENT_REASON_SETUP table | EXPECTED_UP_TIME | Wrong Data |
NTN | Personnel reference or Email notification or Mobile notification is missing for the NOTIFICATION event action | NOTIFICATION | Wrong Data |
LVN | ENTITY_TYPE is not equal with LEVEL_NAME | LEVEL_NAME | Wrong Data |
NOL | Number_of_level is wrong | Number_of_level | Wrong Data |
DIM | DIMENSION_NAME is null | DIMENSION_NAME | Referential Integrity |
HIE | HIERARCHY_NAME is null | HIERARCHY_NAME | Referential Integrity |
EFD | Effective date is wrong | Effective_date | Wrong Data |
SYS | system pk key is null | System_pk | Referential Integrity |
BFC | BUSI_FUNC_CODE is wrong | BUSI_FUNC | Referential Integrity |
MRV | MAX_RESET_VALUE is null | MAX_RESET_VALUE | Wrong Data |
RED | READING_TYPE_CODE is null | READING_TYPE | Referential Integrity |
SRC | tag_data_source_name is wrong | tag_data_source_name | Referential Integrity |
DTE | To_date is less than from date | To_date, from_date | Wrong Data |
SFT | shift_fk is wrong | shift_fk | Referential Integrity |
STS | STATUS_CODE is wrong | STATUS | Referential Integrity |
PDT | production type is wrong | production type | Referential Integrity |
ENC | ENT_TYPE_CODE is null | ENT_TYPE | Referential Integrity |
TAT | TAG_TYPE_CODE IS NULL | TAG_TYPE | Referential Integrity |
DAT | DATA_TYPE_CODE is null | DATA_TYPE | Referential Integrity |
ORT | ORDER_TYPE_CODE is null | ORDER_TYPE | Referential Integrity |
GRA | GRAVEYARD_CODE is wrong | GRAVEYARD | Referential Integrity |
INI | INITIAL_VALUE is wrong | INITIAL_VALUE | Wrong Data |
IEN | Inactive Entities | STATUS | STATUS not in ACTIVE |
POU | Period of usage not present in 445 calendar | PERIOD_OF_USAGE | Referential Integrity |
EET | Entity Reference Missing | ENTITY_FK+ENTITY_TYPE | Referential Integrity |
IDS | TAG_TYPE in tag data source is not correct or missing data source | TAG_TYPE | Missing data source or incorrect data |
NGV | Value in TAG_VALUE or USAGE_VALUE is negative | TAG_VALUE / USAGE VALUE | Negative value |
OTR | Usage value is out of range defined for a cumulative tag | TAG_VALUE | Data out of range |
OTO | Readings are out of order | TAG_VALUE | Data out of order |
MIM | There is no meter associated with the tag | Missing associated meter for the meter tag | |
WFQ | Wrong frequency number | FREQUENCY_IN_MINUTES | Wrong frequency number |
NFQ | Frequency is not support for OPERATION tag type | FREQUENCY_IN_MINUTES | Frequency not supported |
USI | Un-needed setting for incremental tags, including INITIAL_VALUE, MAX_RESET_VALUE, ORDER_TYPE_CODE, and READING_TYPE_CODE | Wrong data | |
WSC | Wrong setting for cumulative tags including missing or wrong INITIAL_VALUE, missing or wrong MAX_RESET_VALUE, missing ORDER_TYPE_CODE, or un-needed FREQUENCY_IN_MINUTES | Wrong data | |
CRI | Wrong Equipment Criticality | EQUIPMENT_CRITICALITY | Wrong Data |
DTC | For Alphanumeric data type tags setting of READING_TYPE, ORDER_TYPE or MAX_RESET_VALUE | Wrong Data | |
MET | Meter Reference Missing | METER_FK | Referential Integrity |
FMT | Null From date | FROM_DATE | Wrong data |
TOT | Null To date | TO_DATE | Wrong data |
USG | Null Usage Value | USAGE_VALUE | Wrong data |
OLP | Overlap Time | TO_DATE, FROM_DATE | Wrong data |
AVF | Invalid AVAILABILITY_FLAG | AVAILABILITY_FLAG | Wrong data |
RSN | Provided REASON for availability of entity shift | REASON | Wrong data |
RCD | Wrong REASON for unavailability of entity shift | REASON | Wrong data |
SUS | SUSTAIN_ASPECT_PK_KEY is null | SUSTAIN_ASPECT_PK | Referential Integrity |
DTN | DATA_TYPE IS NULL | DATA_TYPE | Missing Data Type |
NRC | For Numeric data type value of reading type code | Wrong data | |
FTD | Data provided is for the future date, which is invalid | Wrong data |
TARGET_TABLE | ERROR_TABLE | ERR_CODE | DESCRIPTION |
---|---|---|---|
MTH_ASSET_MST | MTH_ASSET_ERR | ASSET_GROUP | Value was not provided for column ASSET_GROUP or the value provided for corresponding staging table column was invalid |
MTH_ASSET_MST | MTH_ASSET_ERR | ASSET_GROUP_ID | Value was not provided for column ASSET_GROUP_ID or the value provided for corresponding staging table column was invalid |
MTH_ASSET_MST | MTH_ASSET_ERR | ASSET_NUMBER | Value was not provided for column ASSET_NUMBER or the value provided for corresponding staging table column was invalid |
MTH_ASSET_MST | MTH_ASSET_ERR | ASSET_PK | Value was not provided for column ASSET_PK or the value provided for corresponding staging table column was invalid |
MTH_ASSET_MST | MTH_ASSET_ERR | DUP | Multiple records were found leading to the same value or combination of ASSET_PK in target table. |
MTH_ASSET_MST | MTH_ASSET_ERR | FLC | Invalid value was provided for ASSET_CRITICALITY_CODE. |
MTH_ASSET_MST | MTH_ASSET_ERR | MAINTENANCE_ORG_CODE | Value was not provided for column MAINTENANCE_ORG_CODE or the value provided for corresponding staging table column was invalid |
MTH_ASSET_MST | MTH_ASSET_ERR | PLT | Entered maintenance org code is not enabled as an EAM organization for the current system. |
MTH_DAY_D | MTH_DAY_ERR | GAP | Record has a gap with respect to previous entry. |
MTH_DAY_D | MTH_DAY_ERR | OVP | Record overlaps with another entry. |
MTH_DAY_D | MTH_DAY_ERR | REPORT_DATE | Value was not provided for column REPORT_DATE or the value provided for corresponding staging table column was invalid |
MTH_DAY_D | MTH_DAY_ERR | REPORT_DATE_JULIAN | Value was not provided for column REPORT_DATE_JULIAN or the value provided for corresponding staging table column was invalid |
MTH_DIM_HIERARCHY | MTH_DIM_HIERARCHY_ERR | DIMENSION_NAME | Value was not provided for column DIMENSION_NAME or the value provided for corresponding staging table column was invalid |
MTH_DIM_HIERARCHY | MTH_DIM_HIERARCHY_ERR | DUP | Multiple records were found leading to the same value or combination of DIMENSION_NAME, HIERARCHY_NAME in target table. |
MTH_DIM_HIERARCHY | MTH_DIM_HIERARCHY_ERR | HIERARCHY_NAME | Value was not provided for column HIERARCHY_NAME or the value provided for corresponding staging table column was invalid |
MTH_DIM_HIERARCHY | MTH_DIM_HIERARCHY_ERR | NOL | Invalid value was provided for NUMBER_OF_LEVEL. Valid values are 2 through 10. |
MTH_DIM_LEVEL_LOOKUP | MTH_DIM_LEVEL_LOOKUP_ERR | DIMENSION_ID | Value was not provided for column DIMENSION_ID or the value provided for corresponding staging table column was invalid |
MTH_DIM_LEVEL_LOOKUP | MTH_DIM_LEVEL_LOOKUP_ERR | DUP | Multiple records were found leading to the same value or combination of DIMENSION_ID, HIERARCHY_ID, LEVEL_NUM in target table. |
MTH_DIM_LEVEL_LOOKUP | MTH_DIM_LEVEL_LOOKUP_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_DIM_LEVEL_LOOKUP | MTH_DIM_LEVEL_LOOKUP_ERR | LEVEL_NUM | Value was not provided for column LEVEL_NUM or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | DUP | Multiple records were found leading to the same value or combination of ENTITY_FK_KEY, SUSTAIN_ASPECT_FK_KEY, PERIOD_OF_USAGE in target table. |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | ENTITY_FK_KEY | Value was not provided for column ENTITY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | IEN | Entity is not active. |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | PERIOD_OF_USAGE | Value was not provided for column PERIOD_OF_USAGE or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | PLANNED_USAGE | Value was not provided for column PLANNED_USAGE or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | POU | Invalid value was provided for PERIOD_OF_USAGE. |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | SUSTAIN_ASPECT_FK_KEY | Value was not provided for column SUSTAIN_ASPECT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_PLANNED_USAGE | MTH_ENTITY_PLANNED_USAGE_ERR | USAGE_UOM | Value was not provided for column USAGE_UOM or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | BFC | Invalid value was provided for BUSINESS_FUNCTION. |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | DUP | Multiple records were found leading to the same value or combination of ENTITY_FK_KEY, EFFECTIVE_DATE in target table. |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | DUP | Multiple records were found leading to the same value or combination of ENTITY_FK_KEY, EFFECTIVE_DATE in target table. |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | DUP | Multiple records were found leading to the same value or combination of ENTITY_PK in target table. |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | EFD | Invalid value was provided for EFFECTIVE_DATE. |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | EFFECTIVE_DATE | Value was not provided for column EFFECTIVE_DATE or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | EFFECTIVE_DATE | Value was not provided for column EFFECTIVE_DATE or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | ENTITY_FK_KEY | Value was not provided for column ENTITY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ENTITY_ATTRIBUTES | MTH_EQUIP_ENTITIES_ERR | ENTITY_FK_KEY | Value was not provided for column ENTITY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | ENTITY_NAME | Value was not provided for column ENTITY_NAME or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | ENTITY_PK | Value was not provided for column ENTITY_PK or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | ENTITY_TYPE | Value was not provided for column ENTITY_TYPE or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | PRODUCTION_ENTITY | Value was not provided for column PRODUCTION_ENTITY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_ENTITIES_MST | MTH_EQUIP_ENTITIES_ERR | STATUS | Value was not provided for column STATUS or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | DUP | Multiple records were found leading to the same value or combination of HIERARCHY_ID, LEVEL_FK_KEY, EFFECTIVE_DATE in target table. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Hry_Effective_Date | Invalid value was provided for EFFECTIVE_DATE. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | HRY_ID | Invalid value was provided for HIERARCHY_NAME. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | HRY_Level_FK | Invalid value was provided for LEVEL_FK. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | HRY_Parent_FK | Invalid value was provided for PARENT_FK. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level02 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level03 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level04 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level05 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level06 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level07 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level08 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level09 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_HIERARCHY | MTH_EQUIP_HIERARCHY_ERR | Level10 | Hierarchy information for the parent is not fully available. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | DOP | Output information for the provided READING_TIME already exists for the provided equipment. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | DUP | Multiple records were found for the same combination of EQUIPMENT_FK, SHIFT_WORKDAY_FK, READING_TIME, ITEM_FK, WORKORDER_FK, SEGMENT_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | EQP | Value was not provided for column EQUIPMENT_PK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | FTD | READING_TIME is in future. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | IEQ | Equipment is not active. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | ITM | Invalid value was provided for ITEM_FK |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | ITR | READING_TIME does not fall in a shift for the provided equipment. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | NWDS | Value was not provided for SHIFT_WORKDAY_FK |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | SEG | Invalid value was provided for SEGMENT_FK |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | SPR | SCRAP_REASON_CODE was provided when not expected or the value provided is invalid. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | WDS | Invalid value was provided for SHIFT_WORKDAY_FK |
MTH_EQUIP_OUTPUT | MTH_EQUIP_OUTPUT_ERR | WKO | Invalid value was provided for WORKORDER_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | DTE | SCHEDULE_TO_DATE is less than or equal to SCHEDULE_FROM_DATE. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | DUP | Multiple records were found leading to the same value or combination of EQUIP_SCHEDULE_PK in target table. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | EQUIP_SCHEDULE_PK | Value was not provided for column EQUIP_SCHEDULE_PK or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | EQUIPMENT_FK_KEY | Value was not provided for column EQUIPMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | ITM | Invalid value was provided for ITEM_FK |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | OCSV | Schedule is overlapping with another record in staging. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | OEPS | Schedule is overlapping with an existing schedule. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | OSB | From and To dates provided are outside shift boundaries. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | SCHEDULE_FROM_DATE | Value was not provided for column SCHEDULE_FROM_DATE or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | SCHEDULE_TO_DATE | Value was not provided for column SCHEDULE_TO_DATE or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | WDS | Invalid value was provided for SHIFT_WORKDAY_FK. |
MTH_EQUIP_PROD_SCHEDULE_F | MTH_EQUIP_PROD_SCHEDULE_ERR | WKO | Invalid value was provided for WORKORDER_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | DUP | Multiple records were found leading to the same value or combination of EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, ITEM_FK_KEY in target table. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | EQUIPMENT_FK_KEY | Value was not provided for column EQUIPMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | ITM | Invalid value was provided for ITEM_FK |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_EQUIP_STANDARD_RATES_F | MTH_EQUIP_STANDARD_RATES_ERR | WDS | Invalid value was provided for SHIFT_WORKDAY_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | DTR | DOWNTIME_REASON_CODE was provided when not expected or the value provided is not a valid downtime reason. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | DUP | Multiple records were found for the same combination of EQUIPMENT_FK, SHIFT_WORKDAY_FK, FROM_DATE, TO_DATE. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | EQP | Value was not provided for column EQUIPMENT_PK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | ESD | Shift information specific to equipment is unavailable. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | FTD | FROM_DATE are TO_DATE are in future. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | GAP | Current status entry or an earlier status entry has a gap with respect to its previous status entry. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | IDR | Invalid idle reason was provided in DOWNTIME_REASON_CODE. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | IEQ | Equipment is not active. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | ITR | FROM_DATE and TO_DATE do not fall in a shift for the provided equipment. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | MSF | Status entry spans across multiple shifts. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | OCSV | Status entry overlaps with another entry in staging table. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | OSTS | Status entry overlaps with an existing status entry. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | STS | Invalid value was provided for STATUS. Valid values are 1, 2, 3 and 4. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | WDS | Invalid value was provided for SHIFT_WORKDAY_FK |
MTH_EQUIP_STATUSES | MTH_EQUIP_STATUSES_ERR | WRC | Invalid value was provided for DOWNTIME_REASON_CODE. |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | DUP | Multiple records were found leading to the same value or combination of EQUIPMENT_FK_KEY, REASON_CODE, REASON_TYPE in target table. |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | EQUIPMENT_FK_KEY | Value was not provided for column EQUIPMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | ERT | Invalid value was provided for REASON_TYPE. |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | EUT | EXPECTED_UP_TIME was provided for REASON_TYPE other than 2. |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | REASON_CODE | Value was not provided for column REASON_CODE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_REASON_SETUP | MTH_EQUIPMENT_REASON_SETUP_ERR | REASON_TYPE | Value was not provided for column REASON_TYPE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | AVAILABILITY_DATE | Value was not provided for column AVAILABILITY_DATE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | AVAILABILITY_FLAG | Value was not provided for column AVAILABILITY_FLAG or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | DTE | TO_DATE is less than or equal to FROM_DATE. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | DUP | Multiple records were found leading to the same value or combination of EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, LINE_NUM, ENTITY_TYPE in target table. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | ENTITY_TYPE | Value was not provided for column ENTITY_TYPE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | EQUIPMENT_FK_KEY | Value was not provided for column EQUIPMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | FROM_DATE | Value was not provided for column FROM_DATE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | LINE_NUM | Value was not provided for column LINE_NUM or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | OCSV | Shift is overlapping with another record in staging. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | OESD | Shift is overlapping with an existing schedule. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | PRF | Profile MTH: Shifts Setup has been set as MOC. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | RCD | Invalid value was provided for REASON. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | RSN | REASON was provided for a shift marked as available. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | SAE | Transactions already exist for a duration equal to or later than the one for which shifts are getting loaded. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | SDT | FROM_DATE and TO_DATE are same. |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | SHIFT_WORKDAY_FK_KEY | Value was not provided for column SHIFT_WORKDAY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENT_SHIFTS_D | MTH_EQUIPMENT_SHIFTS_ERR | TO_DATE | Value was not provided for column TO_DATE or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | CRI | Invalid value was provided for EQUIPMENT_CRITICALITY. |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | DUP | Multiple records were found leading to the same value or combination of EQUIPMENT_PK in target table. |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | EQUIPMENT_NAME | Value was not provided for column EQUIPMENT_NAME or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | EQUIPMENT_PK | Value was not provided for column EQUIPMENT_PK or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | PRODUCTION_EQUIPMENT | Value was not provided for column PRODUCTION_EQUIPMENT or the value provided for corresponding staging table column was invalid |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | SNF | SERIAL_NUMBER provided is already used for another equipment. |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | SNS | Multiple records were found leading to the same value or combination of SERIAL_NUMBER in target table. |
MTH_EQUIPMENTS_D | MTH_EQUIPMENTS_ERR | STATUS | Value was not provided for column STATUS or the value provided for corresponding staging table column was invalid |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | ACTION_TYPE_CODE | Value was not provided for column ACTION_TYPE_CODE or the value provided for corresponding staging table column was invalid |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | AHC | ACTION_HANDLER_CODE was not provided. For ACTION_TYPE_CODE as PLSQL_API and BPEL it is mandatory. |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | DOM | MOBILE_NOTIFICATION was Y but the value provided for DOMAIN_NAME is invalid. |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | DUP | Multiple records were found leading to the same value or combination of EVENT_SETUP_ID, ACTION_TYPE_CODE, PERSONNEL_FK_KEY in target table. |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | EQP | Invalid value was provided for EQUIPMENT_FK. |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | EQUIPMENT_FK_KEY | Value was not provided for column EQUIPMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | EVENT_SETUP_ID | Value was not provided for column EVENT_SETUP_ID or the value provided for corresponding staging table column was invalid |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | EVENT_TYPE_CODE | Value was not provided for column EVENT_TYPE_CODE or the value provided for corresponding staging table column was invalid |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | NTN | NOTIFICATION was Y but valid notification details are not provided. |
MTH_EVENT_ACTION_SETUP | MTH_EVENT_ACTION_SETUP_ERR | PER | Invalid value was provided for PERSONNEL_FK. |
MTH_EVENT_SETUP_TMP | MTH_EVENT_ACTION_SETUP_ERR | RCS | Invalid value was provided for REASON_CODE. |
MTH_ITEM_CATEGORIES_D | MTH_ITEM_CATEGORIES_ERR | CATEGORY_NAME | Value was not provided for column CATEGORY_NAME or the value provided for corresponding staging table column was invalid |
MTH_ITEM_CATEGORIES_D | MTH_ITEM_CATEGORIES_ERR | CATEGORY_PK | Value was not provided for column CATEGORY_PK or the value provided for corresponding staging table column was invalid |
MTH_ITEM_CATEGORIES_D | MTH_ITEM_CATEGORIES_ERR | DUP | Multiple records were found leading to the same value or combination of CATEGORY_PK in target table. |
MTH_ITEM_COST | MTH_ITEM_COST_ERR | COST | Value was not provided for column COST or the value provided for corresponding staging table column was invalid |
MTH_ITEM_COST | MTH_ITEM_COST_ERR | DUP | Multiple records were found leading to the same value or combination of COST_ELEMENT, ITEM_FK_KEY in target table. |
MTH_ITEM_COST | MTH_ITEM_COST_ERR | FROM_DATE | Value was not provided for column FROM_DATE or the value provided for corresponding staging table column was invalid |
MTH_ITEM_COST | MTH_ITEM_COST_ERR | ISCURRENT | Value was not provided for column ISCURRENT or the value provided for corresponding staging table column was invalid |
MTH_ITEM_COST | MTH_ITEM_COST_ERR | ITEM_FK_KEY | Value was not provided for column ITEM_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ITEM_HIERARCHY | MTH_ITEM_HIERARCHY_ERR | DUP | Multiple records were found leading to the same value or combination of LEVEL_FK_KEY, HIERARCHY_ID in target table. |
MTH_ITEM_HIERARCHY | MTH_ITEM_HIERARCHY_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_ITEM_HIERARCHY | MTH_ITEM_HIERARCHY_ERR | LEVEL_FK_KEY | Value was not provided for column LEVEL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ITEM_HIERARCHY | MTH_ITEM_HIERARCHY_ERR | PARENT_FK_KEY | Value was not provided for column PARENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ITEMS_D | MTH_ITEMS_ERR | DUP | Multiple records were found leading to the same value or combination of ITEM_PK in target table. |
MTH_ITEMS_D | MTH_ITEMS_ERR | ITEM_NAME | Value was not provided for column ITEM_NAME or the value provided for corresponding staging table column was invalid |
MTH_ITEMS_D | MTH_ITEMS_ERR | ITEM_PK | Value was not provided for column ITEM_PK or the value provided for corresponding staging table column was invalid |
MTH_ITEMS_D | MTH_ITEMS_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_ITEMS_D | MTH_ITEMS_ERR | PRIMARY_UOM | Value was not provided for column PRIMARY_UOM or the value provided for corresponding staging table column was invalid |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | DTE | TO_TIME is less than or equal to FROM_TIME. |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | DUP | Multiple records were found leading to the same value or combination of METER_FK_KEY, FROM_TIME, TO_TIME in target table. |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | FROM_TIME | Value was not provided for column FROM_TIME or the value provided for corresponding staging table column was invalid |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | FTD | FROM_TIME or TO_TIME are in future. |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | METER_FK_KEY | Value was not provided for column METER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | NGV | USAGE_VALUE is negative. |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | OLP | Meter readings are overlapping. |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | TO_TIME | Value was not provided for column TO_TIME or the value provided for corresponding staging table column was invalid |
MTH_METER_READINGS | MTH_METER_READINGS_ERR | USAGE_VALUE | Value was not provided for column USAGE_VALUE or the value provided for corresponding staging table column was invalid |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | DUP | Multiple records were found leading to the same value or combination of PRODUCT_LOT, PRODUCT_SERIAL_NO, PRODUCT_SUBLOT, MATERIAL_LOT, MATERIAL_SUBLOT, MATERIAL_SERIAL_NO, WO_MAT_TXN_FK_KEY in target table. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_MTL_CONSUMED_TXN_LOT_F | MTH_MTL_CONSUMED_TXN_LOT_ERR | WO_MAT_TXN_FK_KEY | Value was not provided for column WO_MAT_TXN_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | DUP | Multiple records were found leading to the same value or combination of WO_COMP_FK_KEY, PRODUCT_LOT, PRODUCT_SERIAL_NO, PRODUCT_SUBLOT in target table. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_MTL_PRODUCED_TXN_LOT_F | MTH_MTL_PRODUCED_TXN_LOT_ERR | WO_COMP_FK_KEY | Value was not provided for column WO_COMP_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PERIOD_D | MTH_PERIOD_ERR | GAP | Record has a gap with respect to previous entry. |
MTH_PERIOD_D | MTH_PERIOD_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_PERIOD_D | MTH_PERIOD_ERR | NAME | Value was not provided for column NAME or the value provided for corresponding staging table column was invalid |
MTH_PERIOD_D | MTH_PERIOD_ERR | OVP | Record overlaps with another entry. |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | DUP | Multiple records were found leading to the same value or combination of PERSONNEL_PK in target table. |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | FIRST_NAME | Value was not provided for column FIRST_NAME or the value provided for corresponding staging table column was invalid |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | LAST_NAME | Value was not provided for column LAST_NAME or the value provided for corresponding staging table column was invalid |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | PERSONNEL_PK | Value was not provided for column PERSONNEL_PK or the value provided for corresponding staging table column was invalid |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PERSONNEL_D | MTH_PERSONNEL_ERR | RES | Invalid value was provided for RESOURCE_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | DUP | Multiple records were found leading to the same value or combination of WO_MAT_REQ_PK in target table. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | ITM | Invalid value was provided for PRODUCT_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | MATERIAL_FK_KEY | Value was not provided for column MATERIAL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | WO_MAT_REQ_PK | Value was not provided for column WO_MAT_REQ_PK or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_F | MTH_PROD_MTL_CONSUMED_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | DUP | Multiple records were found leading to the same value or combination of WO_MAT_TXN_PK in target table. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | ITM | Invalid value was provided for PRODUCT_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | MATERIAL_FK_KEY | Value was not provided for column MATERIAL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | SHIFT_WORKDAY_FK_KEY | Value was not provided for column SHIFT_WORKDAY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | TRANSACTION_DATE | Value was not provided for column TRANSACTION_DATE or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | WO_MAT_TXN_PK | Value was not provided for column WO_MAT_TXN_PK or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_CONSUMED_TXN_F | MTH_PROD_MTL_CONSUMED_TXN_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | DUP | Multiple records were found leading to the same value or combination of WORKORDER_FK_KEY, ITEM_FK_KEY in target table. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | FLC | Invalid value was provided for ITEM_TYPE_CODE |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | ITEM_FK_KEY | Value was not provided for column ITEM_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | ITM | Invalid value was provided for ITEM_FK |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | WKO | Invalid value was provided for WORKORDER_FK. |
MTH_PROD_MTL_PRODUCED_F | MTH_PROD_MTL_PRODUCED_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | DUP | Multiple records were found leading to the same value or combination of WO_COMP_PK in target table. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | ITEM_FK_KEY | Value was not provided for column ITEM_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | SHIFT_WORKDAY_FK_KEY | Value was not provided for column SHIFT_WORKDAY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | TRANSACTION_DATE | Value was not provided for column TRANSACTION_DATE or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | TRANSACTION_TYPE | Value was not provided for column TRANSACTION_TYPE or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | WO_COMP_PK | Value was not provided for column WO_COMP_PK or the value provided for corresponding staging table column was invalid |
MTH_PROD_MTL_PRODUCED_TXN_F | MTH_PROD_MTL_PRODUCED_TXN_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | DUP | Multiple records were found leading to the same value or combination of WORKORDER_FK_KEY, FROM_STEP_TYPE, ITEM_FK_KEY, SUB_SEGMENT_FK_KEY, TO_STEP_TYPE, TRANSACTION_DATE, TO_SEGMENT_FK_KEY, FROM_SEGMENT_FK_KEY in target table. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | FROM_SEGMENT_FK_KEY | Value was not provided for column FROM_SEGMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | ITEM_FK_KEY | Value was not provided for column ITEM_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | SHIFT_WORKDAY_FK_KEY | Value was not provided for column SHIFT_WORKDAY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | SSG | Invalid value was provided for SUB_SEGMENT_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | TO_SEGMENT_FK_KEY | Value was not provided for column TO_SEGMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | TRANSACTION_DATE | Value was not provided for column TRANSACTION_DATE or the value provided for corresponding staging table column was invalid |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PROD_SEGMENTS_TXN_F | MTH_PROD_SEGMENTS_TXN_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SUB_SEGMENTS_F | MTH_PROD_SUB_SEGMENTS_ERR | DUP | Multiple records were found leading to the same value or combination of SUB_SEGMENT_PK in target table. |
MTH_PROD_SUB_SEGMENTS_F | MTH_PROD_SUB_SEGMENTS_ERR | SEGMENT_FK_KEY | Value was not provided for column SEGMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PROD_SUB_SEGMENTS_F | MTH_PROD_SUB_SEGMENTS_ERR | SUB_SEGMENT_PK | Value was not provided for column SUB_SEGMENT_PK or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | DUP | Multiple records were found leading to the same value or combination of WORKORDER_PK in target table. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | STATUS_CODE | Value was not provided for column STATUS_CODE or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | WORKORDER_PK | Value was not provided for column WORKORDER_PK or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SCHEDULES_F | MTH_PRODUCTION_SCHEDULES_ERR | WORKORDER_TYPE | Value was not provided for column WORKORDER_TYPE or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | DUP | Multiple records were found leading to the same value or combination of SEGMENT_PK in target table. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | ITM | Invalid value was provided for ITEM_FK |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | SEGMENT_PK | Value was not provided for column SEGMENT_PK or the value provided for corresponding staging table column was invalid |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_PRODUCTION_SEGMENTS_F | MTH_PRODUCTION_SEGMENTS_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_QUARTER_D | MTH_QUARTER_ERR | GAP | Record has a gap with respect to previous entry. |
MTH_QUARTER_D | MTH_QUARTER_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_QUARTER_D | MTH_QUARTER_ERR | NAME | Value was not provided for column NAME or the value provided for corresponding staging table column was invalid |
MTH_QUARTER_D | MTH_QUARTER_ERR | OVP | Record overlaps with another entry. |
MTH_RESOURCE_COST | MTH_RESOURCE_COST_ERR | COST | Value was not provided for column COST or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_COST | MTH_RESOURCE_COST_ERR | DUP | Multiple records were found leading to the same value or combination of RESOURCE_FK_KEY, COST_ELEMENT in target table. |
MTH_RESOURCE_COST | MTH_RESOURCE_COST_ERR | ISCURRENT | Value was not provided for column ISCURRENT or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_COST | MTH_RESOURCE_COST_ERR | RESOURCE_FK_KEY | Value was not provided for column RESOURCE_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | DUP | Multiple records were found leading to the same value or combination of PLANT_FK_KEY, PRODUCT_FK_KEY, RESOURCE_FK_KEY, SEGMENT_FK_KEY, WORKORDER_FK_KEY in target table. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | ITM | Invalid value was provided for PRODUCT_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | RESOURCE_FK_KEY | Value was not provided for column RESOURCE_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | SEGMENT_FK_KEY | Value was not provided for column SEGMENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | SSG | Invalid value was provided for SUB_SEGMENT_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_RESOURCE_REQUIREMENTS_F | MTH_RESOURCE_REQUIREMENTS_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | DUP | Multiple records were found leading to the same value or combination of PLANT_FK_KEY, PRODUCT_FK_KEY, RESOURCE_FK_KEY, SEGMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, TRANSACTION_DATE, WORKORDER_FK_KEY in target table. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | ITM | Invalid value was provided for PRODUCT_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | RESOURCE_FK_KEY | Value was not provided for column RESOURCE_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | SHIFT_WORKDAY_FK_KEY | Value was not provided for column SHIFT_WORKDAY_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | SSG | Invalid value was provided for SUB_SEGMENT_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | TRANSACTION_DATE | Value was not provided for column TRANSACTION_DATE or the value provided for corresponding staging table column was invalid |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_RESOURCE_TXN_F | MTH_RESOURCE_TXN_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | BFC | Invalid value was provided for BUSINESS_FUNCTION. |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | DUP | Multiple records were found leading to the same value or combination of RESOURCE_PK in target table. |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | PLANT_FK_KEY | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | PRODUCTION_RESOURCE | Value was not provided for column PRODUCTION_RESOURCE or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | RESOURCE_NAME | Value was not provided for column RESOURCE_NAME or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | RESOURCE_PK | Value was not provided for column RESOURCE_PK or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | RESOURCE_TYPE | Value was not provided for column RESOURCE_TYPE or the value provided for corresponding staging table column was invalid |
MTH_RESOURCES_D | MTH_RESOURCES_ERR | STATUS | Value was not provided for column STATUS or the value provided for corresponding staging table column was invalid |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | DAT | Invalid value was provided for DATA_TYPE. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | DATA_TYPE | Value was not provided for column DATA_TYPE or the value provided for corresponding staging table column was invalid |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | DTC | Relevant details for alphanumeric data type were not provided. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | DUP | Multiple records were found leading to the same value or combination of TAG_CODE in target table. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | NFQ | FREQUENCY_IN_MINUTES has been provided for TAG_TYPE as OPERATION. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | NRC | READING_TYPE has been not provided for numeric data type. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | ORT | Invalid value was provided for ORDER_TYPE. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | RED | Invalid value was provided for READING_TYPE. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | STS | Invalid value was provided for STATUS. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | TAG_CODE | Value was not provided for column TAG_CODE or the value provided for corresponding staging table column was invalid |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | TAG_DATA_SOURCE_FK_KEY | Value was not provided for column TAG_DATA_SOURCE_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | USI | Relevant details for incremental reading type were not provided. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | WFQ | FREQUENCY_IN_MINUTES is negative. |
MTH_TAG_MASTER | MTH_TAG_MASTER_ERR | WSC | Relevant details for cumulative reading type were not provided. |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | DUP | Multiple records were found leading to the same value or combination of HIERARCHY_ID, LEVEL_FK_KEY in target table. |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | LEVEL_FK_KEY | Value was not provided for column LEVEL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | LEVEL_FK_KEY | Value was not provided for column LEVEL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | LEVEL_NUM | Value was not provided for column LEVEL_NUM or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | LEVEL_NUM | Value was not provided for column LEVEL_NUM or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | PARENT_FK_KEY | Value was not provided for column PARENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_TIME_HIERARCHY | MTH_TIME_HIERARCHY_ERR | PARENT_FK_KEY | Value was not provided for column PARENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_ENTITIES_MST | MTH_USER_DIM_ENTITIES_ERR | DIMENSION_ID | Value was not provided for column DIMENSION_ID or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_ENTITIES_MST | MTH_USER_DIM_ENTITIES_ERR | DUP | Multiple records were found leading to the same value or combination of ENTITY_PK in target table. |
MTH_USER_DIM_ENTITIES_MST | MTH_USER_DIM_ENTITIES_ERR | ENTITY_NAME | Value was not provided for column ENTITY_NAME or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_ENTITIES_MST | MTH_USER_DIM_ENTITIES_ERR | ENTITY_PK | Value was not provided for column ENTITY_PK or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_ENTITIES_MST | MTH_USER_DIM_ENTITIES_ERR | ENTITY_TYPE | Value was not provided for column ENTITY_TYPE or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | DIMENSION_ID | Value was not provided for column DIMENSION_ID or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | DUP | Multiple records were found leading to the same value or combination of LEVEL_FK_KEY, HIERARCHY_ID in target table. |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | LEVEL_FK_KEY | Value was not provided for column LEVEL_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | LEVEL_NUM | Value was not provided for column LEVEL_NUM or the value provided for corresponding staging table column was invalid |
MTH_USER_DIM_HIERARCHY | MTH_USER_DIM_HIERARCHY_ERR | PARENT_FK_KEY | Value was not provided for column PARENT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_WEEK_D | MTH_WEEK_ERR | GAP | Record has a gap with respect to previous entry. |
MTH_WEEK_D | MTH_WEEK_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_WEEK_D | MTH_WEEK_ERR | NAME | Value was not provided for column NAME or the value provided for corresponding staging table column was invalid |
MTH_WEEK_D | MTH_WEEK_ERR | OVP | Record overlaps with another entry. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | DUP | Multiple records were found leading to the same value or combination of RESERVATION_PK in target table. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | ITM | Invalid value was provided for PRODUCT_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | RESERVATION_PK | Value was not provided for column RESERVATION_PK or the value provided for corresponding staging table column was invalid |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | SALESORDER_LNUMBER | Value was not provided for column SALESORDER_LNUMBER or the value provided for corresponding staging table column was invalid |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | SALESORDER_NUMBER | Value was not provided for column SALESORDER_NUMBER or the value provided for corresponding staging table column was invalid |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | UD1 | Invalid value was provided for USER_DIM1_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | UD2 | Invalid value was provided for USER_DIM2_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | UD3 | Invalid value was provided for USER_DIM3_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | UD4 | Invalid value was provided for USER_DIM4_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | UD5 | Invalid value was provided for USER_DIM5_FK. |
MTH_WO_SALES_ORDERS_F | MTH_WO_SALES_ORDERS_ERR | WORKORDER_FK_KEY | Value was not provided for column WORKORDER_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | DTE | TO_DATE is less than or equal to FROM_DATE. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | DUP | Multiple records were found leading to the same value or combination of SHIFT_WORKDAY_PK in target table. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | GRA | Invalid value was provided for GRAVEYARD_SHIFT. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | NFD | Value was not provided for column FROM_DATE or the value provided for corresponding staging table column was invalid |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | NTD | Value was not provided for column TO_DATE or the value provided for corresponding staging table column was invalid |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | OVP | Shift is overlapping with another shift. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | PLT | Value was not provided for column PLANT_FK_KEY or the value provided for corresponding staging table column was invalid |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | PRF | Profile MTH: Shifts Setup has been set as MOC. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | SAE | Transactions already exist for a duration equal to or later than the one for which shifts are getting loaded. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | SDT | FROM_DATE and TO_DATE are same. |
MTH_WORKDAY_SHIFTS_D | MTH_WORKDAY_SHIFTS_ERR | SFT | Invalid value was provided for SHIFT_TYPE. |
MTH_YEAR_D | MTH_YEAR_ERR | GAP | Record has a gap with respect to previous entry. |
MTH_YEAR_D | MTH_YEAR_ERR | HIERARCHY_ID | Value was not provided for column HIERARCHY_ID or the value provided for corresponding staging table column was invalid |
MTH_YEAR_D | MTH_YEAR_ERR | NAME | Value was not provided for column NAME or the value provided for corresponding staging table column was invalid |
MTH_YEAR_D | MTH_YEAR_ERR | OVP | Record overlaps with another entry. |
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ODI Scenarios | |||||||||||||||||||||||||
MTH_PKG_WORKDAY_SHIFTS_EXT | 1 | ||||||||||||||||||||||||
MTH_PKG_WORKDAY_SHIFTS_SRC | 1 | ||||||||||||||||||||||||
MTH_PKG_EQUIPMENT_PROD_SCHEDULE_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_EQUIPMENT_HIERARCHY_EXT | 3 | 7 | 4 | 8 | 1 | 5 | 2 | 6 | |||||||||||||||||
MTH_PKG_EQUIPMENT_HIERARCHY_SRC | 3 | 7 | 4 | 8 | 1 | 5 | 2 | 6 | |||||||||||||||||
MTH_PKG_POPULATE_EQUIPMENT_DENORM | 3 | 7 | 4 | 8 | 1 | 5 | 2 | 6 | |||||||||||||||||
MTH_PKG_ITEM_HIERARCHY_EXT | 1 | 3 | 2 | 4 | 5 | 9 | 6 | 10 | 7 | 11 | 8 | 12 | |||||||||||||
MTH_PKG_EQUIPMENT_SHIFTS_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_EQUIPMENT_SHIFTS_SRC | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_MTL_PRODUCED_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_MTL_PRODUCED_SRC | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_MTL_CONSUMED_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_RESOURCE_REQUIREMENTS_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_RESOURCE_TXN_EXT | 1 | 2 | |||||||||||||||||||||||
MTH_PKG_ITEM_COST_SRC | |||||||||||||||||||||||||
MTH_PKG_ITEM_COST_EXT | |||||||||||||||||||||||||
MTH_PKG_RESOURCE_COST_SRC | |||||||||||||||||||||||||
MTH_PKG_RESOURCE_COST_EXT | |||||||||||||||||||||||||
MTH_PKG_EQUIPMENT_ENTITIES_EXT | 1 | ||||||||||||||||||||||||
MTH_PKG_EQUIPMENT_ENTITIES_SRC | 1 | ||||||||||||||||||||||||
MTH_PKG_RESOURCES_SRC | 1 | ||||||||||||||||||||||||
MTH_PKG_RESOURCES_EXT | 1 | ||||||||||||||||||||||||
MTH_PKG_EQUIPMENT_EXT | 1 | ||||||||||||||||||||||||
MTH_PKG_ENTITY_PLANNED_USAGE_EXT | 1 | 2 | 3 | ||||||||||||||||||||||
Concurrent Programs | |||||||||||||||||||||||||
MTH: Populate MOC Gregorian Calendar | 2 | 6 | 3 | 7 | 4 | 8 | 5 | 9 | 1 | ||||||||||||||||
MTH: Process Transactions | 2 | 4 | 1 | 3 | |||||||||||||||||||||
MTH: Reprocess Transactions | 2 | 4 | 1 | 3 | |||||||||||||||||||||
MTH: Populate 445/544 Calendar | 1 | ||||||||||||||||||||||||
User Steps | |||||||||||||||||||||||||
Shift Exceptions | 1 | 2 | |||||||||||||||||||||||
Define Plant, Equipment Entities, Resources, Equipments | 1 | ||||||||||||||||||||||||
Site Sustainabilities | 1 | 1 | |||||||||||||||||||||||
Generate Shifts | 2 | 3 | 1 |
Key to the Column Headers
MTH_445_PERIOD_CAL_HOUR_MV
MTH_ALL_ENTITIES_MV
MTH_ENTITY_PLANNED_USAGE_HR_MV
MTH_ENTITY_PLANNED_USAGE_MV
MTH_ENTITY_PLANNED_USAGE_SM_MV
MTH_EQUIP_OP_SUM_DD_MV
MTH_EQUIP_OP_SUM_PM_MV
MTH_EQUIP_PROD_SCH_DD_MV
MTH_EQUIP_PROD_SCH_PM_MV
MTH_EQUIP_SHFT_DD_MV
MTH_EQUIP_SHFT_PM_MV
MTH_EQUIP_ST_SUM_DD_MV
MTH_EQUIP_ST_SUM_PM_MV
MTH_ITEM_COST_MV
MTH_MTL_CONS_IT_MV
MTH_MTL_CONS_LT_MV
MTH_MTL_PROD_IT_MV
MTH_MTL_PROD_LT_MV
MTH_RES_REQ_IT_MV
MTH_RES_REQ_LT_MV
MTH_RES_TXN_IT_MV
MTH_RES_TXN_LT_MV
MTH_RESOURCE_COST_MV
MTH_SHIFT_GREGORIAN_DENORM_MV
MTH_SHIFT_REFERENCE_MV
Tag mapping associates a tag with an MTH entity (status, output) or an extensible attribute. The Tag Mapping ETL collects the mapping between the tags and MTH entities from file data source to staging, and to fact table.
Error Code | Description | Reference Physical Column | Error Condition | Description |
---|---|---|---|---|
DUP | Duplicate rows | Duplicate rows | Multiple records were found leading to the same value or combination of PLANT_CODE, EQUIPMENT_PK, TAG_CODE, DATA_ELEMENT, ATTRIBUTE_GROUP, ATTRIBUTE in the target table. | |
EQP | Missing Equipment Reference | EQUIPMENT_PK | Referential Integrity | Value was not provided for column EQUIPMENT_PK or the value provided for corresponding staging table column did not match with Equipment PK from MTH_EQUIPMENTS_D table. |
TAG_CODE | Missing Tag Reference | TAG_CODE | Referential Integrity | Value was not provided for column TAG_CODE or the value provided for the corresponding staging table column was invalid. |
TMT | Tag Mapping Type | The tag was mapped to the internal data elements as well as extensible attribute. It can only be done to either of these. | ||
DUPT | Duplicate Tag Code | Referential Integrity | The tag was already mapped to an equipment. | |
WREQ | Required workorder context | Workorder context not provided (if mandatory) | ||
SREQ | Required segment context | Segment context not provided (if mandatory) | ||
IREQ | Required item context | Item context not provided (if mandatory) | ||
STDR | Missing Standard Rate | STANDARD_RATE1 | Referential Integrity | Value was not provided for column STANDARD_RATE1 |
TXN | Transactions exist | Equipment status or output transactions exist for the workday shifts provided in the standard rate date ranges |