Optimize Maintenance Intervals in Oracle Fusion Cloud Maintenance

Oracle Fusion Cloud Maintenance uses maintenance programs for managing asset maintenance. Oracle IoT Asset Monitoring Cloud Service can use IoT analytics on historical data from Oracle Fusion Cloud Maintenance to help provide maintenance interval recommendations for these maintenance programs.

Optimal maintenance of assets reduces unplanned failures, and helps minimize maintenance costs. The key to optimized maintenance is to ensure that assets receive the maintenance they need before parts fail. At the same time, optimization ensures that parts aren't replaced too soon, while they still have significant useful life.

For example, say you wish to optimize the maintenance programs on the data servers in your data center. The preventive maintenance guideline from the manufacturer recommends replacing hard drives every 365 days. Your maintenance programs in Oracle Fusion Cloud Maintenance are designed to follow this recommendation. Over time, some hard drives fail before reaching their scheduled maintenance interval, perhaps because data updates in your environment are more frequent than standard. Optimization helps analyze all the historical failures and replacements, and calculate the anticipated lifespans for critical parts. Oracle IoT Asset Monitoring Cloud Service then makes maintenance interval recommendations for the business' target reliability rate. You may accept these recommendations in Oracle Fusion Cloud Maintenance to slightly reduce the maintenance interval in your environment.

Oracle Fusion Cloud Maintenance provides the required historical data for analysis through OCI Object Storage using BICC (Oracle Business Intelligence Cloud Connector). Oracle IoT Asset Monitoring Cloud Service performs analysis on the ingested data to create recommendations for Oracle Fusion Cloud Maintenance. External data such as asset data, work order data, and maintenance schedules from Oracle Fusion Cloud Maintenance are stored and used to analyze asset failure patterns. Learning work-flows, and associated analytics entities, are then created to suggest optimal maintenance schedules for Oracle Fusion Cloud Maintenance.

Set Up Maintenance Interval Recommendations

Set up the Oracle IoT Asset Monitoring Cloud Service URL and credentials in Oracle Fusion Cloud Maintenance. Next, configure the external storage details in BICC (Oracle Business Intelligence Cloud Connector) and Oracle IoT Asset Monitoring Cloud Service. Finally, run the scheduled jobs in Oracle Fusion Cloud Maintenance to ingest data and trigger learning.

1. Enable IoT Integration in Oracle Fusion Cloud Maintenance
2. Enable the Integration and Configure OCI Cloud Storage Details in Oracle IoT Asset Monitoring Cloud Service
3. Configure OCI Object Storage in BICC
4. Configure BICC to Generate Gzip Extract Files
5. Extract Key Maintenance Data from Oracle Maintenance Cloud
6. Perform Learning on Maintenance Data

Enable IoT Integration in Oracle Fusion Cloud Maintenance

Add your Oracle Internet of Things (IoT) Asset Monitoring Cloud Service instance information in Oracle Fusion Cloud Maintenance.

1. In Oracle Fusion Cloud Maintenance, click Menu , and then click Setup and Maintenance under My Enterprise.
   The logged in user should have the SCM Implementation Consultant role in Oracle Fusion Cloud Maintenance to complete this exercise.
2. Click Tasks and click Search.
   Alternatively, you can select Manufacturing and Supply Chain Materials Management under Setup.
3. Search for the following string: Manage Asset Maintenance Parameters.
4. Click Manage Asset Maintenance Parameters in the search results.
5. Click Enable IoT and specify the connection details for your Oracle Internet of Things (IoT) Asset Monitoring Cloud Service instance.

   • URL: Use the following format:

     https://hostname/assetMonitoring

     Here, hostname is the host name of your Oracle Internet of Things Intelligent Applications Cloud instance.

   • User Name: Specify the user name for connecting to your Oracle IoT Asset Monitoring Cloud Service instance.
   • Password: Specify the password for connecting to your Oracle IoT Asset Monitoring Cloud Service instance.

     Note:

     If you change the password for connecting to your Oracle IoT Asset Monitoring Cloud Service instance in future, then you must update the password in Oracle Fusion Cloud Maintenance.
   • Confidence Threshold: (Optional) Specify a confidence threshold between 0 and 1. For example, a value of 0.8 indicates a confidence threshold of 80%. The confidence threshold is used for maintenance interval optimization.
