ETM Patch for new fusion look and feel

ETM 2.2.0 has released a patch that allows the UI to be presented with a new fuision look and feel. Check on my oracle support patch #10170659.

ETM 2.2.0 SP3 has been released

You will find it on my oracle support #10308595. Note that it requires FW 2.2.0 SP9 as well as two post SP9 patches #10183805 (with pre-req #10165157).

MWM 2.0.1.2 (i.e. SP2) released

MWM 2.0.1.2 has been released. You can get the patch which can be installed as an upgrade or a new install, from my oracle support. The patch number is 10241994. A Rollup of FW 4.0.2 patches has also been released namely 10257341.

Language Packs for OUFW 4

If you install a Language pack (i.e. UI) in FW 4 you now run batch Job F1-LANG written in java. In FW 2.2.0 (actually CCB 2.3.1, ETM 2.2.0, RMB 2.2.2, OUBI 2.2.1) the batch job was NEWLANG using Cobol.

CCB 2.3.0 SP3 has been released

You will find it on my oracle support #10167887. Note that it requires FW 2.2.0 SP9 as two patches #7715778 and #7620966, included in FW 2.2.0 SP9, introduce a password encryption feature. Additional information about steps to follow after installing FW 2.2.0 SP9 are described.

FW 2.2.0 SP9 has been released

You will find it on my oracle support #10183622. Per the pre-installation notes you have to review the patch #908033 with respect to the Hibernate upgrade. Also patch #10124173 (not included in the service pack) needs to be downloaded and installed separately prior to the service pack.

OUBI 2.3.0 released

Oracle Business Intelligence for Utilities version 2.3.0 had been released. It conisisted of two products that use the Oracle Business Intelligence Enterprise Edition (OBIEE) platform as the the front end.

It consists of :
* Oracle Utilities Advanced Spatial Outage Analytics (ASOA) which offers prepackaged analytics based on a mash up of extracted data with geospatial data, and
* Oracle Utilities Outage Analytics (OA) offers prepackaged operational and strategic analytics in the form of charts, graphs and tables.

This admin portion of the product is based on the OUFW 4.0.2 release.

MDM 2.0.0.1 (i.e. SP1 for 2.0.0) released on OUAF 4.0.2 with FW patches

MDM 2.0.0.1 has been released. The Software is available on http://edelivery.oracle.com/. The Demo database has a training database on internal build #21. There is a way to track the demo database that is released by looking at the installed products page in the application ... you will see the versions.

MWM 2.0.1.1 (i.e. SP1) released

MWM 2.0.1.1 has been released. You can get the patch which can be installed as an upgrade or a new install, from my oracle support. The patch number is 10111254. Also a demo database has been released for this upgrade. A Rollup FW 4.0.2 patch has also been released namely 100136196.

ETM 2.2.0 Consolidated Roll Up : August 2010

The latest Single Fix Consolidate Rollup has been released. This group of single fixes contains ETM 2.2.0 and FW 2.2.0 Single fixes since the release of ETM 2.2.0 SP2 up till the end of August 2010. it assumes ther minimum starting point as ETM 2.2.0 SP2 with FW 2.2.0 SP8

CCB - MDM/NMS Integation Configuration Examples

New integation with CCB, has been released. Namely CCB 2.31 and MDM 1.6.1 as well as CCB and NMS 1.10, example configuration has been released. Check out patch #9974118

FW SDK 2.2.0.11 is released

Oracle Utilities Framework SDK 2.2.0.11 has been released. Check patch #9537502 on my oracle support. This verson of of the SDK has 5 fixes as well as support for CCB 2.3.1

XAI Client V2.2.0.6 (Schema Editor) released

An updated Schema Editor has been released. Check out patch #9880835. This is for FW 2.2.0.

FW SDK 4.0.0.4 released

Oracle Utilities Framework SDK 4.0.0.4 has been released. Check patch # 10043375 on my oracle support

CCB 2.3.1 released

Oracle Customer Care and Billing 2.3.1 has been released. This version still runs on Oracle Utilities Framework 2.2.0 . (It has been released on FW 2.2.0 SP8) check http://edelivery.oracle.com

MDM 2.0.0 released on OUAF 4.0.2

MDM 2.0.0 has been released. This latest Meter Data Management version works on OUAF 4.0.2. This framework provides the new fusion look and feel to the Oracle Utilities product line. The software is all available on http://edelivery.oracle.com/ . The demo database has a training database with internal build #15. This is a way one can track the demo data that is released.

CCB with new Oracle Fusion Style look-and-feel

A new single fix has been release for CCB 2.3.0 to make it have the new Oracle fusion style look-and-feel. In order to install it , I found the best it to upgrade to CCB 2.3.0 SP2 FW SP8. (see previous posting on the patch numbers)


