Oracle Solutions for Utilities

UICG Services for the Oracle Applications

Customer Care & Billing (CC&B):.

We understand the technology, process and continue to update best practices

Contact us

Oracle Utilities Customer Care and Billing (CC&B) has a wide range of end-to-end business processes for supporting Electric, Gas and Water utilities serving residential, commercial and industrial customers. UICG has strong capabilities in configuration, customization and implementation of Oracle Utilities Customer Care and Billing (CC&B) product to enable the full range of Meter-To-Cash solutions for the Utilities. We use systematic approaches to implement Oracle Utilities products and solutions to meet customer need with standard and proven methodologies.

Highly experienced UICG consultants closely work with the Utilities to meet their business needs – Interval Billing using Time-of-use usage data, Off-cyclic and Cyclic Billing, Complex rate engine configuration, setting up XAI based external system configurations.UICG helps utilities in integrating Customer Care and Billing system with other edge system such as Automated Payment gateway, Meter data collection systems, Enterprise Asset Management Systems, Field workforce Management systems, Reporting Systems, Document management systems and Geographic Information Systems (GIS). UICG enables utilities in Configuration, schedule, execution and monitor mission critical batch jobs, rate engine, CSR work lists and exception managements.

Summary List of Oracle CC&B Features

UICG can help you customize
  • Customer Information: To manage customer’s demographic, geographic and service agreement information.

  • Sales & Marketing: To define marketing campaigns and creation of package and Orders.

  • Device Management: To define and manage the utility asset (meter, item and equipment's) life cycle.

  • Field Work: To create, route and record outcome of field work orders.

  • Meter Reading: To download meter read requests, upload meter reads and manage consumption trends.

  • Billing: To create and manage bill life cycle. Support for cancel/re-bill, credit note and correction note features.

  • Interval Billing: To support Time-Of-Use interval billing, maintains interval profiles and interval price.

  • Statements: To manage consolidation of financial transactions from multiple accounts onto a single statement.

  • Rates: To configure complex rate computations. Support for classic and new Java based rate engine.

  • Payments: To record, distribute and manages customer payments.

  • Adjustments: To manage and transfer customer's dept between accounts and enable flexible approval hierarchies.


Summary List of Oracle CC&B Features

UICG can help you customize
  • Credit and Collections / Overdue Process: To monitor dept collection process. Support for Sever service, payment arrangement, pay plan and write-off.

  • Budgets: To setup and monitor customer’s budget with respect of actual consumption.

  • Deposits: To manage deposits and refunds.

  • SA Relationships: To define and manage various service providers involved with providing service to customers in deregulated markets.

  • Service Credits: To facilitate customers to participate and get awarded for their service (Loyalty programs, Capital Credits).

  • Contract Management: To manage quotes and umbrella service agreements that allow sending a customer a proposal and group service agreements belong to a same contract.

  • Loans - Enables utilities to bill principal amount using customized payment schedules.G



Oracle Overview

With the changing business landscape, organizations today are compelled to transform the way they do business, and technology plays a key role in this transformation. At UICG, we offer a complete spectrum of services to our clients across the Oracle ecosystem.

Our extensive experience in Oracle applications, coupled with deep domain expertise, has helped over 200 clients from across diverse industry sectors, leverage Oracle applications & technologies to their business advantage. We combine the technical and industry-leading practices to deliver successful business solutions, thereby enabling our clients to maximize their ROI. At UICG, we have a dedicated Oracle Innovation and Solution Center (OISC), which is our innovation engine. OISC studies the emerging technologies and identifies ways to leverage them for delivering faster and best-fit solutions to our clients. Our Experience Theaters across the globe enable clients & partners get a preview of technology, without actually investing in it. 

UICG’s holistic understanding of our clients' businesses makes us a trusted partner for our clients’ transformation journey. We partner with client enterprises and play a guiding role in aligning their businesses with industry best-practices. Our thorough understanding of technology, enables us to suggest new / alternate models for enterprises to adopt and remain at the forefront. As Oracle Worldwide Platinum Partner and Business Accelerate Partner, we have access to the latest Oracle solutions, methodologies, and a dedicated team of executives to address business issues that trouble enterprises around the globe.

Oracle Innovation & Solution Center (OISC).

UICG has established a state-of-the-art Oracle Innovation & Solution Center. The center brings together our technical & industry experience to conceptualize, showcase and demonstrate next generation solutions, tools & accelerators to meet the ever-changing business requirements, and align with the emerging industry trends. OISC enables clients to achieve enhanced ROI and lower TCO on IT investments and efforts.

Odoo - Sample 1 for three columns

Oracle MWM Applications

Oracle Utilities Mobile Workforce Management (MWM) is an integrated resource planning, scheduling and dispatching system with mobile client and business analytics feature. It can be deployed on cloud, on premise, and hybrid models.

UICG helps utilities in implementation and support of Mobile Workforce Management systems to achieve the following benefits:

  • Reduces operating costs while improving asset life and customer satisfaction.

  • Increases on-time responses, wrench time, and job completions.

  • Reduces travel distance, vehicle emissions, and missed appointments.

  • Improves productivity and decreases crew hours and overhead.

  • Incorporates training, work administration, and performance monitoring.

  • Provides deployment options to reduce IT complexity, cost and risk.

UICG supports Oracle Utilities Mobile Workforce Management (MWM) application and are specialists in implementing, extending and integrating with other systems using the following core MWM features:

Service Management: Configuration and implementation to accept requests from host systems (CIS, OMS, EAM) to perform activities in specific field locations. Configuration of dispatch activities to best matching crews and Monitor activities while the crew in action. Report status updates, interim and completion details back to the host systems

Resource Management: Configuration mobile workers, vehicles, crews and dispatchers in MWM system. Assist business in generation of crews shifts based on templates and define periods of unavailability (POU) of a resource to perform work.

Scheduler: Oracle Real-time Scheduler (ORS) is a core scheduling engine used for real-time activity scheduling based on specific business drivers. It supports a standalone application on various mobile device types with single mobile framework by ensuring secured asynchronous communication with wired or wireless network types. It manages software and data deployment on the mobile devices. It also enables access via any HTML5 browser and Mobile device independent (Windows Mobile, Android and iOS).

Mobile Application: It operates on top of the mobile communication platform (MCP) to allow crews to request, adjust and start their shift from their mobile device. The crew can also view and work their schedule of activities as they are dispatched to them, take a break or attend a meeting, make changes to their shift as needed and complete their shift. The mobile application will record outcome of tasks and shift completion details. The crew can work their tasks and end their shift even offline. When back in network range, task and shift completion details are asynchronously sent to the MWM server application.

Dispatcher: It has sophisticated visual overviews which allow dispatchers to make complex decisions. Common Dispatching Interface (CDI) is used to display dispatcher’s crews and their schedule in a Gantt format. It also allows allocating, dispatching, unassigning and deferring activities. The CDI interacts with a Map viewer to show where crews are or expected to be, their routes, activity locations and more on a map. It is used to tracks dispatcher shifts, records when they logged on, any significant event throughout their shift as well as when they logged off.

Alert Management: Out-of-box configuration support for alert creation, recycle and snooze for situations that requires intervention of dispatcher from the back office. The MWM system constantly watches for pre-configured alert conditions and raises alerts when they occur. These alerts can be configured to be assigned to a single logged on dispatcher responsible for its resolution.

GPS Data: With GPS integration, the actual location of crew is identified to allow the scheduler to promptly respond to real time changes in plan and re-optimize crew routes. It assists dispatchers in making same-day work allocation decisions. A crew may be associated with GPS data sent in by their mobile device (via the mobile application) or an external GPS system embedded in their vehicle.

Integration: Oracle MWM plays a vital role in enabling real time scheduling in field workforce management. New business processes to send and receive data between MWM other utility host systems are orchestrated using Oracle SOA, Webservices, BPM and BEPL integration technology tool stake.

Odoo - Sample 1 for three columns

Oracle MDM Solution

The primary challenge of implementing smart metering technology is that it results in a flow of large volume of meter data that is much greater than traditional manual metering systems where the meter data is collected on a bi-monthly, monthly or quarterly basis. This increased data volume will flow into the utility which manages the distribution system and also be passed to and from third-party retailers for processing under new market transactions.

Utilities implementing Smart Metering programs face the challenge of managing the huge volume of meter data and transform them into business requirements.

To meet these challenges Oracle MDM system provides utilities with a business critical solution for storing, validating, aggregating and processing large volumes of meter data and preparing them for billing, settlements, analysis and other reporting needs. Oracle MDM system is built with it state of art software and hardware platforms to handle such a huge volume of flooding data in a more efficient way.

UICG has strong expertise in implementation and support of following core features of Oracle Utilities MDM system. Master Data Synchronization: Meter data management repository does not own meter, service point, premise and customer contact master data. But these data is mandatory and to be made available to MDM to become operational. A set of data synchronization processes brings these data from the respective data owner systems into Oracle MDM. For example, a utility using Oracle CC&B, the customer and meter information would be synchronized into MDM through the synchronization process. Similarly, any information captured from the field using head end systems will need to be synchronized back to the respective CIS systems.

Initial Synchronization process would typically be carried out during the production migration time of the smart metering implementations. Once the system goes live, the new master data and the filed updates are synchronized using On-going Synchronization process.

Validation, Editing and Estimation (VEE): One of the most important features of Oracle Utilities Meter Data Management System is the data cleansing process. This is commonly referred as Validation, Editing and Estimation (VEE) process. Oracle Utilities Meter Data Management System contains a wide range of pre configured VEE rules to process the consumption data received from data collection systems on bi-monthly, monthly or quarterly basis as well as the interval data received from modern AMI systems.

Oracle MDM supports a number of widely used industry standard VEE rules out of the box and also provides users with the ability to easily create any custom validation and estimation rules for a variety of purposes. It requires minimal configuration or programming and scripting to create such special rules with very less cost and time associated with system deployment and operations. Oracle MDM allows the user to create different VEE rules for different types of meter registers and based on what the meter measures. The below is the list of pre configured VEE rules supported by Oracle MDM.

Odoo - Sample 2 for three columns

Smart Grid Gateway (SGG) – Two Way Communication and Process Automation

UICG has strong experience implementing and customizing a range of Smart Grid gateway (SGG) adapters to integrate multiple AMI systems that use different technologies, protocol and data formats to share meter data with other systems. This feature effectively decouples downstream applications from Advanced Metering Infrastructure. It also allows the integration of new technologies as they emerge, and the decommissioning of old technologies, without being restricted to a single vendor or AMI implementation. This means consumers can use Oracle MDM as a single consistent interface across the various AMI systems with data presented in a centralized repository.

Oracle MDM feature enables bi-directional smart metering infrastructure networks to communicate with other systems. It provides routing and management components for implementing the required two-way processes. Oracle MDM is capable of handling the following smart metering commands with Oracle SGG:

  • Remote Connect - Initiates power flow from the source through the meter. This does not mean that the device is being installed. Once command is being sent, it is assumed that the device has already been installed. The Head End Systems typically require more than one communication to facilitate this process. Utilities may also want to retrieve a start read for scalar subtractive meters during this command.

  • Remote Disconnect - Stops power flow through the meter. This does not mean that the device is being removed. Like connect command, disconnect typically involves more than one communication to the Head End System. Utilities may want to retrieve an end read for scalar subtractive meters during this command.

  • Device Commissioning - Drives the registration or discovery of the device by the Head End System. This process does not always require an explicit communication. Utilities won’t always receive an explicit response to a commission request. Sometimes receiving measurements could be an indication of a successful commissioning.

  • Device Decommissioning - Notifies the Head End System that no further data will be arriving from the device.

  • On Demand Read (Interval) - Accommodates near real time requests for readings.

  • Device Status Check (Meter Ping) - Returns the working condition of a device, and this might involve more than one communication.

In addition to standard commands, any meter vendor specific two-way communication commands can be built using the MSM extension features. The Smart metering commands can be enabled by end to end process automations. For example, an utility using Oracle CC&B and MDM systems could include the integration of “turn-on/turn-off” business process by combining both manual collection method and smart meters with an integrated remote connect disconnect command. In this case, once CC&B system determines that customer power is to be turned off, Oracle MDM system can be implemented to determine, depending on the meter type, whether the turn-on/turn-off requires a field service order, or can be executed directly through the smart metering infrastructure systems using the SGG smart metering commands. Oracle SGG benefits the customer by reducing costs to implement and operate smart grid processes and programs, minimizes data duplication and improves system performance, provides a common set of commands to foster application interoperability and improves the security and better audit of smart grid processes. Services- Utilities Solutions Oracle CC&B Application Oracle MWM Application Oracle MDM Application Reporting Solutions Customer Info Mobile Apps Business Support Services Utilities Network Design & Planning Geographic Information System (GIS)

Oracle Utility Analytics (OUA)

Let UICG assist you

Utilities need an effective and agile decision support system to become competitive and customer-oriented, while combating frequent regulatory changes in the rapidly transforming business landscape. Growing challenges are making the analytics setup a very complex and time consuming process. These include:

  • Limitations due to legacy infrastructure

  • Exponential increase in utility data

  • Real-time analysis

  • Time taken for implementation

Our Approach: UICG Oracle Utilities Analytics offers a complete and comprehensive analytics platform that includes pre-packaged analytics including out-of-box dashboards, reports, KPIs, data warehouse, data model and extraction process. Oracle Utility Analytics include the following sub-modules:

 Credit and Collections Analytics       Revenue Analytics
 Customer Analytics                           Device Analytics
 Work and Asset Analytics                 Mobile Workforce Analytics
 Grid Analytics                                    Meter Data Analytics
 Corporate Administration                  Exception Analytics

Solution Highlights:

 Utilities Industry standard KPIs 
 Quickly and easily deployable solutions for faster results
 Capacity to extract huge volumes of data in near real-time using
    GoldenGate and ODI
 Dependable reporting platform using Oracle Business Intelligence,
    which has capabilities like drag and drop reporting, drill downs,
    graphs,mobile integration, alerts, pixel perfect reporting etc.

Key Benefits

 Easily extensible solution for building additionalnon-generic requirements
 Robust decision support system – leverages UICG's strong predictive analytics     capability in addressing additional requirements in certain spaces, for e.g., revenue     protection, asset management, customer program management and customer profiling
 Evaluation of existing set up vis-à-vis latestproduct
 Evaluation of business drivers vis-à-visbenefits of re-implementation/upgrade
 Build future roadmap for analytical andregulatory reporting
 Hardware sizingAdvisory Services Implementation, Support & Maintenance
 Implementation, Maintenance and Supportof CC&B Analytics, NMS Analytics, WAM     Analytics, MWM Analytics and MDM Analytics
 Environment Management Application of patches Management of ad-hoc report     requests
 Management production issues
 UICG has the distinction of co-developing the Oracle Utility Analytics solution with     Oracle and is one of the pioneers in using this product. With our pool of resources     experienced in Oracle Business Intelligence and Oracle UtilityApplications, we can     support fast-paced  implementation with complex customer specific report extensions
 Pre-built integration with Oracle utility applications such as Billing, Work  and Asset     Management, Meter Data Management and Workforce Management Systems

Odoo image and text block

Oracle Utilities Meter Data Analytics

Oracle Utilities Meter Data Analytics offers pre-built dashboards that help you improve metering performance and analyze consumption trends. Oracle Utilities Meter Data Analytics provides;

  • Analyze consumption trends.

  • Monitor meter asset performance and make better buying decisions. .

  • Identify customer segments for energy efficiency and demand management programs.

  • Decrease losses from unbilled energy.

  • Make more effective maintenance decisions that help avoid catastrophic grid failures.

Oracle Utilities Customer Care and Billing Business Intelligence

The Oracle Utilities Customer Care and Billing Business Intelligence products delivers prebuilt analytics that help utilities improve decision-making, customer service, and revenue management. The Oracle Utilities Customer Care and Billing Business Intelligence products provide fast, easy ways to answer questions about customers and revenues. This products help utilities recognize trends and make better decisions about their business.

Our References

Demo Logo
Demo Logo
Demo Logo
Demo Logo
Demo Logo