6. Click Save and Close.

Enable the Integration and Configure OCI Cloud Storage Details in Oracle IoT Asset Monitoring Cloud Service

Use the Settings page in Oracle IoT Asset Monitoring Cloud Service to configure OCI Object Storage settings, and to enable integration with Oracle Fusion Cloud Maintenance.

1. In Oracle IoT Asset Monitoring Cloud Service, click Menu (), and then click App Settings.
2. Click the Settings tab ().
3. Under Cloud Account, add your cloud account details:
   1. Enter your Tenant OCID.
      The tenancy details are available from the Oracle Cloud Infrastructure Console. You need to log in to your Oracle Cloud Infrastructure Console. From the Profile menu, click Tenancy: <YourTenancyName>.
      The tenancy OCID is shown under Tenancy Information. Click Copy to copy it to your clipboard.
      
      

      

      
      
      Paste this value under Tenant OCID in Oracle IoT Asset Monitoring Cloud Service.
   2. Enter the User OCID.
      The user details are available from the Oracle Cloud Infrastructure Console. You need to log in to your Oracle Cloud Infrastructure Console. From the Profile menu, click User Settings.

      The user OCID is shown under User Information. Click Copy to copy it to your clipboard.

      Paste this value under User OCID in Oracle IoT Asset Monitoring Cloud Service.
   3. Click Generate Public Key.
4. Set the public key in OCI Object Storage.
   1. On the Settings page of Oracle IoT Asset Monitoring Cloud Service, under Cloud Account, click Copy against Public Key to copy the public key that you generated earlier.
   2. Log in to your Oracle Cloud Infrastructure Console.
   3. Under the Profile menu, click User Settings.
   4. Click API Keys under Resources.
   5. Click Add Public Key.
      Note: If three public keys are already listed under API Keys, you have to first delete one public key. An OCI Object Storage service user can't have more than three public keys.
   6. Select Paste Public Keys and paste the key that you copied from Oracle IoT Asset Monitoring Cloud Service.
   7. Click Add.
      The fingerprint for the added public key appears under API Keys. The fingerprint should be the same as that displayed on the Settings page of Oracle IoT Asset Monitoring Cloud Service.
5. On the Settings page in Oracle IoT Asset Monitoring Cloud Service, provide the object storage details in the Integrations section.
   The OCI Object Storage stores the data extracted by the Business Intelligence Cloud Connector (BICC) from Oracle Fusion Cloud Maintenance.
   1. Under Oracle Object Storage Service, select Object Storage Enabled.
   2. Enter the Object Storage URL where BICC ingests data.
      For example, https://objectstorage.us-phoenix-1.oraclecloud.com.
   3. Enter the Namespace of the compartment that contains the storage bucket.
   4. Enter the Default Bucket name that stores the data extracted by the Business Intelligence Cloud Connector (BICC) from Oracle Fusion Cloud Maintenance.
6. On the Settings page in Oracle IoT Asset Monitoring Cloud Service, configure Oracle Fusion Cloud Maintenance integration.
   1. In the Integrations section, click Oracle Maintenance Cloud Service.
   2. Click Connect to Mnt.
   3. Specify the Service URL for your Oracle Fusion Cloud Maintenance instance.
      The Service URL is the URL of your Oracle Fusion Cloud Maintenance host. No port number is necessary here.
      For example: https://MyMntCloud.oraclecloud.com.
   4. Specify the User Name for your Oracle Fusion Cloud Maintenance instance.
   5. Specify the Password for your Oracle Fusion Cloud Maintenance instance.
   6. Click Verify Connectivity to verify connectivity to the Oracle Fusion Cloud Maintenance instance.
   7. Click Save.
   8. Click Edit Configuration, and toggle the Integration Status to ON.
      This enables your Oracle Fusion Cloud Maintenance integration.
   9. Specify the Synchronization frequency in minutes.
      The sync frequency determines how often Oracle IoT Asset Monitoring Cloud Service syncs with Oracle Fusion Cloud Maintenance.
   10. Click Save.
   11. Select the Object Storage Integration to use for storing external data received from Oracle Fusion Cloud Maintenance.
       External data such as asset data, work order data, and maintenance schedules from Oracle Fusion Cloud Maintenance are stored and used to analyze asset failure patterns. Learning work-flows, and associated analytics entities, are then created to suggest optimal maintenance schedules for Oracle Fusion Cloud Maintenance.
   12. Specify the Object Storage Container name, or bucket name, to store the Oracle Fusion Cloud Maintenance data.
