42Q-MES0138 OEE Data Collection

42Q Home > Production > OEE  Production

 

 

 

 

Production OEE Data Collection Version MES 15.74 Revision E1  

 

 

 

 

 

OEE 

OEE Data Collection provides two ways for plants to collect Data from asset activity:

1. Report production data (asset events/downtimes, work time) manually in the  OEE Data Collection module.
2. Collect production data automatically using the OEE Configuration tools, 42Q's API, and a preferred client.

To access OEE Data Collection go to: Production >  OEE Data Collection and the following main screen will appear.

 

Figure 1:   OEE Data Collection 

Report Asset Event

In the Report Asset Event portlet, Shop Floor Operators manually add asset events running, setup,Idle, spare, maintenance, calibration, scheduled downtime and unscheduled downtime due to asset malfunctions as well as routine stoppages (such as parts in transit or lunch breaks). This data expresses the Availability component of OEE Configuration.

When an asset experiences stoppages, for any reason, a signal is sent to the MES database, the time is recorded in the system, and a work order is created. When the machine is once again running, the work order is closed and corresponding timestamps are recorded.

Keep in mind that uptime and downtime timestamps are dictated by the up/down intervals defined in the Up/Down Threshold submodule of OEE Configuration. This allows for a grace period during which the signal is not sent to the MES, based upon machine parameters and production expectations.

TIP: Don't forget to set Up/Down Thresholds so Work Orders are not triggered during scheduled downtimes (e.g. setup).

Attention: Plants operating OEE Configuration without an auto PLC or FUJI interface must manually record stoppages due to a plant's regular workflow (e.g. lunch breaks, waiting for parts) in Report Work. 

Engineers will then use the Report Machine Down tool to manually record the root cause for each downtime event.

Note: Root Causes are reported in Data Collector for all interface types.

In the Report Asset Event module, operators can report details about their shift to include the following:

• Work Time: The operator enters the beginning and end of their shift. This data represents the Performance variable of OEE Configuration.
• Finished Quantity: The operator enters the total number of units produced.
• Good Quantity: The operator enters the number of first-time quality units produced. 

Taken together, Finished/Good Quantity represents the Quality variable of OEE Configuration.    

 

 

Report Asset Event

To record an asset event due to regular plant workflow:

1. Select the"+" icon on the top menu bar.
2. A pop-up window displays: Report Asset Event

 

Figure 2: Report New Asset Event

RTENOTITLE

 

Complete the following fields:

• Asset: Select the Asset. 

Note: The system allows for a fuzzy search: input at least 4 characters to locate the machine.

• Status: Select the status of the asset. Options are: Running, Unscheduled Down, Scheduled Down, Setup, Idle, Spare, In Maintenance, Calibration.

 

Figure 3: Asset Status

Figure- DCAsset status

• Running - It is used to up the asset without location, shop order, part number or it can record the period shift Finish Qty/Good Qty(optional).
• Unscheduled Down- It is used to record the asset unscheduled downtime event.
• Scheduled Down - It is used to record the asset scheduled downtime event.
• Setup - It is used to record the production line/asset setup time during the preparation.
• Idle - It is used to record the asset idle time when the asset is up and running, but it does not produce any product.
• Spare - It is used to record the asset non-schedule time. 
• In Maintenance - It is used to record the maintenance time when the maintenance team performs the asset maintenance.
• Calibration - It is used to record the calibration time when the maintenance team performs the asset calibration.

 

• Start Time/End Time: Select the date of the asset event using the drop-down calendar. Then select the time using the adjustable timestamp at the bottom of the calendar form. (Note: If the event time corresponds to real-time, there is no need to manually select the time - the system records real-time when the date is selected.)
• Reason: Select the reason for the asset event from the drop-down menu provided.

Note: Reasons are configured within the Asset configuration module of the CMMS (Computerized Machine Maintenance System) under the Problem category. This association links Asset (machine) problems with their corresponding downtimes.

Note:  If users report Asset running events, they can input the Shop Order, Part Number, and Location. When inputting the Start Time and End Time, theFinished QTY and Good QTY will display.

 

