Error Management
Managing Error Records
The Manufacturing Operations Center acts as an integration layer connecting plant floor systems and synchronizing with the ERP systems. In order to accomplish this, MOC needs to interact and collect data from different source systems at different frequencies. During this process, records collected for an entity where the data is dependent on another entity, can result in:
-
Required data is not yet collected
-
Mandatory columns without the provided data
-
Duplicate records passed in the data load
These rows are identified and staged into a separate table; the table is populated with reason codes for those errors. These records need to be corrected and reprocessed, or deleted. You can use an application such as Oracle Express for correcting the records in error table. The following graphic displays the error processing logic of moving the from the Staging to Fact tables if any of the rows are effected because of the these reasons. They are moved into Error table. After correcting the data in Error table or the reference data source, enable reprocessing flag. The data then moves back to the Staging table and again starts verification.
Error Codes
The following table lists error codes, descriptions, column references, and types.
| Error Code | Description | Reference Physical Column | Error Type |
|---|---|---|---|
| CAT | Missing category reference | CATEGORY_FK | Referential Integrity |
| DIM | Missing dimension Reference | DIMENSION_NAME | Referential Integrity |
| DTR | Invalid downtime reason code or the status is not down | STATUS, DOWNTIME_REASON_CODE | Referential Integrity |
| DUP | Duplicate rows | Duplicate rows | Duplicate rows |
| ENT | Missing equipment or user dimension entity reference | ENTITY_FK | Referential Integrity |
| EQP | Missing equipment reference | EQUIPMENT_FK | Referential Integrity |
| ESD | Missing reference record in the MTH_EQUIPMENT_SHIFTS_D table | N/A | Referential Integrity |
| FLC | Missing FND lookup code | MATERIAL_FK STATUS (WO Status) | Referential Integrity |
| ITM | Missing item or product reference | ITEM_FK | Referential Integrity |
| HRY | Missing hierarchy reference | HIERARCHY_NAME | Referential Integrity |
| LFK | Missing level reference for time, item, equipment and user dimensions | LEVEL_FK | Referential Integrity |
| MCT | Missing Material Consumed Transaction reference | WO_MAT_TXN_PK_KEY | Referential Integrity |
| MLC | Missing MTH lookup code | N/A | Referential Integrity |
| MPT | Missing Material Produced Transaction reference | WO_COMP_PK_KEY | Referential Integrity |
| MTL | Missing material reference | MATERIAL_FK | Referential Integrity |
| PFK | Missing parent reference for time, item, equipment and user dimensions | PARENT_FK | Referential Integrity |
| PLT | Missing plant reference | PLANT_FK | Referential Integrity |
| RES | Missing resource reference | RESOURCE_FK | Referential Integrity |
| SEG | Missing segment reference | SEGMENT_FK | Referential Integrity |
| SPR | Invalid scrap reason code or no scrap quantity | QTY_SCRAP, SCRAP_REASON_CODE | Referential Integrity |
| SSG | Missing sub segment reference | SUB_SEGMENT_FK_KEY | 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 |
| WDS | Missing workday shift reference | SHIFT_WORKDAY_FK | Referential Integrity |
| WKO | Missing work order reference | WORKORDER_FK | Referential Integrity |
| ENT | Missing Equipment dimension Entity reference or user dimension entity reference | ENTITY_FK | Referential Integrity |
| MPT | Missing Material Produced Transaction reference | WO_COMP_PK_KEY | 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 nul | 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 | N/A | 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 | Not required setting for incremental tags, including INITIAL_VALUE, MAX_RESET_VALUE, ORDER_TYPE_CODE, and READING_TYPE_CODE | N/A | 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_MINUTE | N/A | 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 | N/A | 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 |
The following list shows the error tables provided in MOC:
| Table Name | Description of Error Table |
|---|---|
| MTH_DIM_HIERARCHY_ERR | Error table for MTH_DIM_HIERARCHY |
| MTH_DIM_LEVEL_LOOKUP_ERR | Dimension level lookup entity |
| MTH_ENTITY_PLANNED_USAGE_ERR | Error table for MTH_ENTITY_PLANNED_USAGE |
| MTH_EQUIPMENTS_ERR | Equipment entity |
| MTH_EQUIP_ENTITIES_ERR | Error table for MTH_EQUIP_ENTITIES_MST |
| MTH_EQUIP_HIERARCHY_ERR | Equipment hierarchy entity |
| MTH_EQUIPMENT_SHIFTS_ERR | Error table for MTH_EQUIPMENT_SHIFTS_D |
| MTH_EQUIP_OUTPUT_ERR | Equipment output fact |
| MTH_EQUIP_PROD_PERFORMANCE_ERR | Equipment production performance fact |
| MTH_EQUIP_PROD_SCHEDULE_ERR | Equipment production schedule entity |
| MTH_EQUIP_STANDARD_RATES_ERR | Equipment standard rates entity |
| MTH_EQUIP_STATUSES_ERR | Equipment status fact |
| MTH_EXT_ATTR_ERR | Extensible attributes fact |
| MTH_ITEMS_ERR | Item dimension |
| MTH_ITEM_COST_ERR | Item cost fact |
| MTH_ITEM_HIERARCHY_ERR | Item hierarchy table |
| MTH_METER_READINGS_ERR | Error table for MTH_METER_READINGS |
| MTH_MTL_CONSUMED_TXN_LOT_ERR | Material consumed transaction lot fact |
| MTH_MTL_PRODUCED_TXN_LOT_ERR | Material produced transaction lot fact |
| MTH_PERIOD_ERR | Period entity |
| MTH_PERSONNEL_ERR | Personnel resource entity |
| MTH_PRODUCTION_SCHEDULES_ERR | Production schedule fact |
| MTH_PRODUCTION_SEGMENTS_ERR | Production segment entity |
| MTH_PROD_MTL_CONSUMED_ERR | Production material consumed fact |
| MTH_PROD_MTL_CONSUMED_TXN_ERR | Production material consumed transaction fact |
| MTH_PROD_MTL_PRODUCED_ERR | Production material produced fact |
| MTH_PROD_MTL_PRODUCED_TXN_ERR | Production material produced transaction fact |
| MTH_PROD_SEGMENTS_TXN_ERR | Production segment transaction fact |
| MTH_PROD_SUB_SEGMENTS_ERR | Production sub-segment entity |
| MTH_QUARTER_ERR | Quarter entity |
| MTH_RESOURCES_ERR | Resource entity |
| MTH_RESOURCE_COST_ERR | Resource cost fact |
| MTH_RESOURCE_REQUIREMENTS_ERR | Resource requirement fact |
| MTH_RESOURCE_TXN_ERR | Resource transaction fact |
| MTH_RUNTIME_ERR | Stores errors happened during run time |
| MTH_TAG_DATA_SOURCES_ERR | Error table for MTH_TAG_DATA_SOURCES |
| MTH_TAG_MASTER_ERR | Error table for MTH_TAG_MASTER |
| MTH_TAG_READINGS_ERR | Error table for tag readings table |
| MTH_TAG_READINGS_RAW_ERR | Tag readings raw table |
| MTH_TAG_READINGS_STG_ERR | Tag readings staging table |
| MTH_TAG_READINGS_UNPROCESS_ERR | Error table for MTH_TAG_READINGS_RAW |
| MTH_TIME_HIERARCHY_ERR | Time hierarchy entity |
| MTH_USER_DIM_ENTITIES_ERR | User dimension entities |
| MTH_USER_DIM_HIERARCHY_ERR | User defined dimension hierarchy entity |
| MTH_WEEK_ERR | Week entity |
| MTH_WORKDAY_SHIFTS_ERR | Workday shift entity |
| MTH_WO_SALES_ORDERS_ERR | Sales orders fact |
| MTH_YEAR_ERR | Year entity |