Integration Points
The integration scope supports the following business processes:
• Data synchronization of new devices from Oracle Utilities Operational Device Management to Oracle Utilities Meter Data Management.
• Data synchronization of service points and associated contacts from Oracle Utilities Meter Data Management to Oracle Utilities Operational Device Management
• Data synchronization of installations/removals from Oracle Utilities Meter Data Management to Oracle Utilities Operational Device Management.
The key integration points for this integration are as follows:
Note: The location information is stored as Node information in Oracle Utilities Operational Device Management. Asset Location information is stored as Asset Node information.
Master Data Synchronization Processes
The following integration processes are available in Oracle Utilities Integration for Device Operations Using Oracle Integration Cloud:
• Meter and component data are synchronized from Oracle Utilities Operational Device Management to Oracle Utilities Meter Data Management system.
• Contact, Service Point, and Install Event data are synchronized from Oracle Utilities Meter Data Management to Oracle Utilities Operational Device Management.
• The integration uses the sync request process to capture data changes and communicate or synchronize the data changes between the two systems by sending out a sync request message to the integration layer.
• The sync request process is implemented using business object technology; therefore, much of the business rules and processing logic are defined in the algorithms associated to the business objects used by the sync process.
• The Audit plug-in spot defined on the entity's Maintenance Object (MO) is used to detect changes in Oracle Utilities Meter Data Management data and to create sync requests. The Audit plug-in spot on the entity's business object (BO) is used to detect changes in Oracle Utilities Operational Device Management data and to create sync requests.
These two plug-ins work in the same way, except Oracle Utilities Operational Device Management tracks changes at a business object level. Since only a subset of Oracle Utilities Operational Device Management assets (meters and components) are synchronized to Oracle Utilities Meter Data Management, having the audit plug-in at business object level avoids the unnecessary creation of sync requests that will eventually be discarded.
• The sync request life cycle captures the change in data, sends sync request message to the integration, and awaits an acknowledgment back from the external system - whether positive or negative. Timeouts and negative acknowledgment received from the external system results in the sync request being transitioned to the Error state. As an option, implementation may choose to create a To Do entry in this case.
• There is a portal used for searching and viewing sync requests.
For more information about the sync request process, the business objects, maintenance objects, and other components used for this process, refer to the Data Synchronization section in Oracle Utilities Framework User Guide.
Asset - Device Synchronization
This process synchronizes the device details required by Oracle Utilities Meter Data Management from Oracle Utilities Operational Device Management.
The following diagram provides a graphical representation of this integration process.
Business Processing
The Asset - Device Sync request integration process includes the following activities:
1. Oracle Utilities Operational Device Management sends Asset sync information in the form of XML messages to Oracle Utilities Operational Device Management-Meter Data Management Asset Sync Req which is deployed on Oracle Integration Cloud.
2. The request integration process transforms asset request messages in the Oracle Utilities Operational Device Management format to Device messages in the Oracle Utilities Meter Data Management format and invokes D1-InboundDeviceSync inbound web service in Oracle Utilities Meter Data Management.
3. An immediate acknowledgment is sent to Oracle Utilities Operational Device Management.
4. Any errors are reported back to Oracle Utilities Operational Device Management through the global fault handler.
5. An email notification with error details will be sent to the users configured in the OUTL-BRT_ODMMDM_Email lookup.
The Asset - Device Sync response integration process includes the following activities:
1. After running the batch job in Oracle Utilities Meter Data Management, Device sync response in the form of XML messages are sent to the following integration process: Oracle Utilities Operational Device Management-Meter Data Management Asset Sync Response which is deployed on Oracle Integration Cloud.
2. The response integration process transforms the device response message in the Oracle Utilities Meter Data Management format to Asset message in the Oracle Utilities Operational Device Management format and invokes F1-UpdateAndTransitionSyncRequest inbound web service in Oracle Utilities Operational Device Management.
3. An immediate acknowledgment is sent to Oracle Utilities Meter Data Management.
4. Any errors are reported back to Oracle Utilities Meter Data Management through the global fault handler.
5. An email notification with error details will be sent to the users configured in the OUTL-BRT_ODMMDM_Email lookup.
Technical Details
This section provides the integration process, as well as Oracle Utilities Meter Data Management and Oracle Utilities Operational Device Management inbound web services used for the Asset - Device Synchronization integration point.
Integration Flow Name | Description |
Oracle Utilities Operational Device Management-Meter Data Management Asset Sync | Integration process that transforms Asset request from Oracle Utilities Operational Device Management to device in Oracle Utilities Meter Data Management |
Oracle Utilities Operational Device Management-Meter Data Management Contact Sync Response | Integration process that transforms device response from Oracle Utilities Meter Data Management to Asset in Oracle Utilities Operational Device Management. |
Integration Package Name | Description |
outl.ba.odm_mdm.1.23.1000.par | Asset - Device Sync request and response flows (.iar) are included this package file (.par) |