Figure 3a: Report Running Event

Once the information has been successfully entered, select Next.

Figure 4: Report Events-Next

 

 

5. Select the next Status, Start Time, then select the Green Checkbox to save the asset event. Or Select the BACK to double-check the event information.

  Figure 4a: Report Running Events

  

 

Report Reason and Report Downtime Per Interface

Once the repair is complete, users must report the Reason for the asset malfunction. 

The type of interface used by each individual plant to gather data will determine whether downtimes and reasons are sent automatically by the MES, or recorded manually by Shop Floor Operators. The following rules apply:

• Fuji Host Interface: Downtime and Reason automatically retrieved from Fuji; no human involvement.
• Auto PLC Interface: Downtime and Reason automatically retrieved from PLC; no human involvement.
• Semi-automatic PLC Interface: Downtime retrieved from PLC; Reason must be entered by Operator.
• No machine Interface: Downtime and Reason must both be entered by Operator.

For directions on how to configure automatic interfaces see: Automatic OEE Configuration Data Collection section.

 

Figure 5:  Reasons

 

To record a Reason for a asset downtime:

1. Select the line of data describing the downtime by choosing the Edit icon.
2. A pop-up window displays: Report Asset Down.

Note: The only field available for the edit is the Reason field. Only Reasons noted as "Unclassified" is available for edit.

3. Select the Reason from the drop-down menu.
4. Select the checkmark to save the reason.

Note: Reasons are configured within the Asset configuration module of the CMMS (Computerized Machine Maintenance System) under the Problem category. This association links Asset (machine) problems with their corresponding downtimes.

Figure 6: Edit Asset Event

 

 

 

Time Split

 

The Time Split feature allows operators to record multiple downtime events relating to the same asset. Time Splits cannot be added until Reasons are recorded.

1. Select the specific asset down the record by highlighting the line of data.
2. Select the Time Split icon:

Figure 6: Time Split Icon

 

3. The Split pop-up window displays.

Figure 7: Time Split

 

4. The operator can select the time (slide the blue bar) for the new split downtime event and select the new Reason from the drop-down menu provided. Note: Reasons are configured within CMMS Asset > Problem portal of 42Q.
5. Select the checkmark screen at the bottom to generate the new split downtime event record.

 

 

Root Cause

The Root Cause of the downtime problem is recorded by an engineer after the asset is repaired. Root Causes are based on the Reason recorded as well as a thorough inspection of the stopped asset. Root Cause information is used to compute OEE Configuration Trend Reports: Trend reports provide valuable insight into productivity. All plants are required to input Root Causes so that accurate and useful OEE Configuration data is available.

1. To add a Root Cause, select the desired asset down the record by highlighting the line of data.
2. Select the Root Cause icon:

Figure 8: Root Cause Icon

3. The Root Cause window will display.
4. Select the + button to add the root cause to the selected downtime record.

Figure 9: Add Root Cause for Asset Downtime



 

Root Cause Configuration Example

1. In the example, (below) the engineer may select the second-level category root cause.
2. Select the category by double-clicking on the title. Preconfigured Root causes then populate on the right-hand side of the window (Lack of Steel Plate M004, etc. in the example figure below ).

Note: Root Causes and Categories are defined in the Configuration module of OEE Configuration (Shop Floor Control > Configuration > OEE Configuration > Root Cause > Root Cause Category). See Configure a Root Cause and Category

3. Select save (checkmark icon) to add the new root cause to the selected downtime event record.
4. Other Cause textbox: Engineers may add a new root cause to the Root Cause Category by entering the cause into the Other Cause textbox. Once saved, the new Root Cause is added to the system and available for selection in other records.

Note: The system does not allow users to save or edit more than one Root Cause Category at a time. Each Root Cause Category must be saved separately using the save/checkmark icon. If the engineer would like to add a Route Cause from a different category, s/he must first complete the initial Root Cause by selecting the save/checkmark icon; then return to complete a second Root Cause Category.

 

