News CNCnetPDM About us Support  


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.


  • 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.


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


  • 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.

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]

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]
Data Processing

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