Oracle Utilities Energy Information Platform

Release Notes for:

Oracle Utilities Billing Component Oracle Utilities Load Profiling and Settlement, Oracle Utilities Meter Data Management, Oracle Utilities Portfolio Management, Oracle Utilities Quotations Management, Oracle Utilities Rate Management, Oracle Utilities Transaction Management,

Release 1.6.1.22 for Windows

November 2017

Oracle Utilities Energy Information Platform Release Notes

Copyright © 1999, 2017 Oracle and/or its affiliates. All rights reserved.

Primary Author: Louis J. Prosperi

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, 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 on 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. 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.

NOTIFICATION OF THIRD-PARTY LICENSES

Oracle Utilities software contains third party, open source components as identified below. Third- party license terms and other third-party required notices are provided below.

License: Apache 1.1

Module: Crimson v1.1.1, Xalan J2

Copyright © 1999-2000 The Apache Software Foundation. All rights reserved.

Use of Crimson 1.1.1 and Xalan J2 within the product is governed by the following (Apache 1.1):

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution. (3) The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http://www.apache.org/) ." Alternately, this acknowledgment may appear in the software itself, if and wherever such third-party acknowledgments normally appear. (4) Neither the component name nor Apache Software Foundation may be used to endorse or promote products derived from the software without specific prior written permission. (5) Products derived from the software may not be called "Apache", nor may "Apache" appear in their name, without prior written permission.

THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

License: CoolServlets.com

Module: CS CodeViewer v1.0 (Sun JRE Component)

Copyright © 1999 by CoolServlets.com

Use of this module within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution. (3) Neither the component name nor Coolservlets.com may be used to endorse or promote products derived from the software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY COOLSERVLETS.COM AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE."

License: Justin Frankel, justin@nullsoft.com

Module: NSIS 1.0j (Sun JRE Component)

Use of this module within the product is governed by the following:

(1) The origin of the module must not be misrepresented, and Oracle may not claim that it wrote the original software. If Oracle uses this module in a product, an acknowledgment in the product documentation is appreciated but not required. (2) Altered source versions of the module must be plainly marked as such, and must not be misrepresented as being the original software. (3) The following notice may not be removed or altered from any source distribution: "Justin Frankel justin@nullsoft.com".

License: ICU4j License

Module: ICU4j

Copyright © 1995-2001 International Business Machines Corporation and others. All rights reserved.

Oracle may use the software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the software, and to permit persons to whom the software is furnished to do so, provided that the above copyright notice and the permission notice appear in all copies of the software and that both the above copyright notice and the permission notice appear in supporting documentation.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

License: Info-ZIP

Module: INFO-ZIP ZIP32.DLL (Binary Form)

Copyright (c) 1990-2005 Info-ZIP. All rights reserved

Use of this dll within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the definition and disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the definition and disclaimer below in the documentation and/or other materials provided with the distribution. The sole exception to this condition is redistribution of a standard UnZipSFX binary (including SFXWiz) as part of a self-extracting archive; that is permitted without inclusion of this license, as long as the normal SFX banner has not been removed from the binary or disabled. (3) Altered versions--including, but not limited to, ports to new operating systems, existing ports with new graphical interfaces, and dynamic, shared, or static library versions--must be plainly marked as such and must not be misrepresented as being the original source. Such altered versions also must not be misrepresented as being Info-ZIP releases--including, but not limited to, labeling of the altered versions with the names "Info-ZIP" (or any variation thereof, including, but not limited to, different capitalizations), "Pocket UnZip," "WiZ" or "MacZip" without the explicit permission of Info-ZIP. Such altered versions are further prohibited from misrepresentative use of the Zip-Bugs or Info-ZIP e-mail addresses or of the Info-ZIP URL(s). (4) Info-ZIP retains the right to use the names "Info-ZIP," "Zip," "UnZip," "UnZipSFX," "WiZ," "Pocket UnZip," "Pocket Zip," and "MacZip" for its own source and binary releases.

