MTH Tables (230)

MTH - Oracle Manufacturing Operations Center — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
MTH_445_PERIOD_CALENDAR 57 This table stores 445/544 period calendar
MTH_445_PERIOD_CAL_HOUR_MV 48
MTH_ALL_ENTITIES_MV 8
MTH_ASSET_ERR 35 Error table for MTH_ASSET_MST
MTH_ASSET_MST 34 This table stores information about assets. It holds information like Asset Number, Asset Group, Maintenance Organization code and other ass
MTH_ASSET_STG 27
MTH_CONTEXTUALIZATION_METHOD 9 This table stores contextualization method setup for equipments
MTH_CONTEXTUALIZATION_REQ 11 This table stores the contextualization rules setup for equipments
MTH_DAY_D 20 This table stores information on day level definition for time dimension.
MTH_DAY_STG 13
MTH_DEPT_ENTITIES_I_STG 17 Interface table for MTH_EQUIP_ENTITIES_MST
MTH_DIM_HIERARCHY 16 This table is the hierarchy master table for all dimensions.
MTH_DIM_HIERARCHY_ERR 15 Error table for MTH_DIM_HIERARCHY
MTH_DIM_HIERARCHY_STG 6
MTH_DIM_LEVEL_LOOKUP 12 This table stores the level information for the dimension hierarchies. It holds information on level number, level name and level type.
MTH_DIM_LEVEL_LOOKUP_ERR 14 Error table for MTH_DIM_LEVEL_LOOKUP
MTH_DIM_LEVEL_LOOKUP_STG 6
MTH_ENTITIES 9 This tables stores the pre-defined entities for Manufacturing Operations Center
MTH_ENTITY_ATTRIBUTES 12 This table will store time-series attributes for Equipment Entities.
MTH_ENTITY_PLANNED_USAGE 13 MTH_ENTITY_PLANNED_USAGE will contain the planned energy usage for an entity for a particular period, which can be month, week or year. It c
MTH_ENTITY_PLANNED_USAGE_ERR 14
MTH_ENTITY_PLANNED_USAGE_HR_MV 26
MTH_ENTITY_PLANNED_USAGE_MV 22
MTH_ENTITY_PLANNED_USAGE_SM_MV 25
MTH_ENTITY_PLANNED_USAGE_STG 6
MTH_ENTITY_SUSTAIN_ASPECT 27 MTH_ENTITY_SUSTAIN_ASPECT is used to store entity sustainability aspect
MTH_ENTITY_SUSTAIN_ASPECT_HOUR 27 MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour.
MTH_ENTITY_SUST_EMISSIONS 5 MTH_ENTITY_SUST_EMISSIONS is a child table of MTH_ENTITY_SUSTAIN_ASPECT. It stores the emisssion information for each entry in the parent ta
MTH_ENTITY_SUST_HR_EMISSIONS 5 MTH_ENTITY_SUST_HR_EMISSIONS is a child table of MTH_ENTITY_SUSTAIN_ASPECT_HOUR. It stores the emisssion information for each entry in the p
MTH_EQUIPMENTS_D 41 This table stores information about equipments. It holds information like Equipment name, Equipment description and Fixed asset value and Or
MTH_EQUIPMENTS_ERR 41 Error table for MTH_EQUIPMENTS_D
MTH_EQUIPMENTS_EXT_B 87 This table stores the extensible attributes for equipments
MTH_EQUIPMENTS_EXT_TL 40 This table stores the translatable extensible attributes for Equipments
MTH_EQUIPMENTS_STG 33
MTH_EQUIPMENT_DENORM_D 84 This table stores denormalized data for equipment hierarchy.
MTH_EQUIPMENT_REASON_SETUP 11 This table stores Reason code as well as the Expected Uptime for Equipments
MTH_EQUIPMENT_REASON_SETUP_ERR 13 Error table for MTH_EQUIPMENT_REASON_SETUP
MTH_EQUIPMENT_REASON_SETUP_STG 5
MTH_EQUIPMENT_SHIFTS_D 18 This table stores shift information at equipment level.
MTH_EQUIPMENT_SHIFTS_ERR 17 Error table for MTH_EQUIPMENT_SHIFTS_D
MTH_EQUIPMENT_SHIFTS_STG 9
MTH_EQUIP_ENTITIES_ERR 31 Error table for MTH_EQUIP_ENTITIES_MST
MTH_EQUIP_ENTITIES_MST 27 This table stores the entity definitions for equipment dimension. It holds information on Entity name and Entity type.
MTH_EQUIP_ENTITIES_STG 23 Staging table for MTH_EQUIP_ENTITIES_MST
MTH_EQUIP_HIERARCHY 16 This table stores the history of parent - child relationship for equipment hierarchy.
MTH_EQUIP_HIERARCHY_ERR 15 Error table for MTH_EQUIPMENT_HIERARCHY
MTH_EQUIP_HIERARCHY_STG 7
MTH_EQUIP_OUTPUT 39 This table stores the output information by reading time. It holds information on quantity completed, rejected, scrapped, reworked and good
MTH_EQUIP_OUTPUT_ERR 41 Error table for MTH_EQUIP_OUTPUT
MTH_EQUIP_OUTPUT_STG 34
MTH_EQUIP_OUTPUT_SUMMARY 42 This table stores summarized information on equipment output by quantity completed, rejected, scrapped, reworked and good quantity
MTH_EQUIP_PROD_PERFORMANCE_ERR 32 Error table for MTH_EQUIP_PROD_PERFORMANCE_F
MTH_EQUIP_PROD_PERFORMANCE_F 43 This table stores information on actual equipment production schedule for each work order at the shift and operations level.
MTH_EQUIP_PROD_PERFORMANCE_STG 24
MTH_EQUIP_PROD_PERF_DETAIL_F 27 It contains similar information in equipment production performace with more granular status information.
MTH_EQUIP_PROD_SCHEDULE_ERR 37 Error table for MTH_EQUIP_PROD_SCHEDULE_F
MTH_EQUIP_PROD_SCHEDULE_F 39 This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it i
MTH_EQUIP_PROD_SCHEDULE_STG 29
MTH_EQUIP_PROD_SUSTAIN_F 13 This table will store the sutain aspect consumption and UOM for the workorder, segment, shift, and hour combination. This table is generic e
MTH_EQUIP_STANDARD_RATES_ERR 34 Error table for MTH_EQUIP_STANDARD_RATES_F
MTH_EQUIP_STANDARD_RATES_F 33 This table stores information on standard production rates for equipments.
MTH_EQUIP_STANDARD_RATES_STG 26
MTH_EQUIP_STATUSES 32 This table stores information on equipment statuses
MTH_EQUIP_STATUSES_ERR 31 Error table for MTH_EQUIP_STATUSES
MTH_EQUIP_STATUSES_STG 24
MTH_EQUIP_STATUS_SUMMARY 35 This table stores summarized information on equipment statuses by up time, down time, idle time and run time.
MTH_EVENTS 16 This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notifi
MTH_EVENT_ACTIONS 15 This table stores the event actions history. It holds information like Event Type, Event action and details of Event action taken.
MTH_EVENT_ACTION_SETUP 15 This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notifi
MTH_EVENT_ACTION_SETUP_ERR 18 Error table for MTH_EVENT_ACTION_SETUP
MTH_EVENT_ACTION_SETUP_STG 10
MTH_EVENT_SETUP 11 This table stores information on Event Action Setup for handling Events. It holds information like Equipment, Event Type and Reason.
MTH_EXT_ATTR_ERR 4 Error table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTI
MTH_EXT_ATTR_I_STG 4 Interface table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PROD
MTH_EXT_ATTR_T_STG 6 Staging table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUC
MTH_GREGORIAN_CALENDAR 46 This table stores gregorian calendar
MTH_HOUR_D 12 MTH_HOUR_D will store the hourly time buckets for each day generated in the calendar.
MTH_ITEMS_D 58 This table stores information on items and its attributes. It holds information like Item name, Item description, Base item, Primary UOM, Se
MTH_ITEMS_ERR 58 Error table for MTH_ITEMS_D
MTH_ITEMS_EXT_B 78 This table stores the extensible attributes for items
MTH_ITEMS_EXT_TL 40 This table stores the translatable extensible attributes for Items
MTH_ITEMS_I_STG 49 Interface table for MTH_ITEMS_D
MTH_ITEMS_STG 50
MTH_ITEM_CATEGORIES_D 43 This table stores information on Item Categories.
MTH_ITEM_CATEGORIES_I_STG 37 Interface table for MTH_ITEM_CATEGORIES_D
MTH_ITEM_CATEGORIES_STG 36 Staging table for MTH_ITEM_CATEGORIES_D
MTH_ITEM_COST 19 This table stores the information about item cost history. It holds information on item cost for every cost element of the item.
MTH_ITEM_COST_ERR 20 Error table for MTH_ITEMS_COST
MTH_ITEM_COST_I_STG 13 Interface table for MTH_ITEM_COST
MTH_ITEM_COST_STG 12
MTH_ITEM_DENORM_D 27 This table stores denormalized data for item hierarchy.
MTH_ITEM_DENORM_D_TMP 22
MTH_ITEM_HIERARCHY 14 This table stores the latest parent - child relationship for item hierarchy.
MTH_ITEM_HIERARCHY_ERR 14 Error table for MTH_ITEM_HIERARCHY
MTH_ITEM_HIERARCHY_I_STG 7 Interface table for MTH_ITEM_HIERARCHY
MTH_ITEM_HIERARCHY_STG 6
MTH_LOOKUPS_D 10 This table stores the lookup code along with the context.
MTH_MASTER_SETUP 14 This table stores information related to Manufacturing Operations Center instance and its attributes .
MTH_METERS 16 This table defines actual and virtual meter definition
MTH_METER_ENTITIES 15 This table defines the association between entities and meter.
MTH_METER_READINGS 12 This table stores actual meter values based on the tag readings from MTH_METER_READINGS_RAW or laded from CSV file and calculated values for
MTH_METER_READINGS_ERR 18 This table stores the error rows when processing the data from MTH_METER_READINGS_RAW, when loading data from CSV to MTH_METER_READINGS, and
MTH_METER_READINGS_STG 5
MTH_MTL_CONSUMED_TXN_LOT_ERR 39 Error table for MTH_MTL_CONSUMED_TXN_LOT_F
MTH_MTL_CONSUMED_TXN_LOT_F 37 This table stores the lot, sub-lot and serial number level information for both the product and components used
MTH_MTL_CONSUMED_TXN_LOT_STG 31
MTH_MTL_PRODUCED_TXN_LOT_ERR 36 Error table for MTH_MTL_PRODUCED_TXN_LOT_F
MTH_MTL_PRODUCED_TXN_LOT_F 34 This table stores the lot, sub-lot and serial number level information for the products manufactured
MTH_MTL_PRODUCED_TXN_LOT_STG 28
MTH_OPEN_SALES_ORDERS_F 5
MTH_ORGANIZATIONS_L 23 This table stores information for the organization dimension. It provides information like Organization name, Organization code, Currency co
MTH_OTHERS_D 8 This table stores classifications for "Others" entity
MTH_OTHERS_EXT_B 78 This table stores the extensible attributes for OTHERS entity
MTH_OTHERS_EXT_TL 40 This table stores the translatable extensible attributes for OTHERS entity
MTH_PERIOD_D 23 This table stores information on period level definition for time dimension hierarchies.
MTH_PERIOD_ERR 24 Error table for MTH_PERIOD_D
MTH_PERIOD_STG 16
MTH_PERSONNEL_D 38 This table stores information about personnel. It holds information like First name, Last name, Resource and Organization.
MTH_PERSONNEL_ERR 38 Error table for MTH_PERSONNEL_D
MTH_PERSONNEL_STG 30
MTH_PLANTS_D 37 This table stores information for the plant dimension. It provides information like Plant name, Currency code, Plant start date, Plant end d
MTH_PLANTS_ERR 37 This table will be used to store the error rows when loading data from the staging table to MTH_PLANTS_D table.
MTH_PLANTS_STG 29 This table will be used to as staging table to load the plants data from CSV
MTH_PLANT_ATTRIBUTES 5 This table will store time-series attributes for Site.
MTH_PRODUCTION_SCHEDULES_ERR 80 Error table for MTH_PRODUCTION_SCHEDULES_F
MTH_PRODUCTION_SCHEDULES_EXT_B 78 This table stores the extensible attributes for Work Orders
MTH_PRODUCTION_SCHEDULES_F 80 This table stores the work order information for all types of work orders. It holds information on work order type, status, the scheduled an
MTH_PRODUCTION_SCHEDULES_I_STG 54 Interface table for MTH_PRODUCTION_SCHEDULES_F
MTH_PRODUCTION_SCHEDULES_STG 72
MTH_PRODUCTION_SCHEDULE_EXT_TL 40 This table stores the translatable extensible attributes for Work Orders
MTH_PRODUCTION_SEGMENTS_ERR 46 Error Table for MTH_PRODUCTION_SEGMENTS_F
MTH_PRODUCTION_SEGMENTS_EXT_B 82 This table stores external attributes data for Workorder Segments
MTH_PRODUCTION_SEGMENTS_EXT_TL 40 This table stores the translatable extensible attributes for Workorder Segments
MTH_PRODUCTION_SEGMENTS_F 45 This table stores information on operations for various types of work orders. It holds information on Scheduled quantity, actual completed,
MTH_PRODUCTION_SEGMENTS_STG 38
MTH_PROD_MTL_CONSUMED_ERR 42 Error table for MTH_PROD_MTL_CONSUMED_F
MTH_PROD_MTL_CONSUMED_F 47 This table stores the information on planned and actual usage quantities for components
MTH_PROD_MTL_CONSUMED_STG 34
MTH_PROD_MTL_CONSUMED_TXN_ERR 38 Error table for MTH_PROD_MTL_CONSUMED_TXN_F
MTH_PROD_MTL_CONSUMED_TXN_F 39 This table stores the information on transactions that consume the component material at the operation level of the work orders
MTH_PROD_MTL_CONSUMED_TXN_STG 30
MTH_PROD_MTL_PRODUCED_ERR 44 Error table for MTH_PROD_MTL_PRODUCED_F
MTH_PROD_MTL_PRODUCED_F 47 This table stores the work order item information. It holds information about the quantity of each item to be assembled, the actual quantit
MTH_PROD_MTL_PRODUCED_I_STG 21 Interface table for MTH_PROD_MTL_PRODUCED_F
MTH_PROD_MTL_PRODUCED_STG 36
MTH_PROD_MTL_PRODUCED_TXN_ERR 38 Error table for MTH_PROD_MTL_PRODUCED_TXN_F
MTH_PROD_MTL_PRODUCED_TXN_F 39 This table stores information on assembly completion transactions at the operation level of the work orders
MTH_PROD_MTL_PRODUCED_TXN_STG 30
MTH_PROD_SEGMENTS_TXN_ERR 39 Error table for MTH_PROD_SEGMENTS_TXN_F
MTH_PROD_SEGMENTS_TXN_F 38 This table stores information about the intra-operation transactions that take place at the operation level. It holds information on quantit
MTH_PROD_SEGMENTS_TXN_STG 31
MTH_PROD_SUB_SEGMENTS_ERR 27 Error table for MTH_PROD_SUB_SEGMENTS_STG
MTH_PROD_SUB_SEGMENTS_F 26 This table stores information on activities for each operation (Segment). It holds information on Sub-segment, actual and planned start date
MTH_PROD_SUB_SEGMENTS_STG 19
MTH_QUARTER_D 23 This table stores information on quarter level definition for time dimension hierarchies.
MTH_QUARTER_ERR 24 Error table for MTH_QUARTER_D
MTH_QUARTER_STG 16
MTH_RESOURCES_D 52 This table stores information about resources. It holds information like Resource name, Resource description, Resource type, Usage UOM, Reso
MTH_RESOURCES_ERR 52 Error table for MTH_RESOURCES_D
MTH_RESOURCES_I_STG 44 Interface table for MTH_RESOURCES_D
MTH_RESOURCES_STG 44
MTH_RESOURCE_COST 19 This table stores the information about resource cost history. It holds information on resource cost for every cost element of the resource.
MTH_RESOURCE_COST_ERR 20 Error table for MTH_RESOURCE_COST
MTH_RESOURCE_COST_I_STG 14 Interface table for MTH_RESOURCE_COST
MTH_RESOURCE_COST_STG 12
MTH_RESOURCE_REQUIREMENTS_ERR 34 Error table for MTH_RESOURCE_REQUIREMENTS_F
MTH_RESOURCE_REQUIREMENTS_F 38 This table stores information on planned resource usages at each operation level on the work order
MTH_RESOURCE_REQUIREMENTS_STG 26
MTH_RESOURCE_TXN_ERR 34 Error table for MTH_RESOURCE_TXN_F
MTH_RESOURCE_TXN_F 39 This table stores information on actual resource usages at each operation level on the work order
MTH_RESOURCE_TXN_STG 26
MTH_RES_GRP_ENTITIES_I_STG 14 Interface table for MTH_EQUIP_ENTITIES_MST
MTH_RUNTIME_ERR 4 MTH_RUNTIME_ERR stores errors happened during run time.
MTH_RUN_LOG 19 Log table for internal processing
MTH_SHIFT_REFERENCE_MV 3
MTH_SITE_SHIFT_DEFINITIONS 12 This table stores the definition of the shift template for a site in order to generate shift for all entities belonging to the site as well
MTH_SITE_SUSTAINABILITIES 14 MTH_SITE_SUSTAINABILITIES stores the sustainability aspect setup information for each site.
MTH_SITE_SUSTAIN_SOURCES 13 MTH_SITE_SUSTAIN_SOURCES contains energy sources for each entry in MTH_SITE_SUSTAINABILITIES, which contains the combination of MTH_PLANTS a
MTH_SOURCE_EMISSION_FACTORS 10 MTH_SOURCE_EMISSION_FACTORS is a child table of MTH_SITE_SUSTAIN_SOURCES.
MTH_SUSTAIN_ASPECTS 10 This table stores the information for Sustainability Aspects.
MTH_SUSTAIN_EMISSIONS 12 MTH_SUSTAIN_EMISSION is a child table of MTH_SUSTAIN_ASPECTS
MTH_SUSTAIN_USAGES 11 MTH_SUSTAIN_USAGE is a child table of MTH_SUSTAIN_ASPECTS
MTH_SYSTEMS_SETUP 16 This table stores information related to MOC source systems and their attributes.
MTH_TAG_DATA_SOURCES 12 This table defines the sources for tag
MTH_TAG_DATA_SOURCES_ERR 13 This is error table for MTH_TAG_DATA_SOURCES table
MTH_TAG_DATA_SOURCES_STG 5
MTH_TAG_DESTINATION_MAP 12 This table stores details on tag target entities
MTH_TAG_MASTER 30 This table stores tag master information
MTH_TAG_MASTER_ERR 32 This table stores tag master information
MTH_TAG_MASTER_STG 17
MTH_TAG_METER_READINGS_LATEST 3 This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_METER_READINGS_RAW
MTH_TAG_METER_READINGS_RAW 4
MTH_TAG_READINGS 35 This table contains the Manufacturing Operations Center processed tag data
MTH_TAG_READINGS_ERR 38 Error table for MTH_TAG_READINGS
MTH_TAG_READINGS_LATEST 3 This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_READINGS_RAW
MTH_TAG_READINGS_RAW 17 This table contains the unprocessed tag data collected from PLCs
MTH_TAG_READINGS_RAW_ERR 24 Error table for MTH_TAG_READINGS_RAW
MTH_TAG_READINGS_RAW_PROCESSED 16 This table contains the tag data collected from PLCs after applying cumulative logic
MTH_TAG_READINGS_STG 22 Staging table for MTH_TAG_READINGS
MTH_TAG_READINGS_STG_ERR 20 Error table for MTH_TAG_READINGS_STG
MTH_TAG_READINGS_T_STG 12 Staging table to move device data in MTH_EQUIPMENTS_EXT_B
MTH_TAG_READINGS_UNPROCESS_ERR 25 Error table for MTH_TAG_READINGS_RAW
MTH_TAG_REASON_READINGS 14 This table stores reasons for downtime and scrap
MTH_TIME_HIERARCHY 12 This table stores the latest parent - child relationship for time hierarchy.
MTH_TIME_HIERARCHY_ERR 14 Error table for MTH_TIME_HIERARCHY
MTH_TIME_HIERARCHY_STG 6
MTH_TRANSLATED_MESSAGE 3 This table is using to store seeding data for translation
MTH_USER_DIM_ENTITIES_ERR 24 Error table for MTH_USER_DIM_ENTITIES
MTH_USER_DIM_ENTITIES_MST 23 This table stores the entity definitions for user-defined dimensions. It holds information on Entity name and Entity type.
MTH_USER_DIM_ENTITIES_STG 16
MTH_USER_DIM_HIERARCHY 13 This table stores the latest parent-child hierarchy relationship for user-defined hierarchies.
MTH_USER_DIM_HIERARCHY_ERR 15 Error table for MTH_USER_DIM_HIERARCHY
MTH_USER_DIM_HIERARCHY_STG 7
MTH_USER_ENTITIES_EXT_B 83 This table stores the extensible attributes for User-Defined Entities,Resource and Site
MTH_USER_ENTITIES_EXT_TL 41 This table stores the translatable extensible attributes for User-Defined Entities,Resource and Site
MTH_VIRTUAL_METER_COMPONENTS 12 This table defines required componets for formula in order to calculate the energy consumption.
MTH_WEEK_D 23 This table stores information on week level definition for time dimension hierarchies.
MTH_WEEK_ERR 24 Error table for MTH_WEEK_D
MTH_WEEK_STG 16
MTH_WORKDAY_SHIFTS_D 30 This table stores the workday shifts definition for the time dimension. It provides information like Shift date, Shift From Time, Shift To T
MTH_WORKDAY_SHIFTS_DIS_I_STG 19 Interface table for MTH_WORKDAY_SHIFTS_D
MTH_WORKDAY_SHIFTS_ERR 29 Error table for MTH_WORKDAY_SHIFTS_D
MTH_WORKDAY_SHIFTS_STG 22
MTH_WO_SALES_ORDERS_ERR 36 Error table for MTH_WO_SALES_ORDERS_F
MTH_WO_SALES_ORDERS_F 39 This table stores information on the sales orders that originate the demand for the work orders. It holds information about the sales order
MTH_WO_SALES_ORDERS_I_STG 14 Interface table for MTH_WO_SALES_ORDERS_F
MTH_WO_SALES_ORDERS_STG 28
MTH_YEAR_D 23 This table stores information on year level definition for time dimension hierarchies.
MTH_YEAR_ERR 24 Error table for MTH_YEAR_D
MTH_YEAR_STG 16