News CNCnetPDM About us Support  
         

SCHEDULING | INTERNET OF THINGS

To perform any target to actual comparison and output Key-Performance-Indicators (KPI) such as Overall Equipment Effectivity (OEE) it was necessary to integrate scheduling data with the solution.

Goal:

  • Automatically import scheduling data from various sources into into a single data repository

On first sight this seemed to be a simple task as all information needed was present in the existing ERP solution that was used to print out the work order travelers. This included part-number, work-order, operation, scheduled start and end date and planned time for execution and setup. However, it quickly turned out that it was not enough to only work with data available in ERP as it simply was too inexact for doing comparisons for short periods down to single shifts or even hours. To be able to do that information from the department responsible for detailed planning also had to be included. In discrete manufacturing this typically is a more or less manual process where one, after assuring that everything needed to execute a work order at the machine is available, schedules the job for execution within a short period of time (shifts, days or weeks). This includes material, NC-program, tools and all paperwork (e.g. traveler, drawings) that accompanies the work piece at the shop floor.

Fortunately the customer already had chosen Oracle’s Manufacturing Operations Center (MOC) which is an ultra-flexible tool when it comes to bringing together data from different sources into a single data repository. In MOC scheduling data can be imported and updated by various techniques dependent on the source. On the one hand predefined adapters can be utilized to automatically pull in data from a broad range of existing ERP solutions or databases. On the other hand external programs can directly push data into MOC’s underlying database. If none of these methods can be used it is also possible to store text files (.csv) which contain the scheduling data in a predefined folder. MOC automatically reads the files in adjustable intervals and updates scheduling of the manufacturing resources.

To accomplish this task at the customer a combination of several methods was used. More static data like material, work-order or operation numbers was directly imported from ERP. For data from fine planning that may change from day to day initially the file based method was used. The responsible employees simply maintained an EXCEL spreadsheet that contained scheduling data for the most recent work orders. In case of changes the only requirement was to change and save the spreadsheet. To further reduce the effort the customer meanwhile uses a self-developed program that provides a dialog for this task. Instead of outputting a file the program pushes the data directly into MOC’s database.

Functions:

  • Acquisition and transmission of scheduling data from various sources into a single data repository

Benefits:

  • Enabled automatic collection of short-term (fine planning) and long-term (ERP) scheduling information
  • Minimized implementation costs by using easily adaptable interfaces to existing solutions

 

Privacy notice

This website uses cookies. By continuing to use it you agree to our privacy policy. 

https://www.inventcom.net/success-stories/internet-of-things/scheduling
Success Stories | Internet of Things | Overview
The Internet of Things (IoT) becomes reality for one of the top 500 fastest growing manufacturing companies in the US.... [read more]
Overview
Success Stories | Internet of Things | Machine States
The initial requirement of the customer sounded pretty simple: ‘We’d just like to know whether our manufacturing equipment is producing or not’. When standing... [read more]
Machine States
Success Stories | Internet of Things | Output Quantity
For any kind of measurement it’s imperative for manufacturers to know the amount of parts produced by the equipment. Now that the customer knew about the state of the... [read more]
Output Quantity
Success Stories | Internet of Things | Operational Data
Of course automatic reporting of machine-states and part counter values by the manufacturing devices was great progress but the customer now needed to see this data in context... [read more]
Operational Data
Success Stories | Internet of Things | Quality Data
To be able to create reports about the produced quality additional data from the shop floor was needed. Although it would have been perfect to get this data directly from the... [read more]
Quality Data
Success Stories | Internet of Things | Data Processing
Even having all required information in a single data repository again was good progress the next challenges were to put all data into relationship, build the desired reports and... [read more]
 
Success Stories | Internet of Things | Dashboards Overview
The customer's solution Oracle’s Manufacturing Operations Center (MOC) uses the concept of providing web- and role-based dashboards for different employees to gain the... [read more]
Dashboards Overview
Success Stories | Internet of Things | Production Supervisor
This dashboard acts like an electronic whiteboard that automatically fetches data from the customers shop floor devices and provides real-time information about equipment status... [read more]
Production Supervisor
Success Stories | Internet of Things | Overall Equipment Effectiveness OEE
The standard of Oracle’s Manufacturing Operations Center (MOC) ships with a dashboard called ‘Plant Manager’ which includes several reports that output Overall... [read more]
Overall Equipment Effectiveness OEE
Success Stories | Internet of Things | Production Loss Analysis
This dashboard outputs information about production loss distribution (B), effective production capacity (C) and production loss (D) for machines in a department of a plant... [read more]
Production Loss Analysis
Success Stories | Internet of Things | Equipment Downtime Analysis
This dashboard shows downtime reasons machines in one or all departments of a plant within a selected period (A). The pie chart (B) below the selection area outputs the... [read more]
Equipment Downtime Analysis
Success Stories | Internet of Things | Production Slippage Trend
This dashboard, accessible from the equipment downtime analysis report outputs, in addition to total production value (A), production slippage hours (B) and a performance to... [read more]
Production Slippage Trend
Success Stories | Internet of Things | Equipment Idle Time Reasons
By using this dashboard the reasons for idle times of machines within a selected period (A) can be analyzed. Right to the pie chart (B) with percentage distribution of... [read more]
Equipment Idle Time Reasons
Success Stories | Internet of Things | Equipment Efficiency Analysis
For selected equipment in one or all departments of a plant (A) this dashboard outputs an analysis about the efficiency of the manufacturing resources within a period of time. In... [read more]
Equipment Efficiency Analysis
Success Stories | Internet of Things | Equipment Scrap Analysis
This dashboard shows an analysis about bad quality produced by manufacturing equipment in one or all departments of a plant (A) within a selected period. Right to a pie chart (B)... [read more]
Equipment Scrap Analysis
Success Stories | Internet of Things | Batch Performance
This dashboard provides analytics tools for work orders executed within a selected period in all or single plants and product categories (A). The graph (B) on the left side below... [read more]
Batch Performance
Success Stories | Internet of Things | Production Performance
This dashboard enables comparison of scheduled with actual equipment usage. Output can be limited to one or all departments in a plant within a selected period (A). The... [read more]
Production Performance
Modified: 2015-11-22