Next, download the actual patch FW 2.2.0 #9584975. You will need to install also patch CCB 2.3.0 #9938700 and FW 2.2.0 #9576557. You will need to run ConfigureEnv -e and then InitialSetup for the web.xml and ENVIRON.INI file to be configures with the style.


Next check that the ccb.properites.include file has ... spl.runtime.fusionlook=true

Oracle Utilities Network Management v1.10 released

Oracle Utilities Network Management System (OMS / OUNMS) version 1.10 has been released. It can be downloaded from edelivery.oracle.com

MWM 2.0.1 released on OUAF 4.0.2

MWM 2.0.1 has been released. This latest Mobile Workforce Management version works on OUAF 4.0.2. This framework provides the new fusion look and feel. You can get the software with the Framework from oracle support SR #9953161

Oracle Utilities Work and Asset Management v1.9 released

The latest version of Oracle Utilities Work and Asset Management has been released. You can get it on http://edelivery.oracle.com.

FW 2.2.0 SP8 and CCB 2.3.0 SP2 released

FW 2.2.0 SP8 and CCB 2.3.0 SP2 has been released. You will find it on my oracle support #9855486 and #9855492. For CCB 2.3.0 SP2 you will need FW 2.2.0 SP8 installed. Also note from FW 2.2.0 SP8 patch #9080333 will require some pre FW 2.2.0 SP8 install setup with respect to Hibernate.

ETM 2.2.0 Consolidated Roll Up : June 2010

The latest Single Fix Consolidated Rollup has been released. This Group of single fixes contains a few FW patches (5 in total) and all ETM 2.2.0 Single fixes since the release of ETM 2.2.0. SP2 up till the end of June 2010.

MWM 2.0.0.1 (i.e. SP1) released

MWM 2.0.0.1 has been released. You can get the patch which can be installed as an upgrade or a new install, from my oracle support. The patch number is 9767548. Also a demo database has been released for this upgrade. The patch number is 9767532.

ORMB 2.2.2 has been released

ORMB 2.2.2 has been released via edelivery.oracle.com.

Documaker 11.4 with CCB 2.3.0 SP1 - interface

Oracle Documaker is now an option as a bill print / letter print option for CCB 2.3.0.

This fuctionality was released as part of CCB 2.3.0 SP1 (9469248). The contents for the CCB portion of this is in Patch #9340118. It has two pre req single fixes namely 9298031 (part of CCB 2.3.0 SP1) and FW patch 9400320 which is included in the FW monthly rollup - Febuary 2010 (9478112)

Please check out the Documentation provided with the patch 9340118, to see how to set the alogorithms in place.

New Feature in oracle 11gR2 got me

If like me you are playing with 11gR2 for CCB / OUBI / ETM / RMB and you happened to export a table that had 0 records you may have this issue. It is a quick fix to get this resolved.

Check out the blog :

http://www.nativeread.com/2010/04/09/11gr2-empty-tables-skipped-by-export-deferred-segment-creation/

ETM 2.2.0 SP2 released

ETM 2.2.0 SP2 has been released. You will find it on my oracle support #9654012. Note this is also linked to a special framework patch #9654021 called FW 2.2.0 SP7 for ETM 2.2.0 SP2.

Oracle Utilities Application Framework 4.0.1 released (OUAF 4.0.1)

As part of the MWM v2.0.0 release FW v4.0.1 was also released. Lots of exciting features ... Check Anthony Shorten's blog for more full details coming soon ...

MWM 2.0.0 released

MWM 2.0.0 has just been released. It is available for download from edelivery.

Another product on the Oracle Utility framework !

FW 2.2.0 Febuary 2010 Rollup - First Rollup for FW 2.2.0

This rollup contains single fixes released after FW 2.2.0 SP7.

Before installing this roll-up you must first install:

* Framework V2.2.0 Service Pack 1 (7284592)
* Framework V2.2.0 Service Pack 7 (9390199)

(This rollup is required for CCB 2.3.0 SP1 ... see previous blog entry)

CCB 2.3.0 SP1 released

it contains all CCB patches released up until 2010-02-26:



Before installing this Service Pack the following prerequisite packages must be installed:



* Framework V2.2.0 Release

* Framework V2.2.0 Service Pack 1 Prerequisite Single Fixes (7195518, 7012092)

* Framework V2.2.0 Service Pack 1 (7284592)

* Framework V2.2.0 Service Pack 7 (9390199)

* Framework V2.2.0 Single Fix Monthly Rollup - Febuary 2010 (9478112)

* CCB V2.3.0 Release

ORMB 2.2.1 SP1 is released ... some extra install notes

ORMB2.2.1 SP1 has been release via patch #9362920 for Windows (AIX is patch #9362934 an Linux is patch #9363944)

Before I installed this patch, The Base Product is at the following levels : ORMB 2.2.1 with FW 2.2.0 SP3.

Before doing the upgrade, good standard practices should be to backup the application server folder as well as performing a full backup of the database.

