Grid Operations Solutions

Announcement

This area allows you to enter ideas for Oracle Utilities products. You can help promote an idea by:

Being as specific as possible about your request.
Clearly articulating the benefits. For example, reducing implementation effort or reducing cost to serve.
Calling out if you have seen this requirement from other utilities.
Voting for suggestions you think should be implemented.

IVR and NMS Integration - APIs are needed instead of Direct Stored Procedure Calls

Frank NingJan 21 2025 — edited May 21 2025

Hello,

Currently NMS only provides PK_IVR_INTERFACE database package/procedures to handle the IVR/NMS integration for trouble calls used by our Report Outage Web Application on Internet. We do have ESB on corporate to take customers “Report Outage” requests, and then do certain validation and make trouble calls via procedures (e.g. pr_trouble_calls etc) in NMS PK_IVR_INTERFACE package. This means that direct access to NMS database is involved.

NMS database is in very secure zone. With Cyber Security and Air Gap requirements, we need to break this database direct access. We are looking for Web Service or REST APIs from NMS adapter like nms_ws.ear, which can function in the same or similar capacity as those procesures in PK_IVR_INTERFACE package. By doing so, the new/enhanced adapter can be deployed to DMZ for our ESB to communicate instead of direct database access.

Thanks and regards

Frank

Added on Jan 21 2025

Assigned to Roadmap

2 people have voted for this idea

#bhe, #cybersecurity, #integration, #network-management-system, #nms, #toh

2 comments

620 views