[Definition]: For the purposes of this copyright and license, "Info-ZIP" is defined as the following set of individuals:

Mark Adler, John Bush, Karl Davis, Harald Denker, Jean-Michel Dubois, Jean-loup Gailly, Hunter Goatley, Ed Gordon, Ian Gorman, Chris Herborth, Dirk Haase, Greg Hartwig, Robert Heath, Jonathan Hudson, Paul Kienitz, David Kirschbaum, Johnny Lee, Onno van der Linden, Igor Mandrichenko, Steve P. Miller, Sergio Monesi, Keith Owens, George Petrov, Greg Roelofs, Kai Uwe Rommel, Steve Salisbury, Dave Smith, Steven M. Schweda, Christian Spieler, Cosmin Truta, Antoine Verheijen, Paul von Behren, Rich Wales, Mike White

[Disclaimer:] "This software is provided "as is," without warranty of any kind, express or implied. In no event shall Info-ZIP or its contributors be held liable for any direct, indirect, incidental, special or consequential damages arising out of the use of or inability to use this software."

License: Paul Johnston

Modules: md5.js

Copyright (C) Paul Johnston 1999 - 2002

Use of these modules within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution. (3) Neither the component name nor the names of the copyright holders and contributors may be used to endorse or promote products derived from the software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

License: Jef Poskanzer

Modules: DES, 3xDES (Sun JRE Components)

Copyright © 2000 by Jef Poskanzer <jef@acme.com>. All rights reserved

Use of these modules within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution. (3) Neither the component name nor the name of Jef Poskanzer may be used to endorse or promote products derived from the software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

License: Sun Microsystems, Inc.

Modules: Sun Swing Tutorials

Copyright© 1995-2006 Sun Microsystems, Inc. All Rights Reserved.

Use of these modules within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution. (3) Neither the component name nor the name of Sun Microsystems, Inc. and contributors may be used to endorse or promote products derived from the software without specific prior written permission. (4) Oracle must acknowledge that the software is not designed, licensed or intended for use in the design, construction, operation or maintenance of any nuclear facility.

THIS SOFTWARE IS PROVIDED "AS IS," WITHOUT A WARRANTY OF ANY KIND. ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. SUN MICROSYSTEMS, INC. ("SUN") AND ITS LICENSORS SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING OR DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES. IN NO EVENT WILL SUN OR ITS LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE OF OR INABILITY TO USE THIS SOFTWARE, EVEN IF SUN HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

License: Tom Wu

Module: jsbn library

Copyright © 2003-2005 Tom Wu. All rights reserved

Use of this module within the product is governed by the following:

(1) Redistributions of source code must retain the above copyright notice, this list of conditions and the disclaimer below. (2) Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the disclaimer below in the documentation and/or other materials provided with the distribution.

THE SOFTWARE IS PROVIDED "AS-IS" AND WITHOUT WARRANTY OF ANY KIND, EXPRESS, IMPLIED OR OTHERWISE, INCLUDING WITHOUT LIMITATION, ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL TOM WU BE LIABLE FOR ANY SPECIAL, INCIDENTAL, INDIRECT OR CONSEQUENTIAL DAMAGES OF ANY KIND, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER OR NOT ADVISED OF THE POSSIBILITY OF DAMAGE, AND ON ANY THEORY OF LIABILITY, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

Release Notes

These release notes describe enhancements, installation information, upgrade notices, and de-support information for Oracle Utilities Energy Information Platform Version 1.6.1.22 and the following related products:

•

Oracle Utilities Billing Component

•

Oracle Utilities Load Profiling and Settlement

•

Oracle Utilities Meter Data Management

•

Oracle Utilities Portfolio Management

•

Oracle Utilities Quotations Management

•

Oracle Utilities Rate Management

•

Oracle Utilities Transaction Management

These release notes supplement the Oracle Utilities product documentation and include updated information about this release. Refer to those manuals when installing these products. These release notes contain the following:

•

Installation and System Configuration Information

•

Database Schema Versions

•

Functional Changes

•

Recommendations and Warnings

•