In order to upgrade to ORMB V2.2.1.1 (SP1) the following needs to be applied to the Base ORMB Application:
1) FW Pre requisites FW SP6 patch #9322470 (This is a SQL only patch, known as the “V1SP1 patch”)
2) FW SP6 patch #9042811
3) Additional post SP6 FW single fixed patches: patch #9073699 and patch #9114541 in this order.
(For patch #9114541 you will need to install the patch mentioned in my previous blog on installing OUBI 2.2.1 SP1
here are the details:
i) Install FW SF patch #8845615 , as part of this patch a co-req 9032599 has a SQL portion.
ii) Install FW SF patch #9014351
iii) Install FW SF patch #9069631
iv) and finally FW SF patch #8793321.)
4) 3rd Party Upgrade of Hibernate 3.2.5 to 3.2.7 (See Appendix B in the Upgrade Guide)
5) and Finally : ORMB 2.2.1 SP1 patch (patch AIX #9362934,Window #9362920,Linux #9362944)

In Order to Upgrade the Database for ORMB to get to the ORMB V2.2.1.1 (SP1) level the following needs to be applied to the database:
(please note a sample Database dump has been provided at this latest release level for Oracle 11g)
1) FW Pre requisites FW SP6 patch #9322470 (This is a SQL only patch, known as the “V1SP1 patch”)
2) FW SP6 patch #9042811 (SQL portion)
3) Additional FW single fixed patch #9073699 and patch #9114541 in this order (no SQL in these patches other than co-req 9032599 SQL portion.)
4) ORMB 2.2.1 SP1 patch (SQL portion) (patch AIX #9362934,Window #9362920,Linux #9362944)

OUBI 2.2.1 SP1 is released ... some install notes

OUBI 2.2.1 SP1 has been release via patch #9257554.

Before I installed this patch, I had already installed FW 2.2.0 SP6 in the environment. So when putting in the OUBI 2.2.1 service pack, a few FW patches are required that are post FW 2.2.0 SP6.

Here is the list and order that I installed the list of FW Single Fixes :

1) Install FW SF patch #8845615 , as part of this patch a co-req 9032599 has a SQL portion.
2) Install FW SF patch #9014351
3) Install FW SF patch #9069631
4) and finally FW SF patch #8793321.

Then you will be able to install the OUBI 2.2.1 SP1. Please note there are SPLADM and DWADM schema changes in the SQL portion.

If you only have a demo database installed only i.e. no BIREPOWN schema , you may have an issue with th following grant statement in SQL patch 8422565 with sql script file 8422565_RS2.sql. The statement is :

GRANT SELECT ON BIREPOWN.WB_RT_AUDIT TO DWADM

ETM 2.2.0 CR for Single Fixes Up to January 2010 Patch # 9371547

A CR (Consolidated rollup patch #9371547)of ETM related single fixes has been released. To install this you need to have your ETM 2.2.0 environment at the following level : ETM 2.2.0 SP1 (Patch #9002875) with FW 2.2.0 SP6 (Patch #9042811) .

To install the latest and greated Demo Database with the latest ETM 2.2.0 Environment level, I installed the demo dump called Build 11 (Patch # 9219548)
and then in the database ran the FW 2.2.0 SP6 Database portion and the database portion for the CR patch #9371547. The Demo dump was released at ETM 2.2.0 SP1 FW 2.2.0 SP5.

The demo database includes includes additional date entries in the accounting calendar and filing calendars up to the end of 2011.

XAI Client V2.2.0.5 (Schema Editor) released

An updated Schema Editor has been released. This version fixes the following minor bugs:

Update Copyright Info in XAI Client,
XAI Client (Schema Editor) creates duplicate nodes and
XAI Client (Schema Editor) throws an error when trying to create service FreezeonAdjustment (C1ADJFZP)

The XAI Client schema editor is a very robust bit of software and very seldom do I see any errors with it. The last version was 2.2.0.3

FW SDK 2.2.0.10 is released

FW SDK 2.2.0.10 has 4 fixes in this release, related to a way to distribute the
eclipse plugins , context sensitive help, eclipse configuration for 2.3.0 ccb project and sl stylesheets to be included in cm.jar

New Code table in CCB 2.3.0 that has a language table

I spoted a new code table that has an associated language table. This info is in the release documentation, but just wanted to highlight it as when one is looking at installing or updating the different languages from an older version of CCB one needs to add this language descriptions.

The Table is C1_ISS_CTR_L i.e. Issue Centre Language table. An issuing center should be configured for each location that issues bills.

BI Publisher for CCB 2.x

If you have an issue that the OC4J server will
not start-up or shut down for BI Publisher

The following command will help shut it down to allow the rmi port to be opened again

execute

{ORACLE_BI_PUBLISHER_HOME}\oc4j_bi\bin\oc4j.cmd –shutdown –port 23791 –password oc4jadmin

To get the rmi port check out rmi.xml