5. Once saved, the system returns the user to the Add Root Cause page (see below), and the newly created Root Cause details display.

Figure 10: Root Cause Page

6. Select the + icon to add an additional Root Cause from a different category. Note: The system does not limit the number of Root Causes per downtime record.

Figure 11: Add Another Root Cause for Asset Downtime

Figure 12: Root Cause Successfully Added

 

Root Cause Error Message

 

Root Cause Categories with no associated Root Causes cannot be completed. The following error message displays (see figure, below). Return to the configuration submodule to define root causes (Shop Floor Control > Configuration > OEE Configuration > Root Cause).

Figure 13: Root Cause Error Message

9. To Delete a Root Cause from the downtime record, select the root cause by activating the checkmark, then select the trash bin icon.

Figure 14: Delete Root Cause

 

 

 

Report Work

 

In the Report Asset Event module, operators report details about their shift to include the following:

• Work Time: The operator enters the beginning and end times of their shift. This data represents the Performance variable of OEE Configuration.
• Finished Quantity: The operator enters the total number of units produced.
• Good Quantity: The operator enters the number of first-time quality units produced.

Taken together, Finished/Good Quantity represents the Quality variable of OEE Configuration.

 

Add Work Time

1. Click the"+" Icon .
2. Select Running from the Status field to Report a new work time record.

Figure 15: Report a New Work Time

Using Part Number/Part Family or Shop Order to link with the Target UPH value. If a Part/Family has been set up for more than one location, then the user needs to select the location. The Asset Mapping will be mandatory to link the location with the part information.

3. Complete the following fields. 

• Asset: Select the Asset. Note: The system allows for a fuzzy search: input at least 4 characters to locate the asset.
• Status: Select Running.
• Shop Order:  The shop order is optional. The Shop Order number is used by the system as a search key to find the target value for the Performance factor (Expected UPH).
• Part Number: The Part Number is used by the system as a search key to find the target value for the performance factor.
• Location: The Location/Workstation is used by the system as a search key to find the target value.
• Start Time: Select the start time using the drop-down list. 
• End Time: Select the end time using the drop-down list.
• Target UPH/Target QTY:  The value automatically populates based on the target UPH value defined at the target maintenance.
• Finished QTY: Enter the total quantity completed.
• Good QTY: Enter the number of completed items that successfully met quality standards without rework. 

Once data is entered, the Next on the bottom of the form becomes available. 

Select BACK to double-check the information, or select the Status for the next status then select the checkbox to save the asset work information.

Figure 16: Report Asset Event(Work)

Figure 17: Report Asset Event(Work) List

Note: The Finished QTY and Good QTY will be unavailable if the Target UPH/Target QTY is 0.

 

Edit Work Time

 

The operators may modify the Finished QTY and Good QTY of the existing work time using the Edit feature.

1. Select the production report for modification.
2. Select the Edit icon (pencil) located on the far right of the screen.
3. The Production Report Window displays, allowing the operator to adjust data.

Figure 18: Edit Work time

4. Change the Finished QTY or Good QTY as needed.
5. Select the checkmark icon to save the changes.

Bulk upload Asset Event

OEE Data Collection module supports the users to upload the asset event from files. First download the template file, make your own asset event data at your local file, then upload the file to input asset events in bulk.

1. Select the second button at the OEE Data Collection main page.
2. At the Upload File, select the X icon to download the template file.
3. Make your own asset event data at your local.

Figure 19: Download the Template File

4. Please see the following example data for those Asset Event status import data format.

• Unscheduled Down

asset_id, start_time, end_time, status, problem, part_number(optional), shop_order(optional) , root_cause (optional), description (optional)

• Scheduled Down

asset_id,start_time, end_time, status, problem,part_number(optional), shop_order(optional), description (optional)

• Setup, Idle, Spare, In Maintenance, Calibration

asset_id,start_time, end_time, status, description (optional)

Figure 19a: Unscheduled Down

 

Figure 19b: Scheduled Down

 

 

Figure 19c: Idle Down

 