7. Under Oracle SCM Organizations Mapping, map your Oracle SCM Cloud organizations to one or more Oracle IoT Asset Monitoring Cloud organizations.
   • One to One: Lets you create one-to-one mappings between Oracle SCM Cloud organizations and Oracle IoT Asset Monitoring Cloud Service organizations. Oracle IoT Asset Monitoring Cloud Service automatically creates a separate organization for each Oracle SCM Cloud organization from which assets are imported. This helps separate the assets into their respective organizations in Oracle IoT Asset Monitoring Cloud Service.
   • Many to One: Lets you choose one organization in Oracle IoT Asset Monitoring Cloud Service where your Oracle Fusion Cloud Maintenance assets are imported. Assets imported from different Oracle SCM Cloud organizations are imported into the same Oracle IoT Asset Monitoring Cloud Service organization.

     Select an IoT Organization to use for the many-to-one mapping.

   Note:

   If you change the mapping settings for an existing Oracle Fusion Cloud Maintenance integration, the changed mapping applies to assets from new Oracle SCM Cloud organizations only. The already mapped Oracle SCM Cloud organizations are not affected.

Configure OCI Object Storage in BICC

Configure Oracle Cloud Infrastructure (OCI) object storage in Business Intelligence Cloud Connector (BICC). A data extraction job extracts the file to a specified namespace and bucket in the Oracle Storage Cloud objects store. You need a subscription to Oracle Cloud Storage to complete this setup.

1. Log in to your BICC console.
   Append /biacm to your Oracle Fusion Cloud Maintenance URL. For example, https://hostname/biacm. Here, hostname is the host name of your Oracle Fusion Cloud Maintenance instance.
   Log in as a user that has permission to perform admin tasks in BICC. The user should have the ESS Administrator and Application Implementation Administrator roles.
2. Click the Configure External Storage task panel.
3. Select the OCI Object Storage Connection tab.
4. Click Add.
5. Under OCI Parameters, complete the following fields:
   • Name: Specify a name for the connection.
   • Host: Specify the host name for the OCI Object Storage Service. For example, https://objectstorage.us-phoenix-1.oraclecloud.com.
   • Tenancy OCID: Paste your Tenant OCID. The tenancy details are available from the Oracle Cloud Infrastructure Console. You need to log in to your Oracle Cloud Infrastructure Console. From the Profile menu, click Tenancy: YourTenancyName. The tenancy OCID is shown under Tenancy Information. Click Copy to copy it to your clipboard.
   • User OCID: Paste your User OCID. The user details are available from the Oracle Cloud Infrastructure Console. You need to log in to your Oracle Cloud Infrastructure Console. From the Profile menu, click User Settings. The User OCID is shown under User Information. Click Copy to copy it to your clipboard.
   • Namespace: Specify the namespace of the compartment that contains the storage bucket. Namespace is obtained in the OCI Console.
   • Bucket: Specify the bucket name that stores the data extracted by BICC from Oracle Fusion Cloud Maintenance.
6. Under OCI API Signing Key click Generate API Signing Key.
   A value is displayed in the Fingerprint field.
   You need to paste this key in OCI Object Storage service before you can test the connection. To do this, navigate to the User Settings page from the Profile menu in OCI Console. Click API Key > Add API Keys to import or paste the key in OCI Console.
