Oracle Utilities Customer Care And Billing Integration To Oracle .

Implementation GuideOracle Utilities Customer Care and BillingIntegration to Oracle Utilities Meter DataManagementImplementation GuideRelease 12.1E64807-03February 2020(Updated March 2022)

Oracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management, Release12.1 Implementation GuideCopyright 2010, 2020 Oracle and/or its affiliates. All rights reserved.Primary Author:Oracle CorporationThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government endusers are "commercial computer software" or "commercial computer software documentation" pursuant tothe applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use,reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/oradaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this softwareor hardware in dangerous applications.Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, andthe AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.

ContentsImplementation GuidePreface.Audience .Documentation and Resources .Documentation Accessibility .Conventions.Abbreviations .ivivivviviviPart 1Understanding the IntegrationChapter 1Integration Overview . 1-1Prerequisites. 1-2About the Integration Product . 1-2Supported Business Processes . 1-3Chapter 2Understanding the Integration . 2-1Technical Overview . 2-2Asynchronous Processes . 2-2Synchronous Processes. 2-5JMS Wrapper Services For Async Processes. 2-7Integration Points . 2-9Master Data Synchronization Process. 2-10Person Information Synchronization Integration Process . 2-11SP Information Synchronization Integration Process . 2-12SA Information Synchronization Integration Process . 2-13SA Relationship Synchronization Integration Process. 2-15Meter Information Synchronization Integration Process . 2-16Meter Configuration Information Synchronization Integration Process . 2-17SP-Meter History Information Synchronization Integration Process . 2-18Scalar Meter Read Sync Integration Process . 2-19Contract Option/Dynamic Option Synchronization Integration Process . 2-20Contract Option Event /Dynamic Option Event Synchronization Integration Process. 2-21Billing Related Processes . 2-23Batch Bill Determinants Integration Process. 2-24Online Bill Determinants Integration Process . 2-25Replacement Reads Integration Process . 2-27Contents - iOracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management Implementation Guide

Get Register Read High-Low Boundaries Integration Process . 2-29Get Usage Request Integration Process . 2-30Usage Transaction Info Update Integration Process . 2-33Customer Self Service Related Processes . 2-34Usage Adjustment Request Integration Process . 2-34Bill Cycle Synchronization Related Processes. 2-36Bill Cycle Synchronization Integration Process. 2-37SA Activation Bill Cycle Request Integration Process . 2-38Bill Cycle Change Notification Integration Process . 2-39Part 2Implementation GuidelinesChapter 3Configuration Guidelines. 3-1Integration Configuration Checklist .3-2Integration JMS Wrapper Configuration . 3-2Oracle Utilities Customer Care and Billing Configuration . 3-2Oracle Utilities Meter Data Management Configuration . 3-4Integration Product Configuration . 3-5Setting up the Integration JMS Wrapper Processes .3-5Installing Optional CCB-MDM Patch 26532407 . 3-6Setting Configuration Properties for JMS Wrapper Processes. 3-6Setting Outbound Message Configuration for CCB and MDM . 3-6Data Synchronization.3-6Setting up Oracle Utilities Customer Care and Billing.3-7Oracle Utilities Customer Care and Billing Admin Data Table Configuration . 3-7Country . 3-7Disconnect Location. 3-8SP Type. 3-8CIS Division. 3-8SA Type . 3-8Meter Type . 3-9Manufacturer and Model. 3-9Meter Configuration Type . 3-9Read Out Type . 3-10Service Type . 3-10Unit of Measure. 3-10Time of Use. 3-10Service Quantity Identifier. 3-11Feature Configuration . 3-11Master Configuration. 3-11Installation Options - Framework . 3-11Oracle Utilities Customer Care and Billing System Data Table Configuration . 3-12BO Algorithms . 3-12Maintenance Object Algorithms. 3-14Maintenance Objects . 3-14Business Objects . 3-16Menus. 3-18Batch Scheduling . 3-19Oracle Utilities Customer Care and Billing Inbound Message Configuration. 3-20WebLogic Server JMS Configuration. 3-21Configuration File Changes for MDBs. 3-24Oracle Utilities Customer Care and Billing Outbound Message Configuration. 3-34Contents - iiOracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management Implementation Guide

JNDI Server . 3-35JMS Queue . 3-35JMS Connection . 3-38Message Sender . 3-39Outbound Message Type . 3-47External System . 3-51Setting up Oracle Utilities Meter Data Management .3-53Oracle Utilities Meter Data Management Admin Data Table Configuration. 3-54Country . 3-54Service Point Type . 3-54Usage Subscription Type. 3-54Device Type . 3-55Manufacturer and Model. 3-55Device Configuration Type . 3-55Service Type . 3-55Unit of Measure. 3-55Time of Use. 3-56Service Quantity Identifier. 3-56Service Provider. 3-56Master Configuration. 3-57Feature Configuration . 3-57Usage Adjustment Profiles . 3-57Oracle Utilities Meter Data Management System Data Table Configuration. 3-58Business Objects . 3-58BO Algorithms . 3-60Extendable Lookups. 3-61Read Out Type . 3-61Menus. 3-61Batch Scheduling . 3-62Oracle Utilities Meter Data Management Inbound Message Configuration. 3-64WebLogic Server JMS Configuration. 3-64Configuration File Changes for MDBs. 3-67Oracle Utilities Meter Data Management Outbound Message Configuration . 3-77JNDI Server sss . 3-77JMS Queue . 3-77JMS Connection . 3-80Message Sender . 3-81Message Sender to Invoke Integration Synchronous Services. 3-89Outbound Message Type . 3-90External System . 3-93Setting up the Process Integration .3-95Setting Configuration Properties. 3-95Setting Domain Value Maps for the Integration Layer . 3-96Updating MDS. 3-96Setting Error Handling for the Integration Layer . 3-97Chapter 4Monitoring and Troubleshooting . 4-1Monitoring from Oracle Utilities Customer Care and Billing .4-1Oracle Utilities Customer Care and Billing Error Logs. 4-1Oracle Utilities Customer Care and Billing Notifications . 4-1Setup To Do Entry for JMS Message Error . 4-2Oracle Utilities Customer Care and Billing Connection Errors. 4-2Monitoring from Oracle Utilities Meter Data Management .4-2Oracle Meter Data Management Error Logs. 4-3Contents - iiiOracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management Implementation Guide

Oracle Utilities Meter Data Management Notifications. 4-3Setup To Do Entry for JMS Message Error . 4-4Oracle Utilities Meter Data Management Connection Errors . 4-4Monitoring from the Integration.4-4Monitoring Using WebLogic SOA Enterprise Manager. 4-4Monitoring Using WebLogic Logs . 4-4Monitoring the Queues Using the WebLogic Console . 4-5Data Purge. 4-5Troubleshooting.4-5Asynchronous Processes . 4-5Synchronous Processes. 4-8Chapter 5Customization Options. 5-1Extension Methods .5-1Custom Extension Points . 5-1Pre-Transformation Extension Point . 5-1Post-Transformation Extension Point. 5-1Custom Transforma

Oracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management Implementation Guide Preface Audience This document is intended for anyone implementing the Oracle Utilities Customer Care and Billing Integration to Oracle Utilities Meter Data Management. Documentation and Resources