Follow the steps and the OBIEE version compatibility in the APS Family Pack Readme.
Oracle Manufacturing Operations Center includes:
Manufacturing Operations Center catalog
Plant Manager Dashboard
Facilities Manager Dashboard
Adhoc Analysis
The Manufacturing Operations Center Catalog provides the Plant Manager, Facilities Manager, and Ad hoc Dashboards with performance areas related to manufacturing operations. It uses the ISA-95 (Instrumentation, Systems and Automation Society) structure to integrate Enterprise Resource Planning (ERP) and shop floor manufacturing equipment and systems transactions. This combination enables the catalog to provide operational analytics visibility. The catalog uses data from multiple sources and builds a logical data model providing industry-rich operational metrics to be analyzed by multiple dimensions and hierarchies.
See: Oracle Manufacturing Operations Center User's Guide for details.
The manufacturing performance areas include the following:
| Performance Areas | Description |
|---|---|
| Agility Responsiveness | Used to analyze flexibility related measures by system, plant, item, time and equipment. |
| Batch Analyzer | Used to analyze usage and production variance and other work order related measures by system, item, plant and time. |
| Equipment Attributes Data | Attributes associated to equipment entities. |
| Equipment Down Time Analysis | Used to analyze the downtime duration of equipment. |
| Equipment Event Action | Used to add and update event types and actions for equipment items. Using the Event Management Framework, MOC routes events and takes appropriate actions. |
| Equipment Scrap Analysis | Used to analyze the scrap quantity reported for the equipment at different points of time. |
| Manufacturing Asset Performance | Used to analyze overall equipment effectiveness and production loss analysis by system, plant, item, time, and equipment. |
| Plant Maintenance | Used to analyze maintenance related downtime measures by system, time, and equipment. |
| Production Performance | Used to analyze operation cycle time and its components of run, down, and idle time contributing to cycle time. |
| Quality | Used to analyze first pass yield, scrap, reject, and rework measures by system, plant, time, and equipment. |
| Schedule Adherence | Used to analyze production to performance and backlog related measures by system, plant, item, time, and equipment. |
| Service Level | Used to analyze manufacturing performance relative to pegged sales orders shipped using request and promise dates by system, plant, item and time. |
| Sustainability Performance | Used to analyze the consumption of sustainability aspect, the cost of sustainability aspect consumed, and emissions resulting from the usage of the sustainability aspect for an entity. |
| Production Sustainability Performance | Used to analyze the production output based on the sustainability aspect consumption. |
| Equipment Sustainability Analysis | Used to analyze the sustainability aspect consumption by equipment. |
Overall Equipment Effectiveness (OEE) is a key metric that every plant manager monitors. The Plant Manager Dashboard provides a complete view of the equipment and helps the plant manager to assess where the source for production losses occur. The Plant Manager Dashboard and integrated reports provide the plant manager views of the production data for the plant in terms of overall equipment effectiveness, batch performance, schedule adherence, and production loss analysis for the departments and equipment on the shop floor.
Oracle Manufacturing Operations Center collects data from disparate sources into this single role-based dashboard that allows Plant Managers and staff to view manufacturing operations efficiently and effectively. The open and flexible BI technology from Oracle Fusion Middleware makes it easy to build and modify KPI's and dashboards.
See: Oracle Manufacturing Operations Center User's Guide
The following table identifies the dashboard pages and the reports made available to the Plant Manager role:
| Dashboard Pages | Reports |
|---|---|
| Asset Performance (OEE) | Overall Equipment Effectiveness by Plant |
| Overall Equipment Effectiveness By Department (Bottom Performers) | |
| Overall Equipment Effectiveness Details By Plant | |
| Overall Equipment Effectiveness Details By Department | |
| Overall Equipment Effectiveness Trend by Plant | |
| Overall Equipment Effectiveness Trend by Department | |
| Asset Performance (OEE) by Equipment | Overall Equipment Effectiveness by Department |
| Overall Equipment Effectiveness by Equipment (Bottom Performers) | |
| Overall Equipment Effectiveness Details by Department | |
| Overall Equipment Effectiveness Details by Equipment | |
| Overall Equipment Effectiveness Trend by Department | |
| Overall Equipment Effectiveness Trend by Equipment | |
| Equipment Downtime Analysis | Equipment Downtime Analysis |
| Machine Availability Ratio Trend | |
| Equipment Downtime Reasons | Downtime Reasons |
| Production Slippage Trend | Production Slippage Trend |
| Production Loss Analysis | Production Loss Distribution |
| Effective Production Capacity | |
| Production Loss Analysis | |
| Production Loss Detail | Production Loss Detail |
| Equipment Efficiency Analysis | Equipment Efficiency Analysis |
| Equipment Performance Ratio Trend | |
| Equipment Efficiency Detail | Equipment Efficiency Detail |
| Equipment Scrap Analysis | Equipment Scrap Analysis |
| First Pass Yield Trend | |
| Equipment Scrap Reasons | Equipment Scrap Reasons |
| Batch Performance | Production Variance by Product Category |
| Production Variance by Product | |
| PPM Trend (Month to Date) | |
| Batch Cycle Time Trend (Month to Date) | |
| Service Level Performance by Product Category | |
| Service Level Performance by Product | |
| Batch Performance Detail | Batch Performance Detail |
| Production Performance | Performance to Schedule Measures by Plant |
| Performance to Schedule Measures by Department | |
| Performance to Schedule Measures by Equipment (Bottom Performers) | |
| Production Slippage (Equipment) | |
| Current Month Production Slippage Trend by Department | |
| Current Month Production Slippage Trend by Equipment | |
| Sustainability Performance | Electricity Consumption |
| Electricity Cost | |
| CO2 Emission | |
| Production Value Analysis by Product | |
| Trend by Period by All Departments | |
| Trend by Period by Department | |
| Ranking and Distribution - Department Ranking | |
| Ranking and Distribution by Department Ranking and Distribution by Usage Category |
The Facilities Manager Dashboard provides information and analysis of electricity consumption, electricity cost, and CO2 emission and helps the facility manager monitor the electricity costs and CO2 emissions. Facilities Manager Dashboard is based on seeded 5 levels Facility Hierarchy as follows:
Site
Building
Floor
Floor Section
Equipment
See: Oracle Manufacturing Operations Center User's Guide
The following table identifies the dashboard pages and the reports made available to the Facilities Manager role:
| Dashboard Pages | Reports |
|---|---|
| Summary | Electricity Consumption |
| Electricity Cost | |
| CO2 Emission | |
| Trend by Period- All sites Trend by Period - By Site |
|
| Ranking and Distribution- Site Ranking Ranking and Distribution - Distribution by Site Ranking and Distribution - Distribution by Usage Category |
|
| Site | Electricity Consumption |
| Electricity Cost | |
| CO2 Emission | |
| Trend by Period- All Buildings Trend by Period- By Building |
|
| Ranking and Distribution - Building Ranking Ranking and Distribution - Distribution by Building Ranking and Distribution - Distribution by Usage Category |
|
| Building | Electricity Consumption |
| Electricity Cost | |
| CO2 Emission | |
| Trend by Period - All Floors Trend by Period - By Floor |
|
| Ranking and Distribution - Floor Ranking Ranking and Distribution - Distribution by Floor Ranking and Distribution - Distribution by Usage Category |
|
| Floor | Electricity Consumption |
| Electricity Cost | |
| CO2 Emission | |
| Trend by Period - All Floor Sections Trend by Period - By Floor Section |
|
| Ranking and Distribution - Floor Section Ranking Ranking and Distribution - Distribution by Floor Section Ranking and Distribution - Distribution by Usage Category |
|
| Floor Section | Equipment Summary |
| Trend by Period - All Equipment Trend by Period - By Equipment |
|
| Ranking and Distribution - Equipment Ranking Ranking and Distribution - Distribution by Equipment Ranking and Distribution - Distribution by Usage Category |
|
| Electricity Consumption Trend | |
| Parameter Monitoring | |
| Equipment Status Trend | |
| Equipment Summary | |
| Equipment Hourly Summary | |
| Equipment Hourly Detail |
Ad hoc Analysis reports enable you to compare electricity consumption with any parameter like temperature or pressure for single or multiple time periods and single or multiple entities.
The following table identifies the reports made available for ad hoc analysis:
| Ad hoc Pages | Reports |
|---|---|
| Single Entity | Electricity Consumption and Parameter Monitoring |
| Multiple Entities | Electricity Consumption and Parameter Monitoring |
| Compare Periods | Electricity Consumption and Parameter Monitoring |
You must run the following process flows to refresh all of the Materialized Views (MV's) in the Oracle Manufacturing Operations Center (MOC) Plant Manager Dashboard.
MTH_REFRESH_ALL_MVS_INIT_PF
MTH_REFRESH_ALL_MVS_INCR_PF
Use these process flows to refresh all of the MV's in MOC using the complete refresh and fast refresh methods respectively. When running MTH_REFRESH_ALL_MVS_INIT_PF for a complete refresh, the process flow will first truncate all materialized views and materialized view logs used by those materialized views in MOC.
You can run the following process flows to refresh a particular materialized view.
MTH_REFRESH_ONE_MV_INIT_PF
MTH_REFRESH_ONE_MV_INCR_PF
Use these process flows to refresh one materialized view using the complete or fast refresh methods respectively. To specify the materialized view you want to refresh using those two process flows, you must overwrite the value of the variable V_MV_NAME with the name of the materialized view that you want to refresh.