7. Click Test Connection in BICC to test the connection to the OCI Object Storage service.

Configure BICC to Generate Gzip Extract Files

Change the compression type for BICC extracts to gzip. Oracle IoT Asset Monitoring Cloud Service connects to the OCI Object Storage service to ingest batches of these compressed csv files (.gz) for analysis.

1. Log in to your BICC console.
   Append /biacm to your Oracle Fusion Cloud Maintenance URL. For example, https://hostname/biacm. Here, hostname is the host name of your Oracle Fusion Cloud Maintenance instance.
   Log in as a user that has permission to perform admin tasks in BICC. The user should have the ESS Administrator and Application Implementation Administrator roles.
2. Click the Manage Offerings and Data Store task panel.
3. On the Offerings page, click the Actions drop-down list, and select Extract Preferences.
4. Under File Parameters, change the Compression Type to GZip.
5. Click Save to save your changes.

Extract Key Maintenance Data from Oracle Maintenance Cloud

Schedule the Extract, Transform, and Load Maintenance Data program in Oracle Fusion Cloud Maintenance to create a machine-learning ready data extract of your key maintenance related data

1. From the home page in Oracle Fusion Cloud Maintenance, select Menu > Tools > Scheduled Processes.
2. Click Schedule New Process.
3. Click the Name drop-down list, and click Search.
4. Type Extract, in the Name search field, and click Search.
5. Select Extract, Transform, and Load Maintenance Data from the list of search entries and click OK.
6. Click OK again to confirm.
7. In the Process Details dialog, select a value for Extraction Type.
   You can choose Incremental or Full load.
8. Enter a Reliability Rate between 0 and 1.
   The Reliability Rate is used in calculating the useful lifespan of parts and assets. The reliability rate indicates the maximum allowable failure rate before a part or asset is no longer considered usable.
   For example, a value of 0.8 indicates a reliability rate of 80%.
9. Enter a Utilization Rate between 0 and 1.
   The utilization rate indicates the minimum lifespan of a part that must be utilized before it can be replaced.
   For example, a value of 0.5 indicates a utilization rate of 50%.
10. Click Submit, and then click OK.
11. Click the Refresh icon on the Overview page to see the current status of your process.
    Once the Extract, Transform, and Load Maintenance Data process prepares key maintenance data, the BICC job packages and copies the data into the OCI Object Storage bucket.

Perform Learning on Maintenance Data

Schedule the Perform Learning on Maintenance Data program in Oracle Fusion Cloud Maintenance to trigger learning on the exported maintenance data. Oracle IoT Asset Monitoring Cloud Service then sends recommendations back to Oracle Fusion Cloud Maintenance based on the learning performed in Oracle IoT Asset Monitoring Cloud Service.

1. From the home page in Oracle Fusion Cloud Maintenance, select Menu > Tools > Scheduled Processes.
2. Click Schedule New Process.
3. Click the Name drop-down list, and click Search.
4. Type Perform Learning in the Name search field, and click Search.
5. Select Perform Learning on Maintenance Data from the list of search entries and click OK.
6. Click OK again to confirm.
7. Enter Reliability Rate and Reliability Tolerance values between 0 and 1.
   For example, a value of 0.8 indicates a reliability rate of 80%.
8. Enter a Utilization Rate between 0 and 1.
   The utilization rate indicates the minimum lifespan of a part that must be utilized before it can be replaced.
   For example, a value of 0.5 indicates a utilization rate of 50%.
9. Click Submit, and then click OK.
10. Click the Refresh icon on the Overview page to see the current status of your process.
    Once the Perform Learning on Maintenance Data process has succeeded, Oracle IoT Asset Monitoring Cloud Service performs learning on the ingested data and sends back recommendations to Oracle Fusion Cloud Maintenance.

The maintenance manager can check the Recommendations infolet on the landing page to look for new recommendations in Oracle Fusion Cloud Maintenance. The maintenance manager can choose to accept, reject, or override these recommendations.