Release Notes
Release 12.2
E81923-01
September 2017
See also:
readme files included in the Oracle Utilities Data Model code.
This document outlines new features for Release 12.2 of Oracle Utilities Data Model. It also contains important information that was not included in the documentation for Oracle Utilities Data Model.
This document may be updated after it is released. To check for updates to this document and to view other Oracle documentation, refer to the Database section on the Web site:
This document contains the following topics:
Describes the new features of the release.
Oracle Utilities Data Model Release 12.2 provides the following:
Supports installation on Oracle Cloud.
Certification on Oracle Database 12c Release 2 (12.2)
Certification on Oracle Database 12c Release 1 (12.1.0.2.0)
Certification on Oracle Database 11g Release 2 (11.2.0.4.0)
Oracle Utilities Data Model Release 12.2 uses a new tablespace feature, where during installation you are prompted to enter tablespaces for different objects. In previous releases the installer created certain tablespaces. Now certain tablespaces for Oracle Utilities Data Model must be created before you run the installer.
3rd Normal Form (3NF) Data Model with transaction level access; the first data warehouse built based on the IEC Common Information Model (CIM) standards for utilities.
Three-layered data warehouse architecture to support a scalable business intelligence solution.
Comprehensive metadata for business intelligence reporting and ad-hoc query
Physical data model with industry specific measurements; Over 670 tables with over 4,800 columns; and 1,300 industry-specific measurements and 80 KPIs.
Sample Star Schema, OLAP Cubes and Analytical Models for ease of implementation.
Industry specific sample use cases for customer extensions.
Describes the new features of the release.
Oracle Utilities Data Model Release 12.2 provides the following:
Oracle Utilities Data Model Release 11.3.1 added support for the Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model (BRM Adapter). The BRM Adapter provides a pre-built integration to feed data from specific Oracle Communications Billing and Revenue Management application tables to Oracle Utilities Data Model.
New Physical Tables and Corresponding Logical Data Model Entities
Table 1-1 shows the new tables in Oracle Utilities Data Model Release 11.3.1.
Lookup table changes and extensions: this includes the addition of lookup tables to make the definition of code clearer and define, in one place only throughout the model certain entities such as: type of account role, religion, and of product coverage.
Reference table additions: The reference table Customer Community is added to take into account the increasing importance of social networking, out of Social Network Analysis or SNA, either from Internet or from the call behavior (A-B number analysis). Several communities can be defined per Customer.
Invoice Status history allows the tracing of the changes of the billing process.
Contracts has been extended with a specific EVENT and with Installment contract. The later covers the requirements associated to those specific contracts.
Service Level Agreement (SLA) analysis has been extended with a table that collects any violation over time.
Some subject areas in analytics were extended in Prepaid and balance tracing in general.
Table 1-1 Table and Logical Data Model Additions
| Table Name | Logical Data Model Entity Name |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changed Physical Tables and corresponding Logical Data Model Entities
In Release 11.3.1, some tables were renamed for clarity. Table 1-2 shows the renamed Physical Tables.
Table 1-2 Renamed Physical Tables
| Old Name | New Name | LDM Entity |
|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Oracle Utilities Data Model Release 11.3.1 has been certified with the TM Forum's Business Metric Automation (BMA) initiative. Oracle Utilities Data Model has been certified with the following BMA metric groups:
Billing Calculation (BICal)
Billing Inquiry, Dispute & Adjustment (BIDA)
Billing Collection Management (BCM)
Billing Receivables Management (BRM)
Fulfillment Customer Order Management (COM)
Fulfillment Service Order Management (SOM)
Service Level Agreement Management (SLA)
Service Providers participating in TM Forum benchmark studies can now use Oracle Utilities Data Model to calculate the various metrics for these categories and automatically submit the resulting data to TM Forum. A set of scripts are provided to facilitate the data submission to TMF. Additional information can be found on the TM Forum website at:
To create the required TMF Benchmark tables, do the following:
Create the tables DWD_TMF_KPI and DWD_TMF_KPI_ENTRY_RESULT:
create table dwd_tmf_kpi( batchid number(10), company varchar2(255), product varchar2(255), serviceproviderid number(10,0), researchstream_name varchar2(255), study_name varchar2(255), metric_name varchar2(255), datapoint_name varchar2(255), detail0 varchar2(255), detail1 varchar2(255), detail2 varchar2(255), entry varchar2(255), batchid number(10)); create table dwd_tmf_kpi_entry_result( "COMPANY" VARCHAR2(255 BYTE), "PRODUCT" VARCHAR2(255 BYTE), "SERVICEPROVIDERID" NUMBER(10,0), "RESEARCHSTREAM_NAME" VARCHAR2(255 BYTE), "STUDY_NAME" VARCHAR2(255 BYTE), "METRIC_NAME" VARCHAR2(255 BYTE), "DATAPOINT_NAME" VARCHAR2(255 BYTE), "DETAIL0" VARCHAR2(255 BYTE), "DETAIL1" VARCHAR2(255 BYTE), "DETAIL2" VARCHAR2(255 BYTE), "ENTRY" VARCHAR2(255 BYTE), "BATCHID" NUMBER(10,0), "STATUS" VARCHAR2(20 BYTE), "MESSAGE" varchar2(255))
Unzip the supplied tmfclient.zip file (this is in the directory $ORACLE_HOME/ocdm/utl/tmf_kpi/).
Go to directory TMFClient.
Run the command:
java TMFMain [location of config file] [batchid]
Create a config file with the following parameters and save it as the parameters for step three. This file should be a plain text file:
##content of config file start USERNAME=ocdm_db_username PASSWORD=ocdm_db_password URL=jdbc:oracle:thin:@//localhost:1521/orcl INPUTDIR=C:\Projects\TMF\input OUTPUTDIR=C:\Projects\TMF\output TMFUSERNAME=g433304 TMFPASSWORD=4t153246R ##content of config file end
In previous releases Oracle Utilities Data Model included a single data mining model to be used for predicting churn for both prepaid or postpaid subscribers. In Release 11.3.1 these data mining models are included as two separate mining models, which provide greater applicability for the specific subscriber type.
In Release 11.3.1 the intra-ETL available with Oracle Utilities Data Model are all written in PL/SQL..
Lists the known issues in this release and where possible, provides a workaround for the known issue.
This release has the following known issues:
When installing Oracle Utilities Data Model, the Oracle Installer reports only the amount of space required for copying theOracle Utilities Data Model files (that is, 240MB).
However, a fully-installed and configured Oracle Utilities Data Model also requires space for the Database files created during the post-install configuration of Oracle Utilities Data Model.
If insufficient space is available for the Oracle Utilities Data Model Database files, the Oracle Utilities Data Model installation fails during configuration.
This issue is documented in Bug 13243223.
Workaround
Before installing and configuring Oracle Utilities Data Model, ensure that at least 3 GB is available.
This error occur when changing the default values. For example in the reports: Event Analysis and Usage point Analysis, when you choose '2000 MAR' at Event Analysis, the error shows:
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes:
OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058.
[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed:
[nQSError: 59137] Filter level CLNDR_MO is below the projected level CLNDR_YR
on dimension TIME while an externally aggregated measure is present. (HY000)
SQL Issued: SELECT s_0, s_1, s_2,
s_3, s_4, s_5, s_6, s_7, s_8 FROM ( SELECT 0 s_0,
.
.
.
This issue is documented in Bug 17586358.
Workaround:
Reports work fine with default values.
The Meter Data and TOU Usage Trend reports show incorrect totals.
This issue is documented in Bug 17584565.
Workaround:
There is no workaround for this issue.
Performance of the package for pkg_dwd_acct_arrer_mo needs to be improved.
This issue is documented in Bug 17420802.
Workaround:
There is no workaround for this issue.
Not all entities are shown in Metadata Reports; each entity should show in a subject area and a business area.
This issue is documented in Bug 17415854.
Workaround:
There is no workaround for this issue.
Bug 13601107 deinstall warning error in the deinstall log file
The following warning message, or messages similar to the following message can be ignored on deinstall:
WARNING: Error while copying directory //dbhome_1/inventory with exclude file list '/tmp/OraInstall2012-01-11_02-37-25PM/installExcludeFile.lst' to nodes . /logs/installActions2012-01-11_02-37-25PM.log' . for details. You may fix the errors on the required remote nodes Refer to the install guide for error recovery. This deinstallation was successful End of deinstallations
A number of warning messages appear in the RPD included in Oracle Utilities Data Model. The warning messages do not impact any of the out-of-the-box reports included with Oracle Utilities Data Model.
Describes documentation changes for this release.
The Oracle Utilities Data Model documentation set for this release consists of the manuals in the previous release
The following books includes updates:
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle® Utilities Data Model Release Notes, Release 12.2
E81923-01
Copyright © 2012, 2017, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license 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. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you 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 on behalf 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 and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used 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 Micro Devices. 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 expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible 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.