Oracle’s Enterprise Asset Management (eAM) is a powerful tool that can be utilized to publish and track required inspections at your utility. In conjunction with the ArcGIS and ArcFM™ platforms, inspections can bedone completely digitally and tracked spatially, providing an overhead view of completed inspections. In this article, I will focus on the integration points between the two systems and demonstrate a case study that SSP has recently implemented.
The most straightforward method of integrating between eAM and ArcGIS systems is using staging tables to host important messages that communicate to and from the eAM and GIS databases. In the case of inspections, we establish a single staging table that maintains all of the current inspections that need to be performed. In eAM, an individual work order is created for each inspection. The information about what type of inspection (e.g. gas valve, water valve, etc.) and the identifier for the GIS feature are included in the work order and sent to the staging table.
A separate process parses all of the records in the staging tables and flags each correlating feature in the enterprise geodatabase as requiring inspection. To enable the field crew to store the results of their inspection to the database, the flagged features are replicated out to mobile laptops.
Using ArcFM Viewer™ for ArcGIS Engine, the inspector will see the features needing inspection (in this case, let’s say gas valves) highlighted on the map through unique symbology. The operator will use the Inspector tool to mark the feature on the map and enter all of the required attribut
At the end of the day, the laptop will resync with the enterprise geodatabase and send the all of the inspections back to the enterprise system. Once back in the enterprise geodatabase, a supervisor will approve the inspections and run a process that creates a version from the edits made in the field and send them to Geodatabase Manager to be posted back to SDE.Default. During the automated posting process, the inspections that were successfully performed are sent to the staging table to subsequently be sent back to eAM. es. Once completed, the gas valve will be marked as such.
What do you think?