Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date

What's Changed

Notes

14 JUN 2018

Created initial document.

Overview

This guide outlines the information you need to know about the first release of Oracle Adaptive Intelligent Applications for Manufacturing (Release 18.2) and describes any tasks you might need to perform for the update. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.

Security & New Features

We would like to remind you if your system has modified security structures you may need to advise your security administrator of new features you would like to take advantage of. To assist you Appendix A provides a listing of the new features and the security attributes needed to employ the new features when you have decided to implement them.

Give Us Feedback

We welcome your comments and suggestions to improve the content. Please send us your feedback at AIMFGCS_help_ww_grp@oracle.com.

Feature Summary

We continue to add many new features to Oracle Cloud Applications and we now give you the option to take advantage of new functionality at a pace that suits you. The ‘New Features UI’ is available to you from your cloud homepage, where you can make your choices and do any configuration necessary. The table below offers a quick view of the actions required to enable each of the new features.

Action Required to Enable Feature

Feature

Automatically Available

End User Action Required

Administrator Action Required

Oracle Service Request Required

Acquiring and Storing Data

Setup Sensor Devices

Upload and Contextualize Sensor Data

Preparing Data

Setup Time Series Feature Sets

Create Analysis Data Preparation Request

View Sensor Summary Results

Analyzing Data

Create Analysis Models

Analyze Significant Features

Evaluate Patterns From Insight Models

Evaluate Prediction Models

Deploy Models

Presenting Data

Insights From Historical Data Analysis

Predictions From Current Production Data Analysis

Genealogy and Trace Analysis

Managing Security and Access Control

User Roles and Organization Access

User Preferences

Background Processes

Background Processes

Oracle Adaptive Intelligent Applications for Manufacturing

Oracle Adaptive Intelligent Applications for Manufacturing is a unique SaaS (subscription based) offering on the Oracle Public Cloud that collects, stores, and analyzes massive amounts of Operational Technology (OT) data coming from shop floor systems such as Equipment, Machines, Sensors, Test Stations etc. and contextualizes it with Information Technology (IT) data coming from business applications such as SCM, ERP, HCM, CRM, MES, Quality and analyzes it by applying machine learning, data mining, and artificial intelligence techniques to discover key patterns and correlations that affect manufacturing efficiencies and provides actionable predictive analytics to maximize yield, and minimize defects, scrap, cycle times, costs etc. It also provides comprehensive capabilities for backward and forward tracing of products and processes within manufacturing and supply chain spanning manpower, machine, material, method and management aspects to facilitate rapid root cause, impact and containment analysis.

Initial release of Adaptive Intelligent Applications for Manufacturing Cloud Service consists of following components:

Acquiring and Storing Data

Oracle Adaptive Intelligent Applications for Manufacturing provides a number of CSV templates to ingest historical manufacturing operations data from a wide variety and heterogeneous mix of Information Technology (IT) systems spanning ERP, MES, Quality/LIMS and Operational Technology (OT) systems that include equipment, machines, and other sensor enabled shop floor devices and environmental data.

The application provides a robust and comprehensive data lake to store data from ERP/SCM/CRM/HCM/MES/Quality systems in Relational/Structured data store, to store data from various machines and sensors such as temperature, pressure etc. in Time Series data store and to store notes, comments and log files in Unstructured data stores.

Setup Sensor Devices

Using Sensor Devices UI, user can register the sensor devices and map the devices to equipment instances defined in the ERP system. User can search and manage sensor device definition and mapping between sensor device and equipment instance.

Create Sensor Device Mapping Screen

Create Sensor Device Mapping UI provides the Device and Equipment related fields to register the sensor devices and map to an equipment.

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator role to be able to access the UI.

Tips and Considerations

There can not be more than one sensor device that can be mapped to a given process parameter of the equipment instance.

Key Resources

Upload and Contextualize Sensor Data

User can manage batch processing of time series data generated from shop floor machines by uploading the data in csv file format and store the data in Oracle Storage Cloud Service. The uploaded data gets contextualized with the resource and work order information.

Upload File Screen

Using Upload File UI, user can upload the files with the csv or csv.gz format. User can download the template to review instructions and the sample data before uploading the csv format file. User can either uploaded the sensor stream data or the event/alert data.

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator role to be able to access the UI.

Tips and Considerations

There can be only one file included in the csv.gz format and can not exceed the size 5GB.

Key Resources

Preparing Data

Oracle Adaptive Intelligent Applications for Manufacturing provides robust capabilities to prepare the data for analysis by extracting the features from time series data and features from structured data.

Setup Time Series Feature Sets

Using Time Series Feature Sets UI, user can configure the segments required to slice the time series data and configure the summary functions that can be used in the data mining analysis as features.

Create Time Series Feature Sets Screen

Create Time Series Feature Sets UI provides the various time segments and summarization functions to create features out of the time series data.

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator role to be able to access the UI.

Tips and Considerations

According to the requirement of analysis of data, user has to carefully choose the time segments and functions in creating the time series feature sets and assign to applicable process parameters (like Temperature, Pressure etc) defined in the sensor device mapping screen.

Key Resources

Create Data Preparation Request

Data analyst or data scientist can submit a request to extract the seeded meta data of features for a defined context from structured data from transactional applications for manufacturing operations, semi-structured data like equipment time series data and custom predictors from other systems like LIMS, MES etc.

Create Analysis Data Preparation Request Screen

Create Analysis Data Preparation Request Screen provides the following fields to define the context.

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

The meta data or features extracted belongs to the the operation of the data prep context and all the previous operations as per the routing. The data preparation request has to be created with an operation of focus of analysis.

Key Resources

View Sensor Summary Results

After the successful creation of data prep request, data analyst or data scientist can analyze the results of sensor summary for a given data preparation request. Sensor Summary Results UI provides user to view the details about the time series features created for all the process parameters of resources having the time series feature set assigned. The Time series features are generated during the process of creating analysis data preparation request. User can drill into a specific parameter to understand and compare the summary function values of features across the work orders in the data set.

Sensor Time Series Features Screen

Sensor Time Series Feature UI provides following:

Sensor Summary Results Screen

Sensor Summary Results UI provides following:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

It is recommended to chose the wider work order completion date range having different variation of the data. Data mining analysis gives the best results when the volume and variations are rich in the data.

Key Resources

Analyzing Data

It provides a simple and intuitive model building framework to allow data scientists to build, evaluate and deploy data mining models such as such as:

Create Analysis Model

After the successful creation of data prep request, data analyst or data scientist can build models to achieve different analysis such as Feature Significance, Insights and Predictions. The easy to use interface allows data scientist to easily drag and drop the features required, algorithm and parameters in building the models.

Create Analysis Model Screen

Create Analysis Model UI provides following tabs:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

Key Resources

Analyze Significant Features

After the successful creation of feature significance models, data analyst or data scientist can search for models and review the significant features that are ranked out of the analysis of a specific model.

View Significant Features Screen

Significant Feature UI provides following:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

Significant features are ranked with respect to the strength of the influence of the feature to a specific output or target measure.

Key Resources

Evaluate Patterns from Insight Models

After the successful creation of insight models, data analyst or data scientist can search for models and review the patterns generated out of the analysis of a specific model.

View Patterns & Correlations Screen

Patterns & Correlations UI provides following:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

Data scientist should review the patterns generated with the help of a business analyst having the business understanding and can publish the top 10 valid patterns as insights to the business user.

Key Resources

Evaluate Prediction Models

After the successful creation of prediction models, data analyst or data scientist can search for models and review the accuracy of the model using confusion matrix for a specific model.

Confusion Matrix Screen

Confusion Matrix UI provides following:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

After training the prediction model on the training data set, it is recommended to deploy a test production for few months to evaluate and compare the accuracy before moving the model to the production.

Key Resources

Deploy Models

After the successful evaluation of analysis models, data analyst or data scientist can deploy the right models in the production by search and deploy a specific model. Users can deploy any number of Insights models for a given context but there can only be one predictions model and one feature significance model deployed for a given context and output combination.

Model Deploy Screen

Model Deploy UI provides following:

Steps to Enable

Navigate to Setup to create a new user and associate the Application Administrator/Data Analyst/Data Scientist role to be able to access the UI.

Tips and Considerations

It is recommended to deploy the models on the test instance and evaluate the performance before deploying the same to the production instance.

Key Resources

Presenting Data

Oracle Adaptive Intelligent Applications for Manufacturing presents the results of the data mining analysis to business analysts and business users in an intuitive and simple to understand user interfaces.

Insights from Historical Data Analysis

The solution provides business users with the hidden insights on influencing factors impacting the production key metrics that are discovered from data mining analysis of the historical data. The insights are available to the users after the patterns are published as insights though the deployed insight models. The insights can also be exported to the third party systems using the outbound service APIs.

Quality Insights Screen

The insights landing page presents the insights under different chapters like Quality, Yield for Discrete and Process manufacturing and Quality, Yield, Serial Unit Quality and Serial Unit Yield for the serialized manufacturing. User can drill into a specific chapter to review all the insights across products in an organization. The Insights page for a specific chapter provides the following:

Insight Details Screen

The insight details UI presents comprehensive details around the influencing factors on how they impact the output by showing the correlation and distribution of the factors with the output/target measure in the historical dataset. The Insight details page provides the following:

Steps to Enable

Navigate to Setup to create a new user and associate the Business User/Data Analyst/Data Scientist/ Application Administrator role to be able to access the UI.

Key Resources

Predictions from Current Production Analysis

The solution provides business users with the prediction alerts generated from the analysis of current production data enabling users to detect the potential problems related to the product quality and yield early in the production life cycle before the production is impacted. The predictions dashboard provides comprehensive details on production issues, enlighten on the influencing factors thus empowering users with a window of opportunity to take corrective action based on predictions. The predictions details can also be exported to the third party systems using the outbound service APIs.

Quality Predictions Screen

The Predictions landing page presents the predictions under different chapters like Quality, Yield for Discrete and Process manufacturing and Quality, Yield, Serial Unit Quality and Serial Unit Yield for the serialized manufacturing. User can drill into a specific chapter to review all the predictions across products in an organization. The predictions page for a specific chapter provides the following:

Prediction Details Screen

User can drill into a specific running work order operation prediction to view the comprehensive details around influencing factors causing the output to fall under a predicted classification. The prediction details screen provides the following:

Steps to Enable

Navigate to Setup to create a new user and associate the Business User/Data Analyst/Data Scientist/ Application Administrator role to be able to access the UI.

Tips and Considerations

While deploying the prediction models, prediction frequency has to be setup so that the predictor data is available for the model when it runs.

Key Resources

Genealogy & Trace

Oracle Adaptive Intelligent Applications for Manufacturing solution provides the centralized visibility for tracking the critical quality issues of partially finished or finished products during the entire supply chain. With the advanced visualizations of connected network view and timeline view, it simplifies the tracing of entire genealogy of items and exploration of key events in production and keep track of the transactions spanning the entire supply chain.

Network Viewer Screen

The connected network view enables easy and interactive tracing of an item during the entire supply chain life cycle showing the details of components procured (internally or externally), consumed, products manufactured, outsourced, products shipped, returned, repaired, serviced in the field and re-shipped. User can easily identify the root cause of quality issues related to supplier material composition, production process parameters, machining issues by navigating between nodes.

Timeline Viewer Screen

Timeline view complements the Network view to help users drill down into a specific work order or a machine or a serial to explore the key events that happened during production. All the timed events related to production operations, material issues, resource usage, quality results and process parameter readings from sensor devices are presented for the entire period of production start to end. In case of machine, it will display machine alerts and key production events

Steps to Enable

Navigate to Setup to create a new user and associate the Business User/Data Analyst/Application Administrator role to be able to access the UI.

Tips and Considerations

User can add custom nodes using web services to connect them to the seeded nodes provided out of the box.

Key Resources

Managing Security and Access Control

Oracle Adaptive Intelligent Applications for Manufacturing provides authentication and authorized access to the application by defining the users and assigning predefined roles to provide access to the various functions of the application. It provides users controlled access to the organizations and enables users to configure user level settings or preferences for each module.

User Roles and Organization Access

Oracle Adaptive Intelligent Applications for Manufacturing enables the users with Application Administrator role to define users. The users can be assigned with the pre-defined roles like Application Administrator, Data Scientist, Data Analyst, Business User and Data Integrator to enable access to the different functions of the application.

Users & Role Assignments Screen

Users & Role Assignments screen provides Application Administrator the ability to add new users and also provides the seeded roles to which Administrator can assign users, revoke users, assign group of users and revoke a group of users.

Organization Access Screen

Organization Access UI provides Application Administrator to manage application user’s access to analysis data and dashboard contents by assigning user to multiple organizations depending on application data access and security requirements.

Steps to Enable

Using Users & Role Assignments UI, create users and associate roles to the users. Using Organization Access UI, assign organizations to users.

Tips and Considerations

Please refer to the list of functions accessible for various roles under Appendix A.

Key Resources

User Preferences

The application provides users to set up user level preferences to specify how information is displayed in the dashboards available for analyzing insights, genealogy and trace, predictions, and factory status.

User Preferences Screen

Using User preferences UI, user has to select a specific organization, category set which acts as the context for presenting the analysis results in the dashboards.

Steps to Enable

Under user name, choose the preferences.

Key Resources

Background Processes

Oracle Adaptive Intelligent Applications for Manufacturing provides background processes to contextualize the time series sensor data, to summarize the time series sensor data, to purge the time series data and to extract the oracle quality data.

Background Processes

Background Process Screen

Steps to Enable

Using Users & Role Assignments UI, create users and associate Application Administrator role to the users as the background processes is accessible only to Administrator role.

Key Resources

Appendix A: Function Security Privileges and Aggregate Privileges

Pre-defined roles have been provided for access to the Oracle Adaptive Intelligent Applications for Manufacturing. The roles and the functions they have access to are described below. A user can be assigned one or more roles.

Table A-1 Oracle Adaptive Intelligent Applications for Manufacturing Roles

Role

Function

Business User

AIMFG Business User Role

This role grants a user complete access to Predictions, Insights, Genealogy and Trace and Factory Command Center dashboards pages.

Data Analyst

AIMFG Data Analyst Role

This role grants a user complete access to Predictions, Insights, Genealogy and Trace and Factory Command Center dashboards pages. This role also grants access to Modelling, Model Evaluation and Data Preparation pages.

Data Scientist

AIMFG Data Scientist Role

This role grants a user complete access to Configuration, Time Series Feature Sets, Sensor Device, Modelling, Model Evaluation, Insights and Predictions dashboards pages.

Application Administrator

AIMFG Application Administrator Role

This role grants a user administrative access to the application. The administrator will have complete access to all functions of the application. This includes all the tabs (Background Process, Security and Configuration) of the Administration page through which the administrator will be able to manage background processed, organization access and application setup.

Data Integrator

AIMFG Data Integrator Role

This role grants a user data integrator access to the application. The Data Integrator can access REST APIs to copy data between systems.

---

A special Oracle logo highlighting Oracle's commitment to developing practices and products that protect the environment. copyrightlogo