To analyze shop floor data, you must first acquire the data from sources such as ERP applications, Manufacturing Execution Systems (MES), and Quality/Laboratory Information Management Systems (LIMS) as well as from shop floor sensor devices mounted on machines. Oracle Adaptive Intelligent Apps for Manufacturing (AIAMFG) provides CSV file-based upload tools to collect data. Users can extract structured data from external source systems and semi structured data from machines and equipment sensor devices and load them into the data lake in Oracle Cloud. Equipment and sensor device data is then contextualized with equipment and work order information and summarized for analysis.
You can use spreadsheet templates and REST web services in AIAMFG to load data from various information technology and operational technology systems. Upload this data for any historical period and for one or more products using periodic and incremental batch uploads. The application also provides out-of-the-box integrations between AIAMFG and Oracle E-Business Suite (EBS), which enable the collection of data from EBS applications.
Import enterprise or business data into AIAMFG using CSV file templates. Two types of data uploads are supported, one for upload of prepared data for quick analysis and the other a detailed upload of entities to take full advantage of all AIAMFG features. Users may choose the upload method that meets their requirement. Oracle partners can help users extract data from external source systems and load the data into the AIAMFG data lake in Oracle Cloud.
Upload case record data to obtain insights and predictions on historical data and in-progress work orders. Case Record Data CSV files captures data like item number, reference information like work order number, actual start date, actual end date, operation code, and attributes which can be targets or input features. Use this data, captured in a flattened file format, for data preparation, and then model building. Upload case record data in order to take advantage of AIAMFG features like Insights and Predictions.
Upload business entity data to capture the key entities from external source systems, entity by entity. Use this data in AIAMFG for data preparation and subsequent model building, as well as trace analysis. The CSV data files capture data for individual business entities such as items, lots, departments, persons, machines, receiving, work orders, quality, and so on. AIAMFG stitches all of the uploaded data together for analysis by relating the underlying data structures. Upload business entity data in order to take advantage of all AIAMFG features, including Insights, Predictions, Genealogy and Trace, and Factory Command Center.
Import sensor stream and alert data from shop floor sensor devices into AIAMFG using CSV files. The sensor data is contextualized with the business entity data and summarized for analysis. Separate templates are available for sensor stream and alert data.
Oracle partners can help users to configure machine data acquisition systems, such as Supervisory Control and Data Acquisition (SCADA), Distributed Control Systems (DCS) and other gateway device systems, to extract machine sensor data into the CSV file format. Users can then upload these sensor data files into AIAMFG in batch mode. The application processes the sensor stream data (for example, temperature) and alert data (for example, idle, paused), contextualizes it with equipment and work order information, and then summarizes the contextualized data for analysis.
Users can ingest data into AIAMFG using either CSV files or out-of -the-box integration tools such as Oracle Data Pump and Oracle GoldenGate.
Users can import both structured and semi-structured data into AIAMFG using CSV files. Oracle partners can help users to configure and map data from external data sources into seeded templates for upload into AIAMFG. The process of extracting, configuring, and mapping the data from an external data source to a CSV file is the same irrespective of the data ingestion method used.
AIAMFG provides three distinct user interfaces to import case record, business entity, and sensor data. Users can extract the data from external systems, enter the data into seeded templates, and then import the data into the application using these user interfaces.
AIAMFG provides three REST services to import Business Entity data into AIAMFG using CSV files. Download a seeded template, enter data as suggested in the template guidelines, and then save the template as a CSV file. You can then import/upload the data file by calling a REST service. See: REST Web Services, Oracle Adaptive Intelligent Apps for Manufacturing User's Guide.
AIAMFG provides out-of-the-box integration with Oracle E-Business Suite applications using Oracle Data Pump and Oracle GoldenGate. Oracle Data Pump enables high-speed transfer of data and metadata from a source database to the target database. Oracle GoldenGate provides near real time replication of data and real time capture, routing, and delivery of data across databases.
The following table compares the types of data available for ingestion with the various ingestion methods and features you can choose from.
Additional Information: By importing Business Entity work order CSV files, you are able to import work orders that have not started or have partially progressed. By creating appropriate models with these work orders, you can make predictions for yield and quality attributes.
Data Ingestion: A Comparison
The Oracle Adaptive Intelligent Apps for Manufacturing Data Ingestion process consists of the following steps:
Copying a template to use as the basis for a CSV file, which matches the requirements of the target application table. Oracle and its partners can help users to configure and map the data.
Following an upload process to load the data files from the source system or local machine to storage cloud services.
Using data import programs to import data from interface tables in Oracle Storage Cloud Service to the AIAMFG tables in Oracle Database Cloud Service.
Oracle Storage Cloud Service serves as a storage area for uploaded CSV files and contextualized machine sensor data.. It also stores enterprise data from external ERP systems such as JDE, SAP, SCM Cloud, EBS, or shop floor systems such as MES and LIMS. Both sensor and enterprise data are captured in a CSV file format and stored in the Storage Cloud.
Oracle Database Cloud Service serves as the data lake for AIAMFG by storing data for analysis. The types of data stored in this database include Enterprise Resource Planning (ERP) application data, Manufacturing Execution System (MES) data, Quality/LIMS data, sensor device mapping definitions, and summarized machine sensor data. This data is used for model building and analysis, lot genealogy, presenting the manufacturing time line, and providing a real-time overview of factory events in the Factory Command Center.
When uploading data files using Data Ingestion templates, follow these guidelines:
Prepare the Business Entity, Case Record, or Sensor Device CSV data files as shown by the CSV templates.
Save and upload the data files as CSV files. Other formats are not supported.
Limit each data file size to less than 5 GB. If a file's size is greater than 5 GB, then split the data into more than one file.
Verify that the column names in the data file match the column names in the template. The order of the columns in the data file do not have to match the order of the columns in the template, but should you change the order of the columns, you must include all the columns, along with the mandatory columns. Ensure that the same column is not repeated by mistake.
When uploading data files directly into the Storage Cloud, all file names within the same folder must be unique.
Perform the following setup steps in order to ingest data:
Define organizations. See: Defining Organizations.
Define users, which includes the following tasks. See: Creating and Managing Users, Oracle Adaptive Intelligent Apps for Manufacturing User's Guide.
Add a new user.
Assign the user to an application and a role.
Assign organization access to a user.
Define user preferences. See: Defining User Preferences, Oracle Adaptive Intelligent Apps for Manufacturing User's Guide.
Important: In order to upload business entity CSV files, a user must set their user preference to an organization that allows business entity data ingestion only. Similarly, in order to upload case record CSV files, set your user preferences to an organization that allows case record data ingestion only.
When defining organizations, consider the following information:
A single AIAMFG instance can support multiple organizations of different organization types. An organization's type is based on the type of data ingestion supported by the organization:
Business entity data ingestion only.
Case record data ingestion only.
Replicated business entities from an EBS source.
Create Case Record and Business Entity organizations manually through the AIAMFG user interface Create Organization page. EBS organizations are automatically created in AIAMFG via Data Pump and GoldenGate synchronization. You can upload sensor data for either a Business Entity or an EBS organization.
Each organization in AIAMFG, depending on its type, can uniquely ingest data from only one of the following sources:
Business Entity CSV files.
Case Record CSV files.
Oracle Data Pump and GoldenGate synchronization.
If you intend to ingest data from EBS by using Oracle Data Pump and GoldenGate, you must complete the EBS organization Data Pump load before ingesting data for Business Entity or Case Record organizations.
You can ingest a limited selection of business entities from non-EBS sources into an EBS organization using Business Entity CSV files. These business entities include:
Quality data.
Machine time.
Operator time.
The following chart summarizes which type of organization to use with each type of data ingestion method.
AIAMFG displays analysis data by organization, so data collected from various data sources using different ingestion methods belongs to a unique organization code. Each organization lists the ingestion method under the organization name:
Case record data ingestion enabled: manually created organization that ingests case record data only.
Business entity data ingestion enabled: manually created organization that ingests business entity data and sensor device data.
Business entity data replication enabled: indicates an EBS organization created using GoldenGate synchronization, which also replicates the business entities from EBS. In addition, the organization can ingest business entity data from non-EBS sources such as quality data, equipment time, and operator time, using CSV files.
Navigate to the Create Organization page.
From the Setup page, click Organization Access, then Create Organization.
In the Name field, enter a unique name for the organization.
In the Code field, enter a unique organization code.
Select one of the following organization Types:
Discrete Manufacturing
Process Manufacturing
Select the Data Ingestion organization type:
Allow case record data ingestion only
Allow business entity data ingestion only
Click Create.
AIAMFG is supported on multiple web browser platforms. Support is provided by Oracle on all platforms for which the browser vendor provides support. For mobile device operating systems, Oracle provides support for the most recent browser delivered by the device operating system only.
Platform | Google Chrome | Mozilla Firefox | Microsoft Browsers | Apple Safari |
---|---|---|---|---|
Android | Not Supported | Not Supported | N/A | N/A |
iOS | Not Supported | Not Supported | N/A | Supported |
Mac OS X | Supported | Supported | N/A | Supported |
Windows | Supported | Supported | Supported* | N/A |
* Internet Explorer 11+ and Microsoft Edge, although the Network Viewer in the Genealogy and Trace page does not display when using Internet Explorer. Support for Microsoft Browsers will follow the same N-1 (the most recent version plus one previous release) support policy that iOS provides.
Compatibility Mode: For Windows Browsers, only Native mode is supported. View Compatibility mode should be disabled.
JavaScript: JavaScript support must be enabled.
Doctype: To use AIAMFG on Microsoft Internet Explorer, a doctype is required.