Enhancements

•

De-Support Notices

•

De-Support Notices

•

De-Supported Platforms in Version 1.6.1.22

•

Bug Fixes

Installation and System Configuration Information

This section outlines specific topics related to installation and configuration of the Energy Information Platform and related products.

•

This release of the Oracle Utilities software requires the 4.5 .NET framework (available at http://www.microsoft.com/en-us/download/details.aspx?id=30653). This should be installed before installing the Energy Information Platform software.

•

This release of the Oracle Utilities software requires the Visual C++ Redistributable Packages for Visual Studio 2013 (32 bit) (available here: http://www.microsoft.com/en-us/download/details.aspx?id=40784). This should be installed before installing the Energy Information Platform software.

•

Though not typical, there is a potential conflict between the Java Runtime Engine (JRE) installed by Oracle Utilities and the JRE installed by Oracle. This conflict can be avoided by ensuring that the path to the Oracle Utilities-installed JRE is listed before the path to the Oracle JRE in the "Path" System variable.

•

This release supports Microsoft Internet Information Services (IIS) versions 7.5 (7.5.7600) or 8.5.

•

This release supports Oracle database version 12.2.0.1.

•

When configuring Microsoft Internet Information Services (IIS), use "ASP.NET v4.0 Classic" as the Application Pool.

Database Schema Versions

The version numbering for all Oracle Utilities Data Repository database schemas has been changed to use a consistent numbering for all products. The table below lists the prior schema version numbers for the Energy Information Platform and each related product and the current schema version numbers as of this release.

Product

Prior Schema Version(s)

v1.6.0 Schema Version

v1.6.1 Schema Version

Energy Information Platform

v5.42.017

v1.6.0.0.0

v1.6.1.22.0

Oracle Utilities Billing Component

v2.42.014 (Contracts)

v5.42.003 (Receivables)

v5.42.001 (Workflow)

v1.6.0.0.0

v1.6.0.0.0

v1.6.0.0.0

v1.6.1.0.0

v1.6.1.2.0

v1.6.1.0.0

Oracle Utilities Load Profiling and Settlement

v3.42.013

v1.6.0.0.0

v1.6.1.21.0

Oracle Utilities Meter Data Management

v3.42.035

v1.6.0.0.0

v1.6.1.22.0

Oracle Utilities Portfolio Management

v2.42.001

v1.6.0.0.0

v1.6.1.0.0

Oracle Utilities Quotations Management

v2.42.014 (Contracts)

v2.42.002 (Usage)

v1.6.0.0.0

v1.6.0.0.0

v1.6.1.0.0

v1.6.1.1.0

Oracle Utilities Rate Management

N/A*

N/A*

N/A*

Oracle Utilities Transaction Management

v4.42.009

v1.6.0.0.0

v1.6.1.0.0

*Oracle Utilities Rate Management uses the Energy Information Platform database and does not require database updates.

Functional Changes

This section outlines changes in functionality in this release of the Energy Information Platform and related products. This includes:

•

Interval Data Graphs

•

Adapter Rule Description Language Mapping

•

DEPRECATED NOTICE - Crystal Reports

•

Oracle Utilities Receivables Component Reports

•

Install MSMXL Version 6

•

JDBC Driver No Longer Provided with Installation

•

DEPRECATED NOTICE - Web Services

•

DEPRECATION NOTICE - Meter Commands

•

DEPRECATION NOTICE - BPEL Web Services

•

DEPRECATION NOTICE - Oracle Utilities Rules Language Server

•

Using Oracle Business Intelligence Publisher with the Reporting Framework

Interval Data Graphs

The components used to display interval data graphs have been updated to use the Oracle Java Extension Toolkit (Oracle JET). The use and operation of these graphs has not been changed.

Adapter Rule Description Language Mapping

The Adapter Rule Description Language Configuration screen has been updated to use the Oracle Java Extension Toolkit (Oracle JET). This change has resulted in minor changes to the way in which mappings are created. The Oracle Utilities Energy Information Platform User’s Guide has been updated to reflect these changes.

DEPRECATED NOTICE - Crystal Reports

Crystal Reports has been deprecated and is no longer supported as of release v1.6.1.22.

Oracle Utilities Receivables Component Reports

Oracle Utilities Receivables Component reports have been converted to run using Oracle BI Publisher. See Chapter 10: Reports in the Oracle Utilities Billing Component Installation and Configuration Guide, Volume 2 for more information.

Install MSMXL Version 6

Release v1.6.1.19 and earlier use MSXML v4. Release v1.6.1.20 and later require MSXML v6. Upgrading the Oracle Utilities Energy Information Platform and related products to this release (v1.1.6.1.20) or later requires installing MSMXL v6.

Note: MSXML6 is installed by default in Windows 2012.

For Windows 2008 servers, use the following procedure:

1.

Manually install MSXML6.

Download the installer from this location

http://www.microsoft.com/en-sg/download/details.aspx?id=3988

2.

Click Download.

3.

Select "msxml6.msi" and click Next.

4.

After the download is complete, double-click on the "msxml6.msi" to install.

5.

To verify the installation, open a command prompt, navigate to c:\windows\system32, and type "dir msxml*".

JDBC Driver No Longer Provided with Installation

As of the v1.6.1.18 release the JDBC driver used by the Energy Information Platform Adapter and Oracle Utilities Meter Data Management is no longer provided as part of the installation. For this and future releases, the JDBC driver must be downloaded and installed manually.

The following steps must be performed on each server that will run the Adapter and/or the Meter Data Management application.

1.

Download the driver appropriate to your database and application version. The table below specifies the JDBC driver version (and related jar file) based on both the version of the application and the Oracle Database version.

EIP Version

Oracle 11g

Oracle 12c

v1.6.1.17 (or prior)

v1.6

ojdbc6.jar

N/A

v1.6.1.18 to v1.6.1.21

v1.6

ojdbc6.jar

v1.7

ojdbc7.jar

v1.6.1.22 (or later)

v1.6

ojdbc6.jar

v1.8

ojdbc8.jar

2.

Place the driver in a known location on the server (such as c:\JDBC).

3.

Update the batch files for Adapter Monitor and Adapter Server startup:

For versions prior to 1.6.1.18 :

a.

Open the LTMH\Runtime directory and edit the LTMH_Setup.bat file in a text editor

b.

Look for the following line:

set JDBC_CP=%LTMH_LIB%\ojdbc14.jar;%LTHM_LIB%\jtds-1.0.2.jar

c.

Update this line to point to the full path of the JDBC driver downloaded above:

set JDBC_CP=C:\JDBC\ojdbc6.jar

Save the file.

For versions 1.6.1.18 through v1.6.1.21 :

a.

Open the LTMH\Runtime directory and edit the L TMH_JDBC.bat file in a text editor

b.

Look for the following line:

set JDBC_CP=%LTMH_LIB%\ojdbc14.jar;%LTHM_LIB%\jtds-1.0.2.jar

c.

Update this line to point to the full path of the JDBC driver downloaded above:

For Oracle 11G:

set JDBC_CP=C:\JDBC\ojdbc6.jar

For Oracle 12c:

set JDBC_CP=C:\JDBC\ojdbc7.jar

Save the file.

For versions 1.6.1.22 and later :

a.

Open the LTMH\Runtime directory and edit the L TMH_JDBC.bat file in a text editor

b.

Look for the following line:

set JDBC_CP=%LTMH_LIB%\ojdbc14.jar;%LTHM_LIB%\jtds-1.0.2.jar

c.

Update this line to point to the full path of the JDBC driver downloaded above:

For Oracle 11G:

set JDBC_CP=C:\JDBC\ojdbc6.jar

For Oracle 12c:

set JDBC_CP=C:\JDBC\ojdbc8.jar

Save the file.

4.

Log into the Energy Information Platform and update the Class Path field on all System Properties records to include the full path to the file you downloaded above. For example, append ";C:\JDBC\ojdbc8.jar" to each record. No other JDBC driver references should exist in the Class Path field.

Note : You must restart the Adapter Server for these changes to take effect.

DEPRECATED NOTICE - Web Services

The Oracle Utilities Energy Information Platform and Meter Data Management web services have been deprecated and are no longer supported as of release v1.6.1.20.

DEPRECATION NOTICE - Meter Commands

The Meter Commands feature of Oracle Utilities Meter Data Management has been deprecated and is no longer supported.

DEPRECATION NOTICE - BPEL Web Services

The Oracle Utilities Meter Data Management Business Process Execution Language (BPEL) Web Services have been deprecated and are no longer supported.

DEPRECATION NOTICE - Oracle Utilities Rules Language Server

The Oracle Utilities Rules Language Server, a component used by previous versions of Oracle Utilities Meter Data Management has been deprecated and is no longer supported.

The functionality formerly provided by this component has been replaced by the new "MDMPORTAL" Adapter runtime service type. See Activating an MDMPORTAL Service on page 3-9 in the Oracle Utilities Meter Data Management Installation and Configuration Guide for more information about using the "MDMPORTAL" Adapter runtime service type.

Using Oracle Business Intelligence Publisher with the Reporting Framework

In this release, when using Oracle Business Intelligence Publisher with the Reporting Framework, the LSReportMonitor.cfg.xml configuration file must be updated to specify the version of Oracle Business Intelligence Publisher being used.

The Oracle Business Intelligence Publisher version is specified via the <VERSION> element within the <BI_PUBLISHER> element in the LSReportMonitor.cfg.xml configuration file.

This release supports Oracle Business Intelligence Publisher version 10.1.3.4 and version 11.1.1.5.

•

To specify use of Oracle Business Intelligence Publisher version 10.1.3.4, enter a value of "10" in the <VERSION> element.

•

To specify use of Oracle Business Intelligence Publisher version 11.1.1.5, enter a value of "11" in the <VERSION> element.

LSREPORTMONITOR.CFG.XML Example

<LSREPORTMONITOR>

...

<BI_PUBLISHER>

<URL>http://localhost:8088/xmlpserver</URL>

<CONNECTSTRING>UID=BIP userid;PWD=BIP password</CONNECTSTRING>

<VERSION>10</VERSION>

<TIMEOUT>500000</TIMEOUT>

</BI_PUBLISHER>

</LSREPORTMONITOR>

See LSREPORTMONITOR.CFG.XML on page 2-36 in the Oracle Utilities Energy Information Platform Configuration Guide for more information about the LSReportMonitor.cfg.xml configuration file.

Recommendations and Warnings

This section outlines recommendations and warnings related functionality in the Energy Information Platform and related products. This includes:

•

Web Services and Rules Language Processing

•

Configuring Stateless Non-Sticky Sessions in Windows 2008

Web Services and Rules Language Processing

Oracle Utilities recommends against using web service interfaces with Adapter Business Rules of type Rate (i.e. calling a Rules Language process). These web services have not been designed to be scalable when used to execute Rules Language processing, and are not suitable for use in a production environment. Using Adapter Business Rule (ABR) web services in this way is not supported. Only Adapter Runtime Service (ARS) web services are supported when executing Rules Language processing via a web service.

Configuring Stateless Non-Sticky Sessions in Windows 2008

Lodestar application servers are stateless in terms of deployment in a web farm environment. In a web farm deployment, there are multiple installations of the web application server on different machines. In order to support load balancing without the use of "sticky" sessions, all the installed web applications need to share the same security Machine Key. Below is the process of generating a standard IIS Machine Key and applying it to all web application servers in a web farm.

How to configure stateless non-sticky sessions in Windows 2008:

1.

Select Start-›Administrative Tools-›Internet Information Services (IIS) Manager on the first web application server in the web farm.

2.

Select the "lodestar" web application in the Connections pane. This located as follows:

[SERVER] / Sites / Default Web Site / lodestar

3.

Double-click the Machine Keys icon in the ASP.NET pane.

The Machine Key pane displays the machine key settings for the application server.

4.

Create a random machine key for the web application server.

a.

Click Generate Keys in the Actions pane (to the right of the Machine Key pane)Click Generate Keys in the Actions pane (to the right of the Machine Key pane).

b.

Click Apply in the Actions pane.

The new machine keys are stored in the following section of the web.config file in the \\lodestar\web directory.

<system.web>

...

<machineKey decryption="AES"

decryptionKey="EF5C ... 0850"

validationKey="24E3 ... ... ... B6CC" />

...

</system.web>

c.

Copy the <machineKey> element to a text document. You will use this to update your other web application servers.

4.

Apply the new machine keys to the other web application servers. For each application server:

a.

Open the web.config file in a text editor.

b.

Insert or replace the <machineKey.../> element in this file with the element from the original file.

b.

Save the web.config file and restart IIS.

Upgrade Recommendations

Some components and functionality has changed in the v1.6 release of Energy Information Platform and related products. As a result, unexpected results may occur when using certain types of data from pre-v1.6 versions with the current version.

This section outlines recommendations when upgrading the Energy Information Platform and related products.

Updating Lists

The table-column and account/customer list functionality changed in v1.6 of the Energy Information Platform. As a result, some lists created in pre-v1.6 versions may behave in an unexpected manner when used in v1.6+ versions.

When upgrading from v1.5 or previous versions, Oracle Utilities recommends exporting all table-column and account/customer lists from the pre-v1.6 environment, and then importing the lists into the v1.6+ environment.

Enhancements

This section highlights enhancements introduced in this release of the Energy Information Platform. This includes:

•

Security Enhancements

Security Enhancements

This release of the Energy Information Platform includes the following security enhancements:

Code Execution Prevention

The Oracle Utilities Energy Information Platform has been enhanced to ensure that certain code execution prevention protections are enabled. This makes it significantly more difficult for an attacker to crack the application using attacks such as buffer overflows.

These include:

•

Detecting and preventing buffer overflows overwriting the execution stack.

•

Preventing a class of stack overflow exploits that attempt to bypass stack cookie integrity protection by triggering an exception before the stack cookie is checked.

In addition, the following features are also enabled:

•

Address Space Layout Randomization (ASLR), a buffer overflow prevention technique that makes it significantly harder to craft working stack overflows.

•

Windows Data Execution Prevention (DEP), which marks areas of memory as non-executable. This makes it significantly harder to craft working stack and heap overflows.

Reference: Bug #20876302

Information Disclosure

The Oracle Utilities Energy Information Platform has been enhanced to ensure that sensitive information about the underlying system are excluded from the error messages displayed on the user interface.

Reference: Bug #20876288

De-Support Notices

This section highlights platforms that are either no longer supported in this release or that will not be supported in future releases of the Energy Information Platform and related products. This includes:

•

De-Supported Platforms in Version 1.6.1.22

De-Supported Platforms in Version 1.6.1.22

The following previously supported platforms are not supported in this release of Oracle Utilities Energy Information Platform and related products:

•

MS SQL Server 2008

•

Windows Enterprise Server 2003

•

Windows XP

•

Windows Vista

•

Internet Explorer 8

•

Oracle 10g

•

Pervasive PSQL Server Summit (all versions)

•

Crystal Reports 2008

Bug Fixes

This section lists issues that have been fixed in this release of Oracle Utilities Energy Information Platform and related products, including:

•

Bugs Fixed in v1.6.1.22

•

Bugs Fixed in Previous Versions, Patches, or Roll-ups

Bugs Fixed in v1.6.1.22

The following issues were fixed as of this release.

Bug Number

Description

21674931

The term "Significant" is incorrect when referring to "significant digits".

22091168

Issue with incorrect time shown in Microsoft Outlook in emails generated through Energy Information Platform.

22189806

Issue with hidden user interface text when using the "Fusion" theme.

22567487

Issue with documentation incorrectly referring to Windows 2012 R2 Enterprise Edition.

22675254

Issue with references to unsupported versions of Oracle database in documentation.

22695820

Issue with documentation related to Microsoft Visual C++ Redistributable Packages for Visual Studio (should indicate 32-bit).

22705672

Issue with steps for configuration of Windows 2012 server in Energy Information Platform Installation Guide.

24906664

Issues and errors when deleting data from the Meter Data Channel Cut table.

25094538

Issue with Adapter business rule handing when file has more than 2 parameters.

25631853

Issue with a repeated error related to DST in log files.

25684693

Issue with Versions tab display on Usage Analysis screen.

22705672

Issue with documentation for configuration a Windows 2012 server in Energy Information Platform Installation Guide.

Bugs Fixed in Previous Versions, Patches, or Roll-ups

The following issues were fixed in either a previous release, a single patch, or as part of a patch roll-up, and were also fixed in this release.

Bug Number

Description

22079493

COPY OF 22318098 - TOU BUCKETS USAGE DETAIL FRAME MISSING IN IE11

21651104

COPY OF 22243503 - UNC REFERENCES FAILING FROM RULES LANGUAGE ON OCCASION

21963562

COPY OF 21792517 - USAGE ANALYSIS SCREEN NOT DISPLAYING ALL USAGE DATA

25325570

COPY OF 25268598 - USAGE ANALYSIS IS NOT GIVING A CORRECT RESULTS IN GRAPH

24799172

COPY OF 22984772 - IEE USAGE LOADING 1.5 AND 1.6 OUTPUT IS DIFFERENT

24798798

COPY OF 23026800 - REMOVE COMMA'S FROM A NUMBER OF FIELDS

24609814

COPY OF 24530075 - ERROR WHEN VIEWING AUTOBILL BILLING REPORTS FROM THE GU

22929613

COPY OF 22815311 (COPY OF 13821253) - ADAPTER SUBTRACTING START FROM STOP IN D

22929275

COPY OF 22766441 - BAD REGISTER READINGS BEING CALCULATED

22760302

COPY OF 22457782 - SUMCHECK ISSUE WHEN IMPORTING .LSM FILESREADINGS BEING

25382826

COPY OF 25352510 - CURRENT BILL CREATING CIS OUTPUT WHEN REJECTED

25325563

COPY OF 25263722 - CURRENT/FINAL BILL DOESN'T SAVE ONE OF THE EXPECTED OUTPUT F

25264150

COPY OF 25205648 - FORCED LOGOUT ON 4TH PAGE (100 ON EACH PAGE) AND SELECTING ALL CUTS

25186593

COPY OF 25176406 - IIS CRASHES WHEN GRAPHING INTERVAL DATA

24806323

COPY OF 24796059 - MV9 FILE IN 1.6 IS SHOWING MORE INTERVALS THAN 1.5 DID

24805739

COPY OF 24753266 - GRAPH DATA FROM METER DATA CHANNEL CUTS TABLE NO LONGER WORK

24799334

COPY OF 23010641 - INSTALLATION OF PATCH: 22866660 RETURNS A 400 OR 500 ERROR

24799128

COPY OF 23048504 - APPLICATION SERVER INSTALL NEEDS TO INSTALL WITHOUT II

24798793

COPY OF 24711146 - BILLING ISSUES W/ BILL REJECTION (NO BH GENERATED) STILL PRO

24798784

COPY OF 24351654 - ADJUST OPTION NOT CLICKABLE WHEN FIRST BILL IS NOT APPROVED

22929283

COPY OF 22664132 - DIFFERENCE IN THE DECIMAL PRECISION (1.5 = 3; POC=12)

22760291

COPY OF 22263220 - MDM 1.6 IS NOT INSERTING ADU CORRECTLY

26381636

COPY OF 26305713 - ER: A WAY TO HAVE A SINGLE REPORT PROCESSED BY A SPECIFIC RE

26224383

COPY OF 25975685 - BILL_START/BILL_STOP HISTVALUES CAUSING INTD FUNCTIONS TO FA

25396475

COPY OF 25162842 - UNABLE TO SEE MEMBER GROUP IN RULE DESCRIPTION LANGUAGE

23622805

COPY OF 23069528 - ADAPTER FILE PROCESSING ISSUE IN QM VERSION

26595540

COPY OF 26317456 - RDL PAGE MAPPINGS VISIBILITY

26480161

COPY OF 25201749 - EMPTY SEARCH WILL CREATE HUGE LOAD ON DB

26391330

COPY OF 23562927 - AFTER SP19 APPLY JAVAW.EXE CRASHES WHEN RTS RESTART INTERVAL

25956027

COPY OF 25879559 - PATCH: 25865420 (1.6.1.21.23) DID NOT FIX READS FROM USAGE

25865481

COPY OF 25835930 - PATCH 25791165 (V1.6.1.21.22) FOR BUG 25688621 DOES NOT WORK

25791171

COPY OF 25688621 - ERROR WHILE VALIDATING READS FROM USAGE ADD/EDIT SCREEN

24798842

COPY OF 23507978 - LSM UPLOAD SLOW PERFORMANCE IN PATCH 21

26629132

COPY OF 26560756 - INSTALLATION COMMAND LINES TO SET OPTIONS

24561929

COPY OF 24400899 - PROBLEM WITH SAVE BY ARRAY WITH INSERT AND UPDATE MIXE

23573986

COPY OF 22869037 - SAVE #ARRAYIDENTIFIER[] TO TABLE WHEN ARRAY CONTAINS ONE ROW.

23538568

COPY OF 23477630 - SAVE ARRAY NOT WORKING, WHEN RECORD REFERENCES A PARENT

23006706

COPY OF 22928515 - DOMDOCGETROOT DOES NOT WORK ON CLOB COLUMNS FETCHED VIA SQL LIST

24798892

COPY OF 23131230 - PROBLEM SEARCHING "ENHANCED" INTERVAL DATA TABLE

24798845

COPY OF 24293898 - COM.LODESTARCORP.PORTAL.DATA.MV90CONVERTER ISSUE WITH ORACLE

25396473

COPY OF 24839478 (COPY OF 24804028) - DISABLE LOG GENERATION IN LTMH ADA

24839500

COPY OF 24804028 - DISABLE LOG GENERATION IN LTMH ADAPTER

26160422

COPY OF 26108027 - UNNECESSARY LOG IN ADAPTER

25840341

COPY OF 25822856 - INTERVAL DATA LOAD/BROWSE STOPS WORKING WHEN UIDCHANNELCUT I

26075059

COPY OF 26039604 - SOME NON-9 STATUS CODES ARE INCONSISTENLY BEING EVALUATED AS

22921670

COPY OF 22879139 - LTMH SERVICE THROTTLING FAILS WHEN SERVICE_THROTTLING_BA

22613889

COPY OF 22600221 CRASH WHEN LOADING INTD FOR A YEAR WITH INTDJOINTIMESTAMP IN CFG

22594231

COPY OF 22552225 - DATA MANAGER CRASH OVER FALL DST FOR INTDLOADDATES AFTER PATCH 2244644

22391877

COPY OF 22452051 LOAD INTD SERIES SPAN SPRING/FALL DST CAUSES INCORRECT NOV SHIFT

22127956

COPY OF 22333071 - USAGE / INTERVAL DATA CANNOT EDIT INTERVAL DATA

26824458

COPY OF 26649620 - CROSS-SITE SCRIPTING

26549337

COPY OF 26445115 - DATA MANAGER LIST QUERY MODIFICATION NOT RETURNING EXPE

25963398

COPY OF 24813701 - DATA MANAGER - ABORTS AFTER RUNNING A BILL HISTORY REPORT

25956554

COPY OF 25078063 - OU RATE MANAGER 1.6.1.21.13 PATCH- LIST ERROR

24798833

COPY OF 24583394 - WHEN A SINGLE ACCOUNT IS USED TO RUN A CUSTOMER REVENUE REPO

24799203

COPY OF 22726995 - ERROR WHEN INSTALLING V1.6.1.21 ON 2012 SERVER