Leveraging Oracle Integration Cloud for Two-Way Data Flow Between Maximo & Oracle Field Service

The Challenge

Like many utilities, our client is undertaking multiple modernization efforts – in this case seeking to better manage assets, work, and its workforce. Our client was using two disparate systems: Work Order Management in Maximo and Crew Management in Oracle Field Service (OFS) which needed to be brought together to have a 360 view of the problem and resolution.

 

The old process was to open a work order in Maximo and provide that to the crew. However, the crew assignments were taking place in OFS, where activities and final resolutions were logged. Posting updates back to Maximo was a manual activity that took place as the final step in the process. The customer was looking to integrate the two systems to have data flow back and forth in real time and to automate updates.

 

HEXstream proposed a solution that utilized Oracle Integration Cloud (OIC) to integrate data from Maximo, OFS, Cornerstone resource management, and ESRI GIS. The solution provided better, more accurate information and helped the utility reduce multiple manual, paper-based processes between systems and the customer can see the status of each step of the process in Maximo The utility was also able to automate timecard processing.

 

What We Built

 

OFS Integration with Maximo

The utility sought a cloud-based mobile workforce management solution to improve how the business managed its assets, work, and workforce. The newly implemented Oracle Field Service scheduling and dispatching tool incorporated IBM Maximo, the client’s enterprise asset management system, as the key integration point for asset tracking and field activity information. In addition, the application incorporated data from Cornerstone for competency and resource skill data to improve routing and dispatching, and it provided users with links to the ESRI GIS system to provide additional relevant data.

The real-time bidirectional flow of data between Oracle Field Service and Maximo relied on OIC. This included integration with Oracle Autonomous Data Warehouse (OADW) and customizations within OIC. The newly automated real-time integration brought together Maximo's scheduling capabilities and OFS's field resource data to provide more comprehensive information than was previously available.

Custom Reports & Dashboards

With all the data coming together, HEXstream could now provide the client with real-time insights into their transactional information rather than just sharing batch data at the end of each day. This has helped the client analyze and identify trends in their resource usage in various conditions.

HEXstream partnered with industry-leading field service implementer Group7 Consulting on this project. Through this partnership, HEXstream and Group7 Consulting have helped the client utility lay the foundation for ongoing dashboard & analytics development. By continually refining data operations and making data available throughout the organization, the client stands to derive more value from its data than ever before.

 

About the Client

Natural Gas and Electricity divisions of a publicly traded Canadian engineering, logistics, and energy holding company.

  • Over 1 million natural gas customers
  • Over 200,000 electricity customers

How can we help your utility manage and analyze data more effectively? Ask the utility analytics experts! 

Let's Talk!

Back to Blog

Related Articles

Integrating 4 Outage Management Systems Into a Single Analytics Platform

The Challenge After embarking on an aggressive growth strategy, the client utility made several...

Digitalizing Outage Management Ops for a Publicly-Traded Power Utility

The Challenge After enduring several record-breaking storms throughout the 2010s, the client...

Generating Reliability Reports 8x Faster After the Acquisition

The Challenge In the midst of an acquisition by a larger, multi-state investor-owned utility, the...