Setting Up Tags and Contextualization

This chapter covers the following topics:

• Tag Setup
• Contextualization Entities
• Contextualization Methods
• Tag-Based Contextualization
• Contextualization by Schedule
• Manual Contextualization
• Non-contextualized Rows
• Reason Code Setup
• Loading Tag Data into Summary Tables
• Menus and Responsibility for Contextualization
• Understanding Actual and Virtual Meters
• Understanding the Meter Readings Process Flow
• Viewing Meter Summary
• Viewing Meters
• Adding Meters
• Updating Meters
• Assigning Meters

Tag Setup

To set up a tag, you must load the Tag Master and associate the tag with entities. You can optionally set up a business rule.

To set up a tag:

1. In the Microsoft Excel template, update the tags in MTH_TAG_MASTER_UI.csv

2. Load the Tag Master by running the ODI Package MTH_PKG_TAGS_EXT.

3. Set up the tags using the Tag Setup user interface. Refer to the "Setting Up Tags" topic in the Oracle Manufacturing Operations Center User's Guide for more information.

4. Optionally, you can set up business rules in Oracle Data Integrator (ODI).

Hard-coded tag values are as follows:

Tag Value	Meaning	Comment
1	Run	Equipment is in use.
2	Idle	Equipment is not in use and is available.
3	Down	Equipment not in use and is not available.

Contextualization Entities

Manufacturing Operations Center contextualizes tag data for the following entities:

1. Equipment: Equipment context is available from the setup between the tag and equipment. No additional logic is available to get the equipment context if the association is not specified during tag setup.

2. Workorder: Work order context comes from the tag or the equipment production schedule.

3. Operation: The operation context comes from a tag or equipment production schedule.

4. Item: The item context can come from a tag or the equipment production schedule.

5. Shift: The shift context is available from the equipment shift schedule.

6. Hour: The Hour context is available from the Hours table based on the reading time for the tag.

Contextualization Methods

You must specify one of the following contextualization methods at the equipment level during contextualization setup:

• Tag based Contextualization: Business context is given through equipment tags.

• Schedule based Contextualization: Business context is determined by referring to schedules.

• Manual Contextualization: Business context is entered manually and is not available as a tag and should not be determined by referring to schedules.

You must construct the primary key for Work Order, Segment, Shift, Equipment, Item in the required format in the transaction tables. The formats for primary keys are:

• Work Order: '<Work order id>-<MOC Plant code>"

• Segment: "<Segment number>-<Work order id>-<Plant code>"

• Item: "<Equipment_item_id>-<Organization_code>"

If the primary key is not in the required format, contextualization errors can occur.

Context Update for Tag Entries

Oracle Manufacturing Operations Center application provides the ability to collect process parameters such as temperature and pressure readings and also equipment status, output, completed quantity, and ingredient consumption at a near real-time frequency from the machine controllers. The business contexts (workorder, item, segment details) are maintained in the ERP systems and not paired with the PLC tags.

After contextualization, due to the non-availability of workorder, segment, and item information, the context data is populated as unassigned in the tag readings table, equipment extensible attribute table, and extensible attribute summary table. The ODI scenario processes MTH_TAG_READINGS_CONTEXT.csv file and modifies tag readings table and equipment extensible attribute table for all the records related to the equipment whose reading time for an equipment is for a specific time period.

Tag-Based Contextualization

The logic for tag-based contextualization is as follows:

Tag	Description
Equipment	Equipment context is obtained from the tag-equipment mapping.
Scrap Quantity	Equipment scrapped quantity
Output Quantity	Equipment output quantity including good and bad quantities
Rework Quantity	Equipment reworked quantity
Rejected Quantity	Rejected quantity which includes rework and scrap
Completed Quantity	Completed quantity without reject or scrap
Shift	Shift ID is obtained by comparing the reading time and the equipment shift from time and to time
Workorder	The ID from the source system; ip_entity_id/batch_id/repetitive_schedule_id
Item	The Inventory Item ID from the source system
Segment	The Operation number

If tags are not available for Equipment and Shift, the context can be determined by using the schedules method.

Note: When inserting data in mth_tag_readings_raw, the WOSegment format of PK should be <OPERATION_CODE>-<WORKORDER_NUMBER>-<PLANT_CODE>

Warning: You must construct the primary key for Work Order, Segment, and Item in the required format in the transaction tables. If the primary key is not properly constructed in the required format, contextualization errors and complications can occur.

Contextualization by Schedule

The logic for contextualization by schedule is as follows:

Tag	Description
Equipment	The equipment context is acquired by referring to the tag setup.
Shift	The shift of the equipment is located in the read time in the Equipments Shifts Table.
Workorder	The work order is located in the read time in the scheduled from and to date of a work order in mth_equip_production_schedules_f.
Operation	The operation is located in the Equipment Production Schedules by using the shift and the equipment.
Item	Using work order, find the item from the Equipment Production Schedules table.

Manual Contextualization

If the manual contextualization method is selected, Manufacturing Operations Center does not apply any logic to get the context, and the context is entered manually in the manual contextualization user interface. Manufacturing Operations Center only gets the equipment context from the tag setup.

Non-contextualized Rows

If context is missing after applying the contextualization logic, Manufacturing Operations Center moves the rows to either the mth_tag_readings or the errors table.

1. If a missing context is set up as mandatory, it is moved to the errors table.

2. If a missing context is set up as optional, it is moved to the readings table.

Reason Code Setup

Use Tags to display reasons for downtime status or scrap quantity. As a one-time setup, you can define a list of all possible reason codes and reason meanings in the plant. In the business meaning setup for the reason tag, map the value of the tag to a reason code.

Reason Code can be setup utilizing FND Lookup. Three lookup types seeded by MOC include:

• MTH_SCRAP_REASON (for setting up scrap reasons)

• MTH_EQUIP_DOWNTIME_REASON (for setting up downtime reason)

Reason Code setup is accessed from the Development Manager responsibility in the Lookups Menu.

Loading Tag Data into Summary Tables

You must pass the equipment status readings continuously to the MOC application. For a period that does not have a status reading, the MOC application uses the status from the previous reading to fill the gap. If you are loading the energy meter readings or equipment output for the following entities, you must pass the reading time as one second less than the actual reading time as the MOC application considers the end of the hour as XX:59:59 for separating the hourly boundaries by one second:

• Scrap Quantity

• Output Quantity

• Rework Quantity

• Rejected Quantity

• Completed Quantity

To load tag data into summary tables:

• Load the data into tag readings tables by running the concurrent program MTH: Process Transactions.

Menus and Responsibility for Contextualization

Contextualization Setup

Responsibility: Manufacturing Operations Center Administrator

Menu: Manufacturing Operations Center Administrator Menu

Manual Contextualization

Responsibility: Manufacturing Operations Center User

Menu: Manufacturing Operations Center User Menu

Understanding Actual and Virtual Meters

In most organizations, equipments are the primary source of Green House Gas Emissions (GHGE). The equipments include not only production equipment, but also non-production equipment, such as refrigeration, air conditioning, and water and wastewater management systems.

Oracle MOC enables you to track electricity usage and GHGE at the source, either through sensors, meters, and virtual meters and provides a very effective GHGE abatement or Carbon reduction strategy.

Actual meters are physical instruments that are used to record electricity usage in association with smart meters (i.e. building, floor, lighting equipment, manufacturing equipment etc.) You can associate Actual Meters with Tags for data collection, load readings using .csv files, or enter the readings manually in the Actual Meters Data Entry page. Refer to the "Microsoft Excel Template Data Collection" topic for information on the .csv files for loading data. Refer to topics “Adding an Actual Meter” in this guide for information on adding meters and “Performing Actual Meters Data Entry” in the Oracle Manufacturing Operations Center User's Guide for more information on entering data manually.

Virtual meters are expressions that are derived to calculate the electricity consumption for certain usages that cannot be measured by actual meters. A virtual meter can be modeled and associated with any entity without having a physical meter, where estimation of energy consumption is required. Virtual meters can be Meter-based or Power Rating- based. A virtual meter that is modeled to estimate consumption based on allocation/aggregation of other actual or virtual meter measurements is called Meter-based virtual meter. A virtual meter that calculates the electricity consumption by directly using power-rating and operational data of equipment is called a Power Rating-based virtual meter. A meter can also be associated with a usage category to realize consumption monitoring by different usage groups such as lights, computer systems, etc.

Energy consumption data collected from smart meters is contextualized with production variables such as equipment status (i.e. idle, run, alarm), time period, work-order, and item. Resulting from contextualization capability, advanced process improvements can be driven by segregating energy consumption as Value added and Non-value added energy in manufacturing processes.

Understanding the Meter Readings Process Flow

Oracle Manufacturing Operations Center provides manufacturing capability to shop floor for production companies that are sensitive to environmental issues and energy usages. Energy consumption data collected from smart meters is contextualized with production variables such as equipment status (i.e. idle, run, down), time period, work-order, and item. You can obtain valuable data resulting from contextualization capability, and design advanced process improvements driven by segregating energy consumption as Value added and Non-value added energy in manufacturing processes.

The carbon emission and energy usages (sustainability aspect) for an entity are calculated by processing the meter readings that are obtained from both the Actual and Virtual Meters assigned to the entity. Each meter is associated with a tag and tag data source. For evaluation, a meter must be associated with an Active tag. If a tag becomes inactive, then the meter also becomes inactive. Refer to the topic “Tag Setup” in this chapter and “Setting Up Tags” in the Oracle Manufacturing Operations Center User's Guide for more information on how to set up tags. The unprocessed tag meter readings are stored in the Actual Meter Readings table. If the tag meter readings are Cumulative, then they are converted to Incremental readings before being stored in the Meter Readings table. You can also enter meter readings directly that are also stored in the Meter Readings table, using the Actual Meter Data Entry page and the MTH : Meter_Readings.csv template.

The data in the Power Rating Based Virtual Meter Readings table is obtained from the Equipment Production Performance, Entity Shift, and Shift Availability tables.

The readings in the Meter Readings table are processed by validating with the Entity Meter Master and Entity Shift. When you run the MTH : Process and Populate MOC Entity Sustainability Aspect concurrent program, data from the Meter Readings table is utilized in calculating the carbon emission and electricity usage costs, that are stored in the Entity Sustainability Aspect table. These calculations are based on the site sustainability aspect setup for emission and cost respectively. Refer to the “Running the MTH : Process and Populate MOC Entity Sustainability Aspect Concurrent Program” topic of the Oracle Manufacturing Operations Center User's Guide for more information. The following figure is a graphical representation of the process flow:

Viewing Meter Summary

Use the Meter Summary page to view the summary of the meters for a sustainability aspect.

To view meter summary

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Meter Home page. The Meter Summary page appears.

2. Select the Sustainability Aspect to search for all meters for a specific sustainability aspect. Options are Electricity and Gas. Required.

3. Enter any of the following criteria to narrow the search:

   • Meter Name to find a meter using its name

   • Status as:

     • Active to find all active meters.

     • Inactive to find all inactive meters.

   • Meter Code to find a meter using its code

   • Meter Type as:

     • Actual to find all actual meters

     • Virtual to find all virtual meters

4. Click Go. The Search Results: Meters region displays the results of the search.

5. The following fields display:

   • Meter Code is the code for the meter.

   • Meter Name is the name of the meter.

   • Meter Type displays as Actual or Virtual.

   • Entity Name is the name of the entity with which the meter is associated.

   • Usage Category is the usage category for the meter.

   • Meter Category displays as Primary or Simulation.

   • Simulation Name displays if the meter category is Simulation.

   • Status displays as Active or Inactive.

6. Click a Meter Code to view the details of a meter.

7. Click Add to add a meter.

8. Click Update to update a meter.

   

Viewing Meters

Use the View Meter page to view the details of a meter.

To view a meter

1. Navigate to the Meter Summary page.

2. Search for meters as described in the “Viewing Meter Summary” topic.

3. Click the Meter Code of the meter for which you want to view the details in the search results.

4. The View Meter page displays the meter details.

   

Adding Meters

Use the Add Meter page to add a meter.

To add a meter

1. Navigate to the Meter Summary page.

2. Select the Sustainability Aspect for which you want to add a meter.

3. Click Add. The Add Meter page appears.

4. Enter the Meter Code and Meter Name.

5. Select the Meter Type as Actual or Virtual.

6. Select the Tag Data Source from the list of values (LOV). All the tags available in the Tag Master display in the LOV.

7. Select a Tag to which you want to associate the meter.

8. Click Save and Add Another to save the meter and add another meter.

9. Click Save and Close to add the meter and close the page.

   

Updating Meters

Use the Update Meter page to update a meter.

To update a meter

1. Navigate to the Meter Summary page.

2. Search for the meter to update.

3. Click Update. The Update Meter page appears.

4. Update the following fields:

   • Meter Name

   • Meter Type

   • Tag Data Source

   • Tag: If the meter type is Actual, then this field is enabled. Only Active tags display in the LOV.

   • Virtual Meter Type: If the meter type is Virtual, then this field is enabled. Options are: Power Rating Based and Meter Based.

5. Click Save.

   

Assigning Meters

Use the Assign Meters page to assign meters to an entity. An actual meter can be assigned to any number of combinations of entity name, usage category, meter category, and simulation name. But a virtual meter can be assigned to only one such combination.

To assign a meter

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Meter Home page.

2. Select the Meter Assignment tab. The Meter Assignment page appears.

3. Select the Entity Hierarchy and Entity to which you want to assign meters.

4. Select the Entity Name to assign the meter and the Sustainability Aspect for the meter.

5. Optionally, select the Usage Category for the meter.

6. Click Go. All the meters assigned for the selected criteria display.

   

7. Click Assign Meters. Select a Meter Code to assign. The Meter Name and Meter Type display.

8. Select the Usage Category for the meter.

9. Select the Meter Category as Primary or Simulation.

10. Select the Simulation Name as Estimated or Allocated. If you select the Meter Category as Simulation, then this field is enabled. Status displays as Active by default.

11. Click Save.

    

12. To update an assignment, select the meter assignment that you want to update and click Update Assignment. You can update Usage Category and Meter Category of an assignment.

    

13. Click Inactivate to inactivate a meter assignment.

14. Click Activate to activate an inactive meter assignment.