Load Data Reference and Transaction Data

ODI based Data Integration Platform

Note: To access WEBADI, set BNE Allow No Security Rule as Yes.

After the ODI is set up and before collecting the EBS source data/populating the CSV data, run the seed data scenario to populate default seeded data in the required MOC tables.

Steps to run the ODI scenarios:

  1. Connect to ODI.

  2. Navigate to Load Plans and Scenarios > MTH Setup > MTH Systems.

  3. Run the scenario MTH_PKG_SEED_DATA.

The following tables must have the seeded default record after execution:

EBS Integration Scenarios
Entity Sequence ODI Scenario Name Comment
System   MTH_PKG_SYSTEMS_SETUP_EXT  
Plant   MTH_PKG_ORGANIZATIONS_SRC To collect source organizations
Shift   MTH_PKG_WORKDAY_SHIFTS_SRC
MTH_PKG_EQUIPMENT_SHIFTS_SRC		 To load shift definition at Plant Work day and Equipment Work day level
Item 1 MTH_PKG_ITEMS_SRC To load Item, Categories, Item Segments and Item hierarchies
  2 MTH_PKG_ITEM_HIERARCHY_SRC  
Item Cost   MTH_PKG_ITEM_COST_SRC To collect Item Cost from Discrete Organizations
Equipment 1 MTH_PKG_EQUIPMENT_ENTITIES_SRC To load Equipment Entities, Resources and Equipment hierarchies
  2 MTH_PKG_RESOURCES_SRC  
  3 MTH_PKG_EQUIPMENT_HIERARCHY_SRC  
Resource Cost   MTH_PKG_RESOURCE_COST_SRC To collect Resource Cost from Discrete Organizations
Work Orders   MTH_PKG_PRODUCTION_SCHEDULES_SRC To load Discrete, flow, OSFM workorders or OPM Process Batches
Sales Orders   MTH_PKG_WORKORDER_RESERVATIONS_SRC To collect Sales Orders Reservations
Production Segments   MTH_PKG_PRODUCTION_SEGMENTS_SRC Collect Production Schedules before running this
Production Sub-segments   MTH_PKG_PRODUCTION_SUB_SEGMENTS_SRC Collect Production Batch segments before running this
Resource Requirements   MTH_PKG_RESOURCE_REQUIREMENTS_SRC Collect Production Schedules, Batch segments, and Batch sub-segments before running this
Material Requirements   MTH_PKG_MTL_CONSUMED_SRC Collect Production Schedules, Batch segments, and Batch sub-segments before running this
Equipment Production Schedules   MTH_PKG_EQUIPMENT_PROD_SCHEDULE_SRC Collect Equipment shifts, Production schedules, Batch segments, and Batch sub-segments before running this
Flat file Integration Scenarios
Entity Sequence CSV Template ODI Scenario Comment
System   MTH_SYSTEMS_SETUP.csv MTH_PKG_SYSTEMS_SETUP_EXT To load System Setup
Organization   MTH_ORG.csv MTH_PKG_ORGANIZATIONS_EXT To collect source organizations
Item 1 MTH_ITEMS_MASTER.csv MTH_PKG_ITEMS_EXT To load Item, Categories, Item Cost Item Segments and Item hierarchies
  2 MTH_ITEM_COST.csv MTH_PKG_ITEM_COST_EXT  
  3 MTH_ITEM_CATEGORY.csv MTH_PKG_ITEM_CATEGORIES_EXT  
  4 MTH_ITEM_HIERARCHY.csv MTH_PKG_ITEM_HIERARCHY_EXT  
Workday Shifts   MTH_WORKDAY_SHIFTS.csv MTH_PKG_WORKDAY_SHIFTS_EXT To load shift definition at Plant Work day and Equipment Work day level.
      MTH_PKG_SHIFTS_GEN_UI Schedule this scenario to run periodically and create shifts. Parameters include Site, Start Date, and End Date.
Equipment Hierarchy 1 MTH_ENTITY_MASTER.csv MTH_PKG_EQUIPMENT_ENTITIES_EXT To load Departments, Resources, Resource Cost, Equipment and Equipment Hierarchy.
  2 MTH_RESOURCES.csv MTH_PKG_RESOURCES_EXT  
  3 MTH_RESOURCE_COST.csv MTH_PKG_RESOURCE_COST_EXT  
  4 MTH_EQUIP_MASTER.csv MTH_PKG_EQUIPMENT_EXT  
  5 MTH_EQUIP_HRCHY_DEF.csv MTH_PKG_EQUIPMENT_HIERARCHY_EXT  
Equipment Shifts   MTH_EQUIP_SHIFTS.csv MTH_PKG_EQUIPMENT_SHIFTS_EXT To load Equipment Shift
Equipment Standard Rate   MTH_EQUIP_STANDARD_RATES.csv MTH_PKG_EQUIPMENT_STD_RATE_EXT To load Equipment standard Rate
Equipment Reasib Setup   MTH_EQUIP_REASON_SETUP.csv MTH_PKG_EQUIPMENT_REASONS_EXT To load Equipment Down, Idle, Scrap Reason codes
Personnel, Asset, Event Action 1 MTH_PERSONNEL.csv MTH_PKG_PERSONNEL_EXT To load personnel, Asset and Event Action Details for Event Management Flow
  2 MTH_ASSET_MASTER.csv MTH_PKG_ASSETS_EXT  
  3 MTH_EVENT_ACTION_SETUP.csv MTH_PKG_EVENT_SETUP_EXT  
Entity planned usage, Meter readings 1 MTH_ENTITY_PLANNED_USAGE.csv MTH_PKG_ENTITY_PLANNED_USAGE_EXT To load entity planned usage and meter readings for Sustainability Performance Analysis
  2 MTH_METER_READINGS.csv MTH_PKG_METER_READINGS_EXT  
Reservation   MTH_WO_SALES_ORDERS.csv MTH_PKG_WORKORDER_RESERVATION_EXT To collect Sales Order - Work Order Reservation.
Equipment status   MTH_EQUIP_STATUS.csv MTH_PKG_PROCESS_TRANSACTIONS The ODI package launches the Concurrent Program MTH: Process Transactions
Equipment output   MTH_EQUIP_OUTPUT.csv MTH_PKG_PROCESS_TRANSACTIONS The ODI package launches the Concurrent Program MTH: Process Transactions
Extensible User Function   MTH_EXT_USER_FUNCTIONS.csv MTH_PKG_EXT_USER_FUNCTIONS_EXT To load Attribute Summary Functions into the MTH_EXT_USER_FUNCTIONS table. Check the MTH_EXT_USER_FUNCTIONS_ERR table for error records.
Tag   MTH_TAG_MASTER_UI.csv MTH_PKG_TAGS_EXT To collect Tag Master data
Tag Data   MTH_TAG_READINGS_RAW.csv MTH_PKG_TAG_READINGS_RAW To load tag data into the MTH_TAG_READINGS_RAW table
Tag Mapping   MTH_TAG_DESTINATION_MAP.csv MTH_PKG_TAG_DESTINATION_EXT Tag Mapping
Flat file Integration Scenarios - Work Order
Entity Sequence CSV Template ODI Scenario Data Collected
Work Order 1 MTH_PROD_SCHEDULES.csv MTH_PKG_PRODUCTION_SCHEDULES_EXT Work orders
  2 MTH_PROD_SEGMENTS.csv MTH_PKG_PRODUCTION_SEGMENTS_EXT Work order segments
  3 MTH_PROD_SUB_SEGMENTS.csv MTH_PKG_PRODUCTION_SUB_SEGMENTS_EXT Work order sub-segments
  4 MTH_EQUIP_PROD_SCHEDULE.csv MTH_PKG_EQUIPMENT_PROD_SCHEDULE_EXT Associate equipment with work order and segment
  5 MTH_PROD_MTL_PRODUCED.csv MTH_PKG_PRODUCTION_SCHEDULES_EXT Material produced
  6 MTH_RES_REQ.csv MTH_RESOURCE_REQUIREMENTS_EXT Resource requirements
  7 MTH_RES_TXN.csv MTH_PKG_RESOURCE_TXN_EXT Resource transactions
  8 MTH_MTL_PRODUCED_TXN.csv MTH_PKG_MTL_PRODUCED_EXT Material produced transactions
  9 MTH_MTL_PRODUCED_TXN_LOT.csv MTH_PKG_MTL_PRODUCED_TXN_EXT Produced transaction lots
  10 MTH_PROD_SEGMENTS_TXN.csv MTH_PKG_PRODUCTION_SEGMENT_TXN_EXT Production segment transactions
  11 MTH_MTL_CONSUMED.csv MTH_PKG_MTL_CONSUMED_EXT Material consumed
  12 MTH_MTL_CONSUMED_TXN.csv MTH_PKG_MTL_CONSUMED_TXN_EXT Material consumed transactions
  13 MTH_MTL_CONSUMED_TXN_LOT.csv MTH_PKG_MTL_CONSUMED_TXN_LOT_EXT Material consumed transaction lots
Flat file Integration Scenarios - User Dimension Hierarchy
Entity Sequence CSV Template ODI Scenario Name Comment
User Dimension Hierarchy 1 MTH_DIM_HIERARCHY.csv MTH_PKG_DIM_HIERARCHY_EXT To build user defined dimension hierarchy
  2 MTH_DIM_LEVEL_LOOKUP.csv MTH_PKG_DIM_LEVEL_LOOKUP_EXT  
  3 MTH_USER_DIM_ENT.csv MTH_PKG_USER_DIM_ENTITIES_EXT  
  4 MTH_USER_DIM_HRCHY.csv MTH_PKG_USER_DIM_HIERARCHY_EXT