Oracle Utilities Smart Grid Gateway Integration For Outage Operations
Implementation GuideOracle Utilities Smart Grid GatewayIntegration for Outage OperationsImplementation GuideRelease 12.1E82604-01Updated May 2017
Oracle Utilities Smart Grid Gateway Integration for Outage Operations, Release 12.1 Implementation GuideCopyright 20162017 Oracle and/or its affiliates. All rights reserved.This 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 installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation andagency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation ofthe programs, including any operating system, integrated software, any programs installed on the hardware,and/or documentation, shall be subject to license terms and license restrictions applicable to the programs.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 and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon 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, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark 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. iDocumentation and Resources . iDocumentation Accessibility . iiConventions. iiiAbbreviations . iiiPart 1Understanding the IntegrationChapter 1Introduction . 1-1Prerequisites. 1-1About the Integration Product . 1-1Oracle Integration Cloud Service (ICS) Utilities Adapter. 1-2Oracle Utilities Customer Care and Billing . 1-2Oracle Enterprise Resource Planning Cloud Financials for General Ledger and Accounts Payable . 1-3Supported Business Processes. 1-3Process Scheduling . 1-5Best Practices. 1-5Updating DVM in SOA Based ICS Catalog Service. 1-5Importing CCB-ERP ICS Flows in ICS Environment . 1-6One-Time Configuration Settings. 1-6General Ledger Integration. 1-6Accounts Payable (AP) Request and AP Data Integrations . 1-8Chapter 2Understanding the Integration Process . 2-1Technical Overview. 2-1Integration Schema . 2-3Integration Points . 2-4General Ledger . 2-4AP Request . 2-10AP Data. 2-17Shared Integration Points. 2-23Contents - iCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Part 2Implementing the Integration ProductChapter 3Configuring the Integration. 3-1Integration Configuration Checklist . 3-1Configuring Oracle ERP Cloud Financials for General Ledger and Accounts Payable . 3-2Configuring Oracle Utilities Customer Care and Billing. 3-3Configuring Integration Product. 3-4Configuring Oracle ERP Cloud Financials for General Ledger and Accounts Payable . 3-4GL Integration Point . 3-5AP Request Integration Point . 3-5AP Data Integration Point . 3-5Configuring Oracle Utilities Customer Care and Billing . 3-5GL Integration Point . 3-5AP Request Integration Point . 3-9AP Data Integration Point . 3-12Configuring the Integration Product .3-13Setting Configuration Properties. 3-13Error Handling. 3-20Verifying the Implementation.3-21GL Integration Point . 3-22AP Request Integration Point . 3-22AP Data Integration Point . 3-23Chapter 4Monitoring and Troubleshooting . 4-1Monitoring from Oracle Utilities Customer Care and Billing . 4-1Monitoring from Oracle ERP Cloud. 4-2Monitoring from Oracle ICS . 4-2Monitoring from SOA Integration . 4-2Monitoring Using WebLogic SOA Enterprise Manager. 4-2Monitoring Using WebLogic Logs . 4-3Monitoring Using Integration Error Store Table . 4-3Troubleshooting. 4-5Troubleshooting CCB-ERP BPEL Flows. 4-5Troubleshooting ICS Integration. 4-8Chapter 5Customization Options. 5-1Extension Methods . 5-1Custom Transformations . 5-1Customizable Scopes . 5-1Customizing SOA Composite Applications. 5-2Contents - iiCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
PrefaceThis document is intended for anyone implementing the CCB-ERP Integration UsingOracle Utilities ICS Adapter and ERP ICS Adapter.Documentation and ResourcesFor more information regarding this integration, foundation technology and the edgeapplications, refer to the following documents:Product DocumentationTopicDescriptionIntegration documentation:CCB-ERP Integration Using OracleUtilities ICS Adapter and ERP ICSAdapter Installation GuideRefer to the Oracle Utilities applicationsdocumentation page:http://docs.oracle.com/cd/E72219 01/documentation.htmlCCB-ERP Integration Using OracleUtilities ICS Adapter and ERP ICSAdapter Implementation GuideOracle Utilities ICS AdapterdocumentationRefer to the Oracle Utilities ICS Adapterdocumentation page:https://docs.oracle.com/cloud/latest/intcs gs/ICSUT/toc.htmOracle Utilities Customer Care andBilling and Oracle Oracle EnterpriseResource Planning Cloud FinancialsdocumentationRefer to the Oracle Utilities applicationsdocumentation page:http://docs.oracle.com/cd/E72219 01/documentation.htmlPreface - iCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Additional DocumentationResourceLocationSOA Suite 12c documentationRefer to the SOA documentation at: ite/documentation/index.htmlOracle SupportVisit My Oracle Support at https://support.oracle.com regularly to stay informed aboutupdates and patches.Access the support site for the Edge ApplicationCertification Matrix for Oracle Utilities Products(Doc ID 1454143.1) or refer to the Oracle UtilitiesIntegrations page at roductinfo/utilities/integration/index.htmOracle Technology Network (OTN)Latest versions of tmlOracle University for training opportunitieshttp://education.oracle.com/Web Services SecurityFor more information about Web services securityusing Oracle Fusion Middleware 12c refer to servicestasks.htm.Oracle Fusion Middleware 12cdocumentationRefer to the Oracle applications documentationpage: http://docs.oracle.com/en/middleware/Oracle Fusion Middleware “What'sNew In Oracle WebLogic s/NOTES/whatsnew.htm#NOTES570Section: Standards Support, SupportedConfigurations and WebLogic ServerCompatibility, DatabaseInteroperability For additional information on the typeof database to use.Instructions on installing thisintegration on non-Windows/ LinuxplatformsRefer to Oracle Support Knowledge Article ID1349320.1.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle AccessibilityProgram website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Preface - iiCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Access to Oracle SupportOracle customers have access to electronic support for the hearing impaired. Visit: http://www.oracle.com/pls/topic/lookup?ctx acc&id info or http://www.oracle.com/pls/topic/lookup?ctx acc&id trsConventionsThe following text conventions are used in this document:ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associated with anaction, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables for whichyou supply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, code inexamples, text that appears on the screen, or text that you enter.AbbreviationsThe following table lists the commonly used abbreviations in this guide.AbbreviationDefinitionAIAApplication Integration ArchitectureAPAccounts PayableAP DataAccounts Payable DataAP RequestAccounts Payable RequestBPELBusiness Process Execution LanguageDVMDomain Value MapEBFEnterprise Business FlowEMEnterprise ManagerERPOracle ERP CloudFTFinancial TransactionsGLGeneral LedgerICSIntegration Cloud ServiceMDSMeta Data StoreOUCCB or CCBOracle Utilities Customer Care and BillingSOAService Oriented ArchitecturePreface - iiiCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Preface - ivCCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Part 1 - Understanding theIntegrationPart 1Understanding the IntegrationThis section provides an overview of the participating applications and informationregarding the business processes addressed by the integration.The section includes the following chapters: Introduction Understanding the Integration ProcessPart 1CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Chapter 1IntroductionThis section provides configuration and administration information for the integrationbetween Oracle Utilities Customer Care and Billing (CCB) and Oracle EnterpriseResource Planning Cloud Financials for General Ledger and Accounts Payable (ERP)using the ICS Utilities Adapter including: Prerequisites About the Integration Product Supported Business Processes Process Scheduling Best PracticesPrerequisitesAll participating applications (namely Oracle Utilities Customer Care and Billing, OracleEnterprise Resource Planning Cloud and Oracle Service Oriented Architecture) must beinstalled, set up, and working properly.About the Integration ProductThis section provides general information about the functionality and processing of theOracle Utilities Customer Care and Billing Integration to Oracle Enterprise ResourcePlanning Cloud Financials for General Ledger and Accounts Payable using the IntegrationCloud Service Utilities Adapter.Note: This is an AIA Direct Integration using SOA and does notrequire AIA Foundation Pack to be installed.The following products are involved in this integration: Oracle Integration Cloud Service (ICS) Utilities Adapter Oracle Utilities Customer Care and Billing Oracle Enterprise Resource Planning Cloud Financials for General Ledger andAccounts PayableIntroduction 1 - 1CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
About the Integration ProductOracle Integration Cloud Service (ICS) UtilitiesAdapterOracle Integration Cloud Service (ICS) simplifies building integrations in the cloud,enabling to connect securely to applications and services, both in cloud and on-premises.Oracle Utilities ICS Adapter integrates the Oracle Utilities Suite with your SaaS and onpremise applications to allow faster implementation, increased control, and lower costs.Trigger (inbound) and Invoke (Outbound) support is provided for Oracle Utilities ICSAdapter. The trigger capability enables Oracle Utilities Applications to trigger integrationin Oracle Utilities ICS Adapter and the invoke capability allows invocation of an OracleUtilities Application using web services from Oracle Integration Cloud Service.Both Inbound and Outbound Services are exposed using the Oracle Utilities ServiceCatalog. The Service Catalog provides a comprehensive list of services available forintegration. Oracle Utilities ICS Adapter provides a simplified user experience in terms ofcreating data mappings at design time while constructing integrations with Utilitiesapplications using the Oracle Utilities ICS Adapter.While creating a connection using Oracle Utilities ICS Adapter, specify a web service thatreturns a list of all Inbound/Outbound Services currently exposed as part of the CatalogService by one or more OUAF based applications.ICS Integration OverviewOracle Utilities Customer Care and BillingOracle Utilities Customer Care and Billing (CCB) is a customer and billing system thatmanages all aspects of customer service needed by most utilities to operate their business.Basic objects form the core of the system are: person, account, premise, serviceIntroduction 1 - 2CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Supported Business Processesagreement, and service point. These objects hold demographic, geographic, and financialinformation about a company's customers and properties. Related to these objects are theprocesses that they manage: bills, payments, meter readings, field activities, etc.Note: Refer to the Documentation and Resources section for currentapplication version details.Oracle Enterprise Resource Planning CloudFinancials for General Ledger and AccountsPayableOracle Enterprise Resource Planning Cloud is resource-planning software whichenforces industry best-practice controls on data input and process flows as tasks arecompleted within the system. Processes are separated into modules, and each moduleconsists of a collection of forms where data is entered at each stage of the businessprocess.As part of the Enterprise Resource Planning functionality, Oracle Enterprise ResourcePlanning Cloud Financials for General Ledger and Accounts Payable offers flexible ledgerarchitecture, consistent financial and operational information, dynamic planning,budgeting and forecasting, and multi-dimensional profitability analysis.Note: Refer to the Documentation and Resources section for currentapplication version details.Supported Business ProcessesThis integration of products incorporates three areas of key functionality to facilitate thetransfer of information between two applications. Data is sent from Oracle UtilitiesCustomer Care and Billing to Oracle Enterprise Resource Planning Cloud Financials forGeneral Ledger and Accounts Payable and vice versa using ICS Utilities Adapter tosupport the following transactions and actions.Introduction 1 - 3CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Supported Business ProcessesProcesses from Oracle Utilities Customer Care and Billing to Oracle ERP CloudOracle Utilities CustomerCare and BillingOracle ICS UtilitiesAdapterA bill is created/ cancelled. SOA reads and invokes theICS endpoint for GL Data. Using ICS Utilities Adapterto map data from CCB toERP, invokes the ICS ERPadapter and invokes ERPendpoint JournalImportService.The general ledger is updatedwith the journal information.SOA reads and invokes theICS Endpoint for APRequest. Using ICS Utilities Adapterto map from CCB to ERPinvokes the ICS ERP adapterand invokes ERP endpoint InvoiceInterfaceService.Customer and AP Requestinformation is used to create aone-time supplier and suppliersite. An accounts payableinvoice is created andassociated with the supplierand supplier site.A payment is created/cancelled. Adjustment is created/cancelled.An adjustment whose typeindicates AP Request iscreatedOracle ERP CloudIntroduction 1 - 4CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Process SchedulingFlows from Oracle ERP Cloud to Oracle Utilities Customer Care and BillingOracle ICS UtilitiesAdapterOracle Utilities CustomerCare and BillingA payment is created for aninvoice related to an OracleUtilities Customer Care andBilling AP Request. A check related to an invoicelinked to an AP request is reissued.Using ICS ERP Adapter tomap data from ERP to CCB,invoke the ICS Utilitiesadapter and invoke SOAEndpoint to update CCB tomake payment.Payment information is sentfrom ERP Cloud for GeneralLedger and Accounts Payableto Oracle Utilities CustomerCare and Billing. The AP Request is updatedwith the paymentinformation.A check related to an invoicelinked to an AP request isvoided and liability is closed.Using ICS ERP Adapter tomap from ERP to CCB,invoke the ICS Utilitiesadapter and invoke SOAEndpoint to update CCB tocancel payment.The AP request and itsassociated adjustment arecancelled.Oracle ERP CloudProcess SchedulingDepending on the size and complexity of your accounting system and business practices,transactions generated in either of the participating applications are sent to the alternateapplication on a daily or weekly schedule. Schedule the transfer of this informationbetween applications to occur according to a frequency that is most appropriate for yourorganization.Best PracticesThe following sections provide business information that helps achieve accurate anderror-free movement of data between Oracle Utilities Customer Care and Billing andOracle Enterprise Resource Planning Cloud Financials for General Ledger and AccountsPayable: Updating DVM in SOA Based ICS Catalog Service Importing CCB-ERP ICS Flows in ICS Environment One-Time Configuration Settings General Ledger Integration Accounts Payable (AP) Request and AP Data IntegrationsNote: For information about how to configure the integration specificsettings, refer to the Configuring the Integration chapter. Refer toproduct specific documentation for information on how to completethe product specific configuration tasks.Updating DVM in SOA Based ICS Catalog ServiceThe SOA Based ICS Catalog is a pre-requisite for this integration. After installing theCCB-ERP flows, ensure that the DVMs in ServiceCatalog.dvm (which is part ofIntroduction 1 - 5CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS Adapter Implementation Guide
Best PracticesICSCatalog partition of SOA MDS) is updated with the accurate location of thefollowing: AP Request and GL Data WSDLs in the SOA environment AP Data endpointImporting CCB-ERP ICS Flows in ICSEnvironmentRefer to the CCB-ERP Integration Using Oracle Utilities ICS Adapter and ERP ICS AdapterInstallation Guide for instructions on how to import the CCB-ERP ICS flows into the ICSenvironment.One-Time Configuration SettingsCertain one-time configuration settings must be coordinated manually to ensure properresults from the movement of data between the two applications.General Ledger ConfigurationOracle Enterprise Resource Planning Cloud Financials for General Ledger and AccountsPayable is the source of truth for all General Ledger information. Oracle UtilitiesCustomer Care and Billing is considered to be the sub-ledger. It is assumed that theGeneral Ledger has already been configured to accommodate your business needs.Distribution CodesOracle Utilities Customer Care and Billing uses distribution codes to map sub-ledgertransactions to the General Ledger Accounts. As part of your Oracle Utilities CustomerCare and Billing setup, it is assumed that you have properly mapped your distributioncodes to the General Ledger chart of accounts.General Ledger Divisions for Non-Integrated TransactionsIf some of the transactions created in Oracle Utilities Customer Care and Billing mustnot be integrated to your General Ledger, configure a separate General Ledger Divisionfor these transactions. Then, configure the integration product to distinguish whichGeneral L
between Oracle Utilities Customer Care and Billing (CCB) and Oracle Enterprise Resource Planning Cloud Financials for General Ledger and Accounts Payable (ERP) using the ICS Utilities Adapter including: Prerequisites About the Integration Product Supported Business Processes Process Scheduling Best Practices Prerequisites
The Oracle Utilities Smart Grid Gateway Adapter Development Kit provides a starting point for customers to create their own customized adapter for using Oracle Utilities Smart Grid Gateway with a specific head-end system. Oracle Utilities Smart Grid Gateway adapters support communication with a head-end system, including measurement data
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle Utilities Work and Asset Management 22 Oracle Utilities Mobile Workforce Management 24 Oracle Utilities Other Sessions (ODM, Opower, Etc.) 26 Oracle Utilities Technical Sessions 28 . 4 2017 ORACLE UTILITIES EDGE CUSTOMER
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
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
emissions reduction from smart grid deployment 28 14. Smart grid product providers 33 List of Tables 1. Characteristics of smart grids 7 2. Workshop contributions to the Smart Grids Roadmap 8 3. Smart grid technologies 19 4. Maturity levels and development trends of smart grid technologies 20 5. Select national smart grid deployment efforts 21 6.
Smart Grid and Cyber-Physical Systems Office National Institute of Standards and Technology U.S. Department of Commerce Smart Grid And CPS Testbed Update Smart Grid Federal Advisory Committee Meeting June 3, 2014. 2. Smart Grid and Cyber ‐ Physical Systems Testbeds Layout. Smart Microgrid Control Smart andRoom Intelligent Device Smart Storage .