5. Select the Choose File button to select the local asset event csv file, the file name will show.

Figure 20: Choose the Asset Event File

 

 

6. Select the Check Mark to upload the asset event data in bulk.
7. If uploaded successfully, the message will show.
8. If uploaded fails, it will generate an error file that allows users to download to view the error message.

Figure 21: Bulk Upload successfully

 

Figure 22: Bulk Upload Failed

 

Search and Export Asset Event

OEE Data Collection module supports the users to search and export the special asset event data into a local file.

The filters can be : Periods Dates(From,To), Assets, Group by (Line, Location, Department) Operator, Shop Order.

Figure 23: Search and Export Asset Event

 

Refresh the Target QTY

At the OEE Data Collection main page, the users will be able to click the refresh button for the specific missing target UPH record for the running status asset event, the backend system will call MES-API to get the refresh Finished QTY, Good QTY and Target UPH record data within 1 hour.

Figure 24: Refresh the QTY - Before

 

Figure 25: Refresh the QTY - After

 

Automatic OEE Configuration Data Collection

As noted in Report Reason for Machine Downtime Per Interface, OEE Configuration variables (Performance, Availability, and Quality) can be collected manually or automatically, depending upon the type of interface used by the individual plant. This section describes how to set automatic interfaces.

The following interfaces are used to auto-collect production data:

• MES 101 interface
• Fuji interface
• PLC/Rapid IIoT Gateway interface

The below diagram illustrates the major data sources required to calculate OEE Configuration automatically; manual entry and manual correction are still supported at OEE Configuration Data Collection.

Figure 26: Major data sources required to calculate OEE Configuration

MES 101 Integration

 

MES 101 allows OEE Configuration to gather Performance & Quality data from MES automatically, thus avoiding possible human errors resulting from manual entry. The process saves labor time and ensures data (e.g. Finished Qty, Good Qty, Target UPHs, shop order, Start/End Intervals, etc.) is accurate and up-to-date. The automatic data retrieval also reduces the need for operation training, thereby simplifying implementation, and reducing costs.

 

Configuration Steps

 

In order for the system to get the Production data and target data, users must map the Asset to the Location in the OEE Configuration system (Shop Floor Control > Configuration > CMMS Asset > Asset Mapping).

1. Go to: Shop Floor Control > Configuration > CMMS Asset > Asset Mapping.
2. Add Client ID, and Location Name.
3. Select Asset ID with the drop-down feature.

Note: Mapping configuration is completed only once.

Figure 26: Shop Floor and Asset Mapping

• Client ID: The Shop Floor ID.
• Location Name: Enter the MES101 Location. Location maps Asset status to defined target values in order to capture OEE Configuration Quality and Performance data.
• Device ID: The Device ID for the MES101 Location, such as NetDC, Emulator.
• Asset ID: Asset that defined in CMMS > Asset.
• Status: Active mapping in blue tick, inactive mapping in the grey tick.

 

 

Fuji Integration - Fuji Host Interface

 

Factories with Fuji AMEX & NXT machinery utilize the MESAgent application to sync Fuji machine downtime raw data and error codes with the OEE Configuration database.

The below diagram lists the process that Fuji Interface follows to collect the data.

Figure 28: Collect Data from Fuji

Fuji Host Interface - the OEE Configuration system can retrieve the machine Up, Down/Reason through the Fuji Host Interface/MESAgent Client automatically. The Fuji Host Interface up/down, down reason is the same as the PLC up/down, down reason signal which comes from the machine automatically. When using this approach, the Fuji Host Interface can only be used along with the NXT & Aimex modules.

Following are the steps to run the Fuji Interface:

1. Install Fuji Host Interface at the production Fujitrax PC. The Host Interface application is included in the Fuji installation CD with installation instructions.
2. Install the MESAgent Client (42q Application) in the production Fujitrax PC. It will keep listening to the machine Up & Down/Reason signals from the Fuji Host Interface and will forward it to the 42Q OEE Configuration system.
3. Set up the machine downtime Error Code (to map Asset's Problem Code) at the OEE Configuration Configuration module.
4. Once mapped, users may view Downtime Root Cause Analysis Reports, Downtime Problem Reports, Downtime Trend Analysis Reports, and others in OEE Configuration Reports.

Note: The Fuji Host Interface and MESAgent are installed by the Administrator or Support team. See How to use Fuji Host Interface for more details.

 

PLC Interface Overview

 

OEE Configuration application availability of Layer 2 drivers (Kepware) to perform data capture from Machines or PLCs and transfer to 42Q Via Rapid IIoT</a>.

Kepware IIoT will be set up to monitor the downtime reason code tag. Once the machine is down, IIoT will detect the reason code tag value change and send a signal (which includes the reason code and timestamp when reason code changes) to the 42Q OEE Configuration downtime process, then 42Q OEE Configuration process will process this signal and mark corresponding downtime record with corresponding problem code mapped to this specific reason code. The following diagram illustrates configuration steps.

Figure 29: Collect Data from PLC

The OEE Configuration system can retrieve the asset's Up/Down and Reason signals from a PLC Connection, thus removing the need to record reasons (Report Downtime) and manually enter work time (From/To) and Finished/Good Quality.

 

 

PLC Integration Steps

1. Install a third-party middleware (such as Kepware) software to communicate with the PLC and forward payloads to 42Q IIoT APIs.
2. Work with the 42Q automation engineering to test and set up the PLC connection.
3. Set up the machine downtime Error Code (to map Asset's Problem Code) at the OEE Configuration Configuration module.
4. Once mapped, users may view Downtime Root Cause Analysis Reports, Downtime Problem Reports, Downtime Trend Analysis Reports, and others in OEE Configuration Reports.

Note: Steps 1 and 2 are completed by Administration or Support team.

Glossary

• MTBF: Mean time between failures (MTBF) is the predicted elapsed time between inherent failures of a system during operation.
• MTTR: Mean time to failure (MTTF), measures the average time between failures.
• Quality: An OEE Configuration variable that depicts the number of good products divided by the number of bad products.
• Target Yield: The ideal yield for a given asset, against which the actual yields are measured; critical status is displayed based on the comparison of target yield and actual yield.
• Availability: Machine Downtime, according to duration. Takes into account all machine downtime to include minor stoppages, slow production, and idling. Calculated as: Operation Time/Planned Production Time = Availability
• Loading: Represents the percentage of time that an operation is scheduled to operate compared to the total Calendar Time that is available. Calculated as: Scheduled Time/Calendar Time = Loadingdar Time = Loading
• OEE Configuration: Overall Equipment Effectiveness is a manufacturing metric that identifies the percentage of productive manufacturing time according to Quality, Performance, and Availability. It is the single best metric for identifying losses, benchmarking progress, and improving the productivity of manufacturing equipment. Calculated as: Availability x Performance x Quality = OEE Configuration
• Performance: A measure of productivity, specifically the speed at which parts are built. Calculated as: Actual Rate/Standard Rate = Performance
• PLC: Programming Logic Control
• Quality: The percentage of parts that meet quality standards without rework. Calculated as: Good Units/Total Units = Quality
• TEEP: Total Effective Equipment Performance. Calculated as: Loading x OEE Configuration. Measures OEE Configuration against the total available production time.
• UPH: (Units Per Hour). is a throughput metric portrayed as a number. UPH is typically assigned to high volume processes. Answers the question: How many units are built in this process per hour?
• Cycle Time: (Time/Hours per Unit) is the time it takes to produce 1 unit in the (UPH) process. Cycle time and UPH metrics are dependent. One is a function of the other. Cycle Time is the hours per Unit.
• Throughput: Units Per Hour.
• Client: The firmware, software, or hardware system used to capture and send data from assets on the factory floor to the 42Q API. Commonly used clients include Fuji AIMEX, and PLCs. This concept is directly connected to Rapid IIoT.
• MESAgent: It is a interface (MESAgent, Fuji-OEE Configuration interface) application to collect Fuji data to 42Q OEE Configuration system.

---