MDM 2.3.0.0.0 forth cumulative rollup released

The forth cumulative rollup has been released for MDM 2.3.0.0.0 (April 2019)

Patch #29713847 on My Oracle Support.

MDM 2.3.0.0.0 third cumulative rollup released

The third cumulative rollup has been released for MDM 2.3.0.0.0 (March 2019)

Patch #29581478 on My Oracle Support.

WAM / ODM 2.2.0.4.0 released

The latest service pack for WAM and ODM has been released (2.2.0 SP4). This is still on the same FW (4.4.0.0.0) as the previous versions of the products as well as the latest C2M product version (2.7.0.1.0).

it can be downloaded via my oracle support patch #29586838

New CCB 2.7.0.1.0 March 2019 Rollup released

The patch #29690000 on my oracle support contains March patches for CCB 2.7.0.1.0 including FW 4.4.0.0.0.

Latest released versions of OUAF products @ 2019-04-24

The products are :

 C2M  2.7.0.1.0 (including  FW, CCB , MDM , MSM SGG and SOM) (and ODM/WAM)
 CCB 2.7.0.1.0
 MDM 2.3.0.0.0 (including  SGG and SOM)
 MSM 2.3.0.0.0 (including  SGG and SOM)
 WAM 2.2.0.3.0
 ODM 2.2.0.3.0

all on FW 4.4.0.0.0


###################

 C2M  2.7.0.3.0 (including  FW, CCB , MDM , MSM SGG and SOM) (and ODM/WAM)
 CCB 2.7.0.3.0
 MDM 2.3.0.2.0 (including  SGG and SOM)
 MSM 2.3.0.2.0 (including  SGG and SOM)
 WAM 2.2.0.6.0
 ODM 2.2.0.6.0

all on FW 4.4.0.2.0


 

New C2M 2.7.0.1.0 March 2019 Rollup released

The patch #29424347 on my oracle support contains March patches for C2M 2.7.0.1.0 including FW 4.4.0.0.0, CCB 2.7.0.1.0, MDM 2.3.0.0.0 and ODM / WAM 2.2.0.3.0

March Madness for MDM

The Oracle MDM team have been busy during March creating cumulative rollups for the latest MDM releases (released April 8th 2019)

MDM 2.2.0.1.0 29581483 MDM 2.2 SP1 MARCH '19 CUMULATIVE ROLLUP
MDM 2.2.0.2.0 29581481 MDM 2.2 SP2 MARCH '19 CUMULATIVE ROLLUP
MDM 2.2.0.3.0 29581480 MDM 2.2 SP3 MARCH '19 CUMULATIVE ROLLUP
MDM 2.3.0.0.0 29581478 MDM 2.3        MARCH '19 CUMULATIVE ROLLUP

MDM 2.2.0.1.0 Cumulative Patches set catchup

It has been a while since I tracked the latest  cumulative patches for MDM 2.2.0.1.0 Since the last JUNE 2018
here is the list

13 AUG 2018 Rollup (released Sept 17 2018) 28627926
14 SEP 2018 Rollup (released Oct 17 2018) 28805171
15 OCT 2018 Rollup (released Nov 13 2018) 28896874
16 JAN 2019 Rollup (released Feb 06 2018) 29293939
17 FEB 2019 Rollup (released Mar 01 2019) 29425437



These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0.

################

latest rollup is now  SEP 2019   (release Oct 10 2019)  30368727

 

MDM 2.3.0.0.0 second cumulative rollup released

The second cumulative rollup has been released for MDM 2.3.0.0.0 (February 2019)

Patch #29425429 on My Oracle Support.

MDM 2.3.0.0.0 first cumulative rollup released

The first cumulative rollup has been released for MDM 2.3.0.0.0 (January 2019)

Patch #29293947 on My Oracle Support.

C2M 2.7.0.1.0 (SP1) released.

Oracle just released C2M 2.7.0.1.0  (SP1).  This is on the new FW 4.4.0.0.0.  This is on the same FW as CCB 2.7.0.1.0 , MDM 2.3.0.0.0 and WAM / ODM 2.2.0.3.
it can be downloaded from Oracle Cloud

CCB 2.7.0.1.0 (SP1) released.

Oracle just released CCB 2.7.0.1.0  (SP1).  This is on the new FW 4.4.0.0.0.  This is on the same FW as MDM 2.3.0.0.0 and WAM / ODM 2.2.0.3..


The CCB release is patch 29237366. or it can be downloaded from Oracle Cloud too.


C2M should be coming soon ... 

WAM / ODM 2.2.0.3.0 released

The new WAM / ODM 2.2.0.3.0 got released on FW 4.4.0.0.0. it is on Oracle Software Delivery Cloud.

MDM 2.3.0.0.0 released

The new MDM 2.3.0.0.0 got released on FW 4.4.0.0.0. it is on my oracle support as patch #29131910 or via Oracle Software Delivery Cloud.

note this also included the MSM product. 

First Time in a long time

Just a quick observation, this is the first time in a long time that all the latest released versions of Oracle Utilities Framework Products (OUAF) are all on the same latest released FW currently 4.3.0.6.0

the products are :

C2M  2.7.0.0.0 (including  SGG and SOM) (and ODM)
CCB 2.7.0.0.0
MDM 2.2.0.3.0 (including  SGG and SOM)
MSM 2.2.0.3.0 (including  SGG and SOM)
WAM 2.2.0.2.0
ODM 2.2.0.2.0

Excellent Stuff

C2M 2.7.0.0.0 released

The new C2M 2.7.0.0.0 got released on FW 4.3.0.6.0. it is on Oracle Cloud Download.

CCB 2.7.0.0.0 released

The new CCB  2.7.0.0.0 got released on FW 4.3.0.6.0.
 

Oracle MSM V2 released on MDM 2.2.0.3.0 and FW 4.3.0.6.0

Oracle released the new MSM  ( Market Settlement Management V2, LPS on the OUAF framework) on the all new MDM 2.2.0.3.0 base.

This also includes new SGG version on V2.2.0.3.0 MDF and with FW 4.3.0.6.0.

Note from the flags in the internal database as well as the install process, Only one install process is required after the FW layer for MDM, MSM, SMDF.

Oracle released MDM 2.1.0 SP3 Cumulative June 2018

Oracle released MDM 2.1.0 SP3 Cumulative June 2018 Hot Fix Rollup on my oracle support recently.

Check out patch #28281276


The last cumulative patch was October 2017. It seems many customers are still on MDM 2.1.0.3.0 , dispite premier supporting ending January 2018.

FW patches
   

362    (19 since the last RU) 
   

 MDF patches
   

287   (35 since the last RU)   
   

 MDM patches
   

207   (25 since the last RU)  

Oracle CPU patches for OUAF products

the recent  CPU for July 2018 has patches should be deployed  into your  OUAF products deployment.

the key supporting software for OUAF products are :

Java  (latest 1.8 build ) see previous posting on getting the latest build for  1.8 / 1.7 and 1.6

WebLogic Opatch update is required for WLS 12.2.x and 12.1.3 version

Oracle Database also has regular commutative patches as well as in the Oracle Client.


It is always a good idea to install these during your implementation … no matter what phase of the project.

Critical Patch Update (CPU) Program July 2018 Patch Availability Document (PAD) (Doc ID 2394520.1)

http://www.oracle.com/technetwork/security-advisory/cpujul2018-4258247.html?elq_mid=117866&sh=2615152613202621212213103120261822&cmid=SPPT160711P00036C0002

Also refer to updated   FW certification knowledge doc  1454143.1

Note at RCC we are now offering this security service as part of our offerings

https://redclay.com/services/security-solutions/ 

 

12th MDM 2.2.0.1.0 Cumulative Patches set

The latest cumulative patch is now the JUNE 2018 rollup patch #28281273 that got release July 4th 2018. @2018-07-05
These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0.

 

GDPR - General Data Protection Regulation SFG for CCB 2.6.0.1.0 or C2M 2.6.0.1.0

A special single fix group got released for CCB 2.6.0.1.0. or C2M 2.6.0.1.0

This is geared for the European market, I believe , but still very much applicable for the US and elsewhere.

Note is it called the GDPR SFG  for General Data Protection Regulation Single Fix Group.
The patch number is #28043851

These patches can be installed into CCB 2.6.0.1.0 or into C2M 2.6.0.1.0.

Note at Red Clay Consulting (RCC) we now are working with our clients to highlight our security solutions

https://redclay.com/news/red-clay-welcomes-michael-pearson-as-chief-information-security-officer/
 

First C2M 2.6.0.0.0 Cumulative patch got released a while back.

The first cumulative patch for CCB 2.6.0.0.0 got released a while back been.
Note is it called the October 2017 Rollup. The patch number is  #26898406

These patches can be installed in into C2M 2.6.0.0.0.

1st MDM 2.2.0.2.0 Cumulative Patches set

The first cumulative patch is now the MAY 2018 rollup patch #28111942 that got release June 7th 2018. @2018-06-10

 These patches can be installed in both standalone MDM 2.2.0.2.0 or into C2M 2.6.0.1.0.

11th MDM 2.2.0.1.0 Cumulative Patches set

The latest cumulative patch is now the MAY 2018 rollup patch #28111926 that got release June 4th 2018. @2018-06-10
 These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0.


Note, I missed a few posting :
 
 8th MDM 2.2.0.1.0 Cumulative Patches set was FEB 2018 rollup patch #27696273 released March 15 2018.
 9th MDM 2.2.0.1.0 Cumulative Patches set was MAR 2018 rollup patch #27881346 released April 23 2018.
10th MDM 2.2.0.1.0 Cumulative Patches set was APR 2018 rollup patch #28004556 released May   11 2018.

7th MDM 2.2.0.1.0 Cumulative Patches set

The latest cumulative patch is  now the JAN 2018 rollup patch #27505052 that got release February 7th 2018. @2018-02-09
 These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0.

C2M 2.6.0.1.0 (SP1) released

Oracle just released C2M 2.6.0.1.0  (SP1).  This is on the new FW 4.3.0.5.0.  This is on the same FW as MDM 2.2.0.2.0  and CCB 2.6.0.1.0.  

The C2M release is patch 27426351.

CCB 2.6.0.1.0 (SP1) released

Oracle just released CCB 2.6.0.1.0  (SP1).  This is on the new FW 4.3.0.5.0.  This is on the same FW as MDM 2.2.0.2.0 . The Associated C2M is been released  as they all tie together on the same FW.

The CCB release is patch # 27426326.

 

 

MDM 2.2.0.2.0 (SP2) released

Oracle just released MDM 2.2.0.2.0  (SP2).  This is on the new FW 4.3.0.5.0.  The Associated CCB and C2M are been release at the same time, as they all tie together on the same FW.

The MDM release is patch # 27454806

6th MDM 2.2.0.1.0 Cumulative Patches set

The latest cumulative patch is  now the DEC 2017 rollup patch #27362023, that got release January 9th 2017. @2018-01-09
 These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0

First CCB 2.6.0.0.0 Cumulative patch got released. Appliable for C2M too.

The first cumulative patch for CCB 2.6.0.0.0 has been released. Note is it called the September 2017 Rollup. The patch number is  #27292542

These patches can be installed in both standalone CCB 2.6.0.0.0 or into C2M 2.6.0.0.0.

Fifth MDM 2.2.0.1.0 Cumulative Patches set

The latest cumulative patch is  now the NOV 2017 rollup patch #27259065, that got release December 14th 2017. @2017-12-14
These patches can be installed in both standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0

CCB 2.5.0 SP2 - latest cumulative rolllup package got released OCT 2017

CCB 2.5.0 SP2 latest cumulative rollup package got released included FW 4.3.0.2 single fixes. The last rollup package was May 2017, so a significant set of patches.

The patch # is 26935430

MDM 2.1.0 SP3 Cumulative October 2017 Hot Fix Rollup - 2 years since my last MDM 2.1.0 SP3 posting

Oracle released MDM 2.1.0 SP3 Cumulative October 2017 Hot Fix Rollup on my oracle support recently.
Check out patch #2710192.

I suspect this is probably one of the last Cumulative patch releases for MDM 2.1.0 SP3.

FW patches

343

MDF patches

252

MDM patches

182

Fourth MDM 2.2.0.1.0 Cummulative Patches set

The latest cumulative patch is  now the OCT 2017 rollup patch #27107894, that got release November 2017. @2017-11-13

These patches can be installed in both  standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0

C2M 2.6.0.0.0 release

C2M (Customer to Meter) , the combination of  CCB 2.6.0.0.0 and MDM 2.2.0.1.0 has been out for a while now.  Interesting how the combination of the two solutions will play out in the Utility market, with respect to customers wanting to upgrade either CCB or MDM, as well as customers that are new to Oracle Utilities ...

As part of C2M an additional layer get's installed namely X1 which "glues" the CCB and MDM together.

 

MDM 2.2.0.1.0 released as well as Third Cummulative Patches set

MDM 2.2.0.1.0 has been released for a while now, and is now part of the C2M Customer to Meter Solution.  MDM 2.2.0.1.0 runs on the same framework as  CCB 2.6.0.0.0, namely FW 4.3.0.0.0.

The latest cumulative patch is  the SEPT 2017 rollup patch #26945312, that got release October 2017. @2017-11-12

Not after installing this patch, we have already seen a few additional single fixes that are required. An example is patch  26870821 - MDF - MDM UNABLE TO LOAD READS FOR STANDALONE MEASURING COMPONENTS.


These patches can be installed in both  standalone MDM 2.2.0.1.0 or into C2M 2.6.0.0.0

CCB 2.6.0.0.0 released in Oracle Support

It looks like CCB 2.6.0.0.0 got released on Oracle Support. This version also C2M as well as MDM 2.2.0.1.0 as part of this release. 

CCB 2.5.0 SP2 - released

The Latest CCB  service pack just got released   namely SP2

From Oracle Support the SR # is 23629545

the latest version of FW for CCB is now  4.3.0.2.0



 

MDM 2.1.0 SP3 Cumulative October 2015 Hot Fix Rollup

Oracle released MDM 2.1.0 SP3 Cumulative October 2015 Hot Fix Rollup on my oracle support recently.
Check out patch #22171435.

Java Support for 1.7 .1.6 and 1.5 to get the latest fixed Java

Patch numbers on my oracle support are :  for Java 1.7 #13079846
                                                                    for Java 1.6 #9553040
                                                                    for Java 1.5 #9477224


For Java 1.8 the patch is  #18143322


latest numbers are  1.8.0_152  , 1.7.0_161 and 1,6.0_171

CCB 2.5.0 SP1 works fine on Windows 10 Pro

Not sure if it has been done before but got CCB 2.5.0 SP1 to work on Windows 10 Pro.  The new browser Edge definitely does not work. Firefox and the old Internet Explorer still works fine.

CCB 2.5.0 SP1 has been released

CCB 2.5.0 SP1 (CCB 2.5.0.1.0) has been released as a patch on my oracle support.  Check out patch #21880363.


it includes FW 4.3.0.1.0  (i.e. FW 4.3  SP1)

CCB 2.5.0 works fine on Windows 10 Pro

Not sure if it has been done before but got CCB 2.5.0 to work on Windows 10 Pro.  The new browser Edge definitely does not work. Firefox and the old Internet Explorer still works fine.

CCB 2.4.0 SP3 got released

CCB 2.4.0  SP3 is now available on  my Oracle Support


Patch # 21277617


Note that  Service Pack for FW is also released with this patch. FW 4.2.0.3.0


MicroFocus Wrap Pack 9 and 10 has been released for the runtime version. (MicroFocus Server)

CCB 2.5.0 just got released

Just checked and CCB 2.5.0 is now available on  Edelivery.

CCB 2.4.0 SP2 Cumulative March 2015 Hot Fix Rollup

Oracle released CCB 2.4.0 SP2 Cumulative March 2015 Hot Fix Rollup on my oracle support recently.
Check out patch #20783230. This is the 5th SP2 rollup.
Install has been done on Linux and Windows with no issues.
From the Fix count 170 CCB patches got installed (via check with perl SPErrorChecker.plx) and 208 FW patches also.
Per the readme 197 CCB patches got installed and 251 FW patches.
Additional co-req patches got installed.
The delta over the December 2014 rollup is 34 CCB patches and  64 FW patches.

CCB 2.4.0 SP1 Cumulative Feburary 2015 Hot Fix Rollup

Oracle released CCB 2.4.0 SP1 Cumulative February 2015 Hot Fix Rollup on my oracle support. 
Check out patch #20689676. The rollup patch contains both CCB and FW single fix patches both for application side as well as database.
This rollup includes patches from Cumulative August 2014 Hot Fix Rollup. Oracle skipped the months of September 2014 - January 2015 and did not create a rollup.

CCB 2.5.0.0.0 Release Prospectus

CCB 2.5.0 release prospectus is now on My Oracle support doc ID 19812407.1. New Framework 4.3.

CCB 2.4.0 SP2 Cumulative December 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP2 Cumulative December 2014 Hot Fix Rollup on my oracle support a while ago.
Check out patch #20219256. This is the 4th SP2 rollup.
Install has been done on Linux and Windows with no issues.
From the Fix count 136 CCB patches got installed (via check with perl SPErrorChecker.plx) and 152 FW patches also.
Per the readme   159 CCB patches got installed and 186 FW patches.
Additional co-req patches got installed.
The delta over the September 2014 rollup is   33 CCB patches and  62 FW patches.

CCB 2.4.0 SP1 Cumulative August 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP1 Cumulative August 2014 Hot Fix Rollup on my oracle support. 
Check out patch #19592975 The rollup patch contains both CCB and FW single fix patches both for application side as well as database.
This rollup includes patches from Cumulative May 2014 Hot Fix Rollup. Oracle skipped the months of June , July 2014 and did not create a rollup.

CCB 2.4.0 SP2 Cumulative September 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP2 Cumulative September 2014 Hot Fix Rollup on my oracle support.
Check out patch #19665659. This is the third SP2 rollup.
Install has been done on Linux and Windows with no issues.
From the Fix count 106 CCB patches got installed (via check with perl SPErrorChecker.plx)
and 109 FW patches also. Additional co-req patches got installed.

CCB 2.4.0 SP2 Cumulative July 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP2 Cumulative July 2014 Hot Fix Rollup on my oracle support. Check out patch #19414302. This is the second SP2 rollup. Install has been done on Linux and Windows with no issues. From the Fix count 70 CCB patches got installed (via check with perl SPErrorChecker.plx) and 81 FW patches also. Additional co-req patches got installed.

CCB 2.4.0 SP1 Cumulative May 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP1 Cumulative May 2014 Hot Fix Rollup on my oracle support.  Check out patch #18884522 The rollup patch contains both CCB and FW single fix patches both for application side as well as database.
This rollup includes patches from Cumulative March 2014 Hot Fix Rollup. Oracle skipped the month of April 2014 and did not create a rollup.

CCB 2.4.0 SP2 Cumulative June 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP2 Cumulative May 2014 Hot Fix Rollup on my oracle support. Check out patch #19125452. This is the first SP2 rollup. Some interesting fixes, including fixes to know issues released in the release notes for CCB 2.4.0 SP2 pdf document.
Install has been done on Linux and Windows with no issues.   From the Fix count 35 CCB patches got installed  (via check with perl SPErrorChecker.plx) and 58 FW patches also. Additional co-req patches got installed.

CCB 2.4.0 SP2 Release

Oracle has release CCB 2.4.0 SP2. Check out patch #18651692. The SP2 includes some new enhancements as well upgrade paths from :
CCB 2.2.0 SP 10 to 2.4.0 SP2 2,
CCB 2.3.1 SP 8 to 2.4.0 SP2 2,
as well as regular CCB 2.4.0 GA/SP1 to 2.4.0 SP2 2.

CCB 2.4.0 SP1 Cumulative March 2014 Hot Fix Rollup

Oracle released CCB 2.4.0 SP1 Cumulative March 2014 Hot Fix Rollup on my oracle support.  Check out patch #18488693 The rollup patch contains both CCB and FW single fix patches both for application side as well as database.  The rollup contains 76 FW patches and 85 CCB patches. ( of which including 13 FW patches  and  37 CCB patches that have database components)
This rollup includes patches from Cumulative January 2014 Hot Fix Rollup. Oracle skipped the short month of Feburary 2014 and did not create a rollup.

MWM 2.2.0 has been released

Mobile Workforce Management (MWM) 2.2.0 has been released on edelivery. Per the install notes it is on the new FW 4.2.0.1  (SP1).
Oracle Real Time Scheduler (RTS) 2.2.0 has also been release as part of the package

CCB 2.4.0 SP1 Cumulative January 2014 Hot Fix Rollup

Today, Oracle released CCB 2.4.0 SP1 Cumulative January 2014 Hot Fix Rollup on my oracle support.  Check out patch #18157205. The rollup patch contains both CCB and FW single fix patches both for application side as well as database.  The rollup contains 76 FW patches and 85 CCB patches. ( of which including 13 FW patches  and  37 CCB patches that have database components)

This rollup includes patches from Cumulative December 2013 Hot Fix Rollup, so new patches are :  24 FW patches and  18 CCB patches.


Also it seems that Oracle re-released the December 2013 Rollup patch for Windows 32 bit. Patch #17946870

CCB 2.4.0 SP1 Cumulative December 2013 Hot Fix Rollup

Yesterday, Oracle released CCB 2.4.0 SP1 Cumulative December 2013 Hot Fix Rollup on my oracle support.  Check out patch #17946870. The rollup patch contains both CCB and FW single fix patches both for application side as well as database.  The rollup contains 52 FW patches and 67 CCB patches. ( of which including 10 FW patches  and  28 CCB patches that have database components)

This rollup includes patches from Cumulative November 2013 Hot Fix Rollup, so new patches are :  25 FW patches and  29 CCB patches.
 

CCB 2.4.0 SP1 Cumulative November 2013 Hot Fix Rollup

Yesterday, Oracle released CCB 2.4.0 SP1 Cumulative November 2013 Hot Fix Rollup on my oracle support.  Check out patch #17672112. The rollup patch contains both CCB and FW single fix patches both for application side as well as database.  The rollup contains 27 FW patches and 38 CCB patches. ( of which including 7 FW patches  and  18 CCB patches that have database components)

 

JAVA updates from Oracle for CCB 2.3.1 / 2.4.0 for Java 1.6 and for older CCB java 1.5.0

So I found something interesting, even though Java 1.6.0.x and Java 1.5.0.x has reached it end of life cycle, (Oracle is pushing version 1.7.0.x latest is build 65) but as part of my oracle support, Oracle does release security updates for Java 1.6 and 1.5.

The current version of Java 1.6 is 1.6.0_81         (now 2017-11-11    1.6.0_171)
 (last available version via regular oracle web site was _45)

The current version of Java 1.5 is 1.5.0_71       
 (last available version via regular oracle web site was _22)

Patch numbers on my oracle support are : for Java 1.6 #9553040
                                                                    for Java 1.5 #9477224



now 2017-11-11 Oracle is pushing version 1.7.0.x latest is build 161

CCB 2.4.0 SP1 has been released

CCB 2.4.0 SP1 has been released on my oracle support. Check patch # 17460363 on my oracle support. Note the patch includes the FW 4.2.0 SP1 as well as additional patches needed for CCB 2.4.0 SP1. As before two database dumps are included the Classic demo as well as the new demo with the new rate engine.

OUCSS 2.1.0 has been released

OUCSS 2.1.0  (Oracle Utilities Customer Self Service ) 2.1.0 has been released. It is available on E-Delivery. edelivery.oracle.com.

it contains new functionality as well as upgraded underlying software.

FW SDK 4.2.0.2 has been released

FW SDK 4.2.0.2 has been released. Check patch #16494096 on my oracle support. Note that this SDK release can be used on top of SP1 release. It is also can be installed on Windows 64 bit.

FW SDK 4.2.0.1 has been released

FW SDK 4.2.0.1 has been released. Check patch #15991083 on my oracle support. Note that the SDK now can run as true 64 bit on Windows.

FW SDK 4.2.0.0.0 has been released

FW SDK 4.2.0.0.0 has been released. Check patch #14330682 on my oracle support.

CCB 2.4.0 release

CCB 2.4.0 has been released on edelivery. Per the install notes it is on the new FW 4.2.0.

It also has a new SDK on FW 4.2.0.

 

Personal Note

So after 15+ years at Oracle I have finally moved on. I am now working for Origin Consulting LLC.
http://www.originconsults.com/
I will continue to post to my  blog on a semi regular basis, with latest product news, tips and ideas.

ORMB 2.2.4 SP1 has been released

ORMB 2.2.4 SP1 (build 28282) has been released patch #13902754. Per the install notes you will need to install the RMB FW 2.2.0 . Included are the list of fixes with this SP1. Please also review the release notes.

it can also be found via :

For RMB V2.2.4.0 – Service pack 1 patch numbers are
14713108 - Linux x86-64
14712063 - IBM AIX on POWER Systems (64-bit)
14712062 - Microsoft Windows x64 (64-bit)


Included fixes in Oracle Revenue Management & Billing for Financial Services Production Release
----------------------------------------------------------------------------------------------------
13681854 PRICING SCREEN: SQL ERROR ON SEARCHING A PRODUCT WITH PRODDESC:% AND BUNDLE: YES
13681777 INVOICE GROUP-ABLE TO REMOVE MEMBER FROM MASTER,EVEN IF BILL IS GENERATED FOR IT
13543845 NO APPLICATION SERVICE DEFINED ON PRODUCT AND PRICELIST BPA SCRIPT
13692296 BILL SEGMENT CALC LINE SHOWS INCORRECT ORIGINAL PRICING AMOUNT AND EXCHANGE RATE
13471604 DATE VALIDATION INCORRECT FOR PRICE ASSIGNMENT IN BUNDLING
13423497 START DATE IN EFFECTIVE PRICING SCREEN IS INCORRECT
13518851 EXPORT TO EXCEL FUNCTIONALITY IS NOT EXPORTING THE PRICING PROPERLY
13456712 EXPORT TO EXCEL FUNCTIONALITY - INTRODUCED NEW COLUMNS
13541315 PRICELIST STATUS FLAG NOT UPDATED FOR SOME PRICELISTS
13518902 ASSIGNMENT LEVEL SEARCH ON EFFECTIVE PRICING UI NOT WORKING
13519045 TRANSACTION SOURCE TAB ON THE DIVISION SCREEN SHOULD BE HIDDEN
13644453 CHARGE TYPE FIELD ON BILLABLE CHARGE NEEDS FILTER BY CONTRACT TYPE AND DIVISION
13503946 REMOVE VALIDATIONS ON POLICY NUMBER TO ALLOW SPECIAL CHARACTERS
13537263 QUOTES GENERATION ALGORITHM TYPE NOT DEFINED IN DEMO DATA
13515193 ACTIVE OWNER INFORMATION SET AS FRAMEWORK IN DEMO DATA

FW SDK 2.2.0.15 has been released

FW SDK 2.2.0.15 has been released. Check patch #13642859 on my oracle support.

FW 2.2.0 SP14 has been released

You will find it on my oracle support #113638868.

ORMB 2.2.3 SP1 has been released

ORMB 2.2.3 SP1 (build 27064) has been released patch #13839785. Per the install notes you will need to install the TUGBU FW 2.2.0 and service pack 8 at a minimum. Included are the list of fixes with this SP, as well as support for IE8 for RMB 2.2.3.1. Please review the release notes.


For RMB V2.2.3.0 – Service Pack 1 patch numbers are
13839819 - Linux x86-64
13839760 - IBM AIX on POWER Systems (64-bit)
13839785 - Microsoft Windows x64 (64-bit)

ORMB in the news

http://www.propertycasualty360.com/2012/01/10/oracle-releases-new-versions-of-revenue-management

Oracle Announces Newest Release of Oracle Insurance Revenue Management and Billing

http://www.oracle.com/us/corporate/press/1453058

ORMB 2.2.4 has been released

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

Oracle Revenue Management and Billing with Exadata

Check out the whitepaper on my Oracle Support Doc-ID 1360941.1 . Also see the press release at http://www.oracle.com/us/corporate/press/494555

Oracle Revenue Management and Billing Partitioning (1335848.1)

Check out the whitepaper on my Oracle Support Doc-ID 1335848.1

CCB 2.3.1 SP3 has been released

CCB 2.3.1 SP3 has been released patch #12995884. Per the install notes you will need to install FW 2.2.0 SP13 (#12995882) This SP contains all single fixes released till end of September 2011.

FW 2.2.0 SP13 has been released

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

This is the same details as in FW 2.2.0 SP10, SP11, SP12. The service patch contains all single fixes up till end of Spetember 2011. One important patch is #12680266 which is config changes for FW 2.2.0 for Weblogic 10.3.3.

This SP as well as SP10, SP11 and SP12 has single fix #9584975 which is the patch that allows the fusion UI.

to configure it modify the file ccb.include.properties to have the following content for example :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
spl.runtime.service.extraInstallationServices=CILTINCP

spl.runtime.fusionlook=true
spl.runtime.showlogout=true
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This will set up the fusion UI as well as the logout button

CCB 2.3.1 SP2 has been released

CCB 2.3.1 SP2 has been released patch #12729127. Per the install notes you will need to install FW 2.2.0 SP12 (#12729083) This SP contains all single fixes released till end of July 2011.

Oracle Revenue Management and Billing v2.2.3 Performance Benchmark on Exadata X2-2

The recent Exadata X2-2 benchmark of Oracle Revenue Managment and Billing for Financial Services is now available on my oracle support.

(Doc ID 1360941.1)

FW 4.1.0 Group Fix Rollup 001 #12831936

This is the first Group Fix Rollup released for FW 4.1.0 that uses the new method of grouping single fixes using the method in single fix #12548444.

Patch 12548444 is the Group Fix 1 installation package.

Patch 12831936 is the actual Group Fix 1 Rollup.

FW 4.1.0 GF1 released Patch #12548444

This fix is the first patch that needs to be installed before one can install the FW Rollup method.

If you installing the GF Rollup 001 (patch# 12831936) you do not need to download this as it is included.

Patch 12548444 is the Group Fix 1 installation package.

ETM 2.3.0 SP1 has been released

This Service Pack is based on FW410 GF1.

FW Pre-reqs for this SP
• “GROUP FIX 001 ROLL UP RELEASE PACKAGE” (Patch# 12831936)
• Convenience FW rollup to include two post FW fixes (included in the download)

Please refer to the included README file for details on the process

FW 2.2.0 SP12 has been released

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

This is the same details as in FW 2.2.0 SP10, SP11. The service patch contains all single fixes up till end of July 2011. One important patch is #12680266 which is config changes for FW 2.2.0 for Weblogic 10.3.3.

FW 2.2.0 SP11 has been released

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

This is the same details as in FW 2.2.0 SP10. The service patch contains all single fixes up till end of May 2011.

MDM 2.0.1.1 has been released on my oracle support

This Service Pack (SP1) can be found on my oracle support SR#11826071.
The previous version was MDM 2.0.1.

Logout button on FW 2.2.0 Products (CCB and RMB)

A Single fix has been released on FW 2.2.0 post SP10 that provides a logout button both in a fusion and non fusion look and feel environment. If you already have FW 2.2.0 SP10 you will need to only download the patch # 11078069 (Feb 15 2011) from my oracle support and the pre-req patch #10050457 (Feb 3rd 2011). The patch also has a Database (SQL) portion.

After installing the pre-req and the patch, you will need to add the following to the spl.properties file for the on-line app i.e. root.

The line is :
spl.runtime.showlogout=true

I added this to file ccb.properties.include since I recently have to change this to add the fusion look and feel.
Please note that this logout button also works in a non-fusion environment too.
In FW 4.x products this logout button is already included.

if you on FW 2.2.0 SP8 you will need to install the following pre-reqs (quite a few)

11078069 (post SP10)
10050457 (post SP10)
10026174 (post SP8 in SP9)
9584975 (post SP8 in SP9)
6993937 (in SP8)
7172921 (in SP8)
8317239 (in SP8)
8392453 (in SP8)
8817081 (in SP8)
8872133 (in SP8)
9256359 (in SP8)
9447528 (in SP8)
9472479 (in SP8)
9484784 (in SP8)
9487113 (in SP8)
9552570 (in SP8)
9560849 (in SP8)
9618455 (in SP8)
9672027 (in SP8)
9678464 (in SP8)
9685506 (in SP8)
9744880 (in SP8)
10262588 (post SP9 in SP10)
10215923 (post SP9 in SP10)
10420376 (post SP9 in SP10)
9965197 (post SP9 in SP10)
10235499 (post SP9 in SP10)
10262588
10419014
11677905 (post SP9 in SP10)
10209023 (post SP9 in SP10)
10125234 (post SP9 in SP10)
10198794 (post SP9 in SP10)
10175549 (post SP9 in SP10)
7836603 (in SP8)
9802214 (post SP8 ...)
9879319 (post SP8 ... )
9883222 (post SP8 ... )
9576557 (post SP8 in SP9)
9100807 (in SP8)
9619881 (in SP8)

ETM 2.3.1 has been released on FW 4.1.0

it is now available on Oracle eDelivery.

Oracle Process Integration Pack for Oracle Utilities Field Work 3.1

Oracle Process Integration Pack for Oracle Utilities Field Work 3.1 has been released. This PIP is built on the new AIA Foundation Pack 3.1.

Oracle Enterprise Taxation Management Integration to Peoplesoft Enterprise Financials version 1.2.0 Media Pack

Oracle Enterprise Taxation Management Integration to Peoplesoft Enterprise Financials version 1.2.0 Media Pack has been released.

Oracle Utilities Customer Care and Billing Integration to Oracle E-Business Suite Release 3.1.0 Media Pack

Oracle Utilities Customer Care and Billing Integration to Oracle E-Business Suite Release 3.1.0 Media Packhas been released.

Oracle Utilities Customer Care and Billing Integration to Peoplesoft Enterprise Financials Release 3.1.0 Media Pack

Oracle Utilities Customer Care and Billing Integration to Peoplesoft Enterprise Financials Release 3.1.0 Media Pack has been released.

Oracle Utilities Advanced Spatial and Operational Analytics Release v2.3 has been released.

Oracle Utilities Advanced Spatial and Operational Analytics Release v2.3.1 had been released. It conisists of the following products that use the Oracle Business Intelligence Enterprise Edition (OBIEE) platform as the the front end :

* Analytics based on Oracle Utilities Customer Care and Billing:
Oracle Utilities Customer AnalyticsOracle Utilities Revenue Analytics
Oracle Utility Credit and Collection Analytics
Oracle Utilities Advanced Spatial Revenue Analytics
Oracle Utilities Advanced Spatial Credit and Collection Analytics

* Analytics based on Oracle Utilities Work and Asset Management:
Oracle Utilities Work and Asset Analytics

* Analytics based on Oracle Utilities Distribution Management:
Oracle Utilities Distribution Analytics

This admin portion of the product is based on the OUFW 4.0.2 release.
This release is a mandatory upgrade from the v2.3.0 release of this product.

Personal Note : FSGBU / ORMB

I have moved groups in Oracle. I am now with the Oracle Financial Service Global Business Unit (FSGBU), moving from the Tax and Utililites Global Business Unit (TUGBU). I will indirectly still be working with the FW and TUGBU products as I support and work with Oracle Revenue Management and Billing (ORMB) for Both Insurance , Banking and Healthcare.

CCB 2.3.1 SP1 has been released

CCB 2.3.1 SP1 has been released. this is the first SP for CCB 2.3.1 (#11675360). Per the install notes you will need to install FW 2.2.0 SP10 (#11675245) This SP contains all single fixes released till end of January 2011.

FW 2.2.0 SP10 has been released

You will find it on my oracle support #11675245. 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.

This is the same details as in FW 2.2.0 SP9. The service patch contains all single fixes up till end of January 2011.

SGG 2.0.0 released today also on FW 4.1

SGG - Smart Grid Gateway 2.0.0 has been released . It is a TUGBU product based on the MDF frameworkand FW 4.1 , that is used to integrate the Smart Grid network.

MDM 2.0.1 released on FW 4.1.0

MDM 2.0.1 has been released on edelivery.oracle.com with FW 4.1. Note that with this new FW 4.1 some additional FW 4.1.0 patches are released. This is also the first TUGBU product to be released on FW 4.1.0. The previous version on MDM was MDM 2.0.0 (SP1) was on FW 4.0.2.

Additional FW 4.1.0 patches are also available on MOS (my oracle Support)

ORMB 2.2.3 released

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

MWM 2.0.1.3 (i.e. SP3) released

MWM 2.0.1.3 has been released. You can get the patch which can be installed as an upgtrade or a new install, from my oralce support. The patch number is 10359005. A Rollup of FW 4.0.2 patches has also been released for this namely 10358996.

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

Happy Festivus !

http://www.youtube.com/watch?v=c8g4Ztf7hIM

New OUBI Demo Database Dump Patch 8774102

A new demo Database Dump for OUBI got release as patch no. 8774102

OWB 11.1.0.7 Patch for 11g

OUBI is certified on 10g and 11g . For 11g it was certified with 11.1.0.6. Many customers have moved to Oracle DB 11.1.0.7, and for OWB to work with this the following patch is required

the Patch no is : 6890831

(Thanks Rath for the info ... had this from Norman but lost the link)

Blogs to follow

The following is a list of blogs that I follow on a regular basis and should be in your iphone RSS Reader or at least a favourite in your browser:

The Shorten Blog : http://blogs.oracle.com/theshortenspot/
The Technical and Framework Guru !

Stuart Ramage : http://stusbraindump.blogspot.com
The Conversion and Functional Guru !

Jeremy Oosthuizen (Jeremy 2000) http://blogs.oracle.com/oubi/
The Product Manager for Oracle Utilities Business Intelligence

Useful Conversion and Report Script to create users

For the Conversion Schema creation process, the steps are pretty much the same as before however in the doc they simply say :

Once you have created a staging owner (STGADM), application user (STGUSER) and read access user (STGREAD), install the initial database option in the staging schema.

So to sum-up steps are :
1) Create the STGADM / STGUSER and STGREAD users
2) Initial Database load from blueprint (remember need to do FW, SP1, SP6 and then CCB)
3) Run the new Conversion.bat which calls ConvSetup.exe

For the first step, create the users, there is no sample script provided with CCB. Here is a sample script. (Essentially it is a copy of the the sql called CreateCDXUsers.Sql)

CREATE USER STGADM IDENTIFIED BY STGADM DEFAULT TABLESPACE CISTS_01TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;

CREATE ROLE STG_READ;
CREATE ROLE STG_USER;

GRANT UNLIMITED TABLESPACE TO STGADM WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO STGADM;
GRANT CREATE DATABASE LINK TO STGADM;
GRANT CONNECT TO STGADM;
GRANT RESOURCE TO STGADM;
GRANT CREATE PUBLIC SYNONYM TO "STGADM";
GRANT CREATE TRIGGER TO "STGADM";
GRANT DROP ANY SYNONYM TO "STGADM";
GRANT CREATE ANY SYNONYM TO "STGADM";
GRANT SELECT ANY DICTIONARY TO STGADM;

Grant grant any role , grant any privilege , select any table , create any synonym , drop any synonym ,execute any procedure to STGADM with admin option;
GRANT SELECT ANY DICTIONARY TO STGADM;
GRANT DBA to STGADM;

CREATE USER STGUSER PROFILE DEFAULT IDENTIFIED BY STGUSER DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMPACCOUNT UNLOCK;

GRANT SELECT ANY TABLE TO STGUSER;
GRANT STG_USER TO STGUSER;
GRANT STG_READ TO STGUSER;
GRANT CONNECT TO STGUSER;

CREATE USER STGREAD IDENTIFIED BY STGREAD DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;

GRANT SELECT ANY TABLE TO STGREAD;
GRANT STG_READ TO STGREAD;
GRANT CONNECT TO STGREAD;

For Reporting (i.e. interface with BI Publisher or Crystal Business Objects) I have created a similar one as well:
(the last two statement may give errors if the objects are not present in the database)

Create user RPTUSER Identified by RPTUSER
default tablespace cists_01 temporary tablespace temp;

Grant connect to RPTUSER;
GRANT CIS_READ TO RPTUSER;
grant create procedure to rptuser;
grant execute on cisadm.cr_package to rptuser;
grant execute on cisadm.CISAINFO to rptuser;

CCB 2.3.0 Released

CCB 2.3.0 is now on edelivery.oracle.com
it works with FW 2.2.0 at patch level SP6. The Oracle Team has delivered a special FW build at that level : Oracle Utilities Framework V2.2.0.6 for CCB V2.3.0

CCB 2.2.0 SP6 and FW 2.2.0 SP6 released

It contains all patches released up until 2009-10-31 :

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 6 (9042811))

* CC&B V2.2.0 Release

* CC&B V2.2.0 Service Pack 1 (7284602)

Note: CCB Service Pack 6 (SP6) includes all fixes from SP2 to SP5 but excludes fixes delivered with SP1. It can be applied over any previous Service Pack. Any already installed individual fixes will not be reinstalled.
also Patches 7715778 and 7620966, included in FW 2.2.0 SP4 , SP5 (and SP6) introduce a password encryption feature.

You will need to follow these steps after installing either FW V2.2.0 SP6, and BEFORE starting the application (spl.sh/.cmd start).If you have already followed these steps after installing FW V2.2.0 SP4,SP5 or FW V2.2.0 SP6, you do not need to do it again.

1) execute: configureEnv.sh (.cmd)

2) select each menu option where there is a password, change the value to something else (required so the script can pick up the value requires to be changed) There are 3 passwords to update: WebLogic System Password Application Admin Userid Password Password of the User of the Database

3) P - process

4) execute: configureEnv.sh (.cmd)

5) change menu options (from step 2) back to your desired values

6) P - process

7) execute: initialSetup.sh (.cmd)

The order to install is (from scratch)
FW 2.2.0CCB 2.2.0

FW Pre SP1 patches (2 Single fixes get loaded ... I used the SPErrorChecker.plx on this and it shows the details correctly)

FW SP1 (45 SF installed)

CCB SP1 (69 SF installed)

FW SP6 (282 SF installed)

CCB SP6 (367 SF installed)

FW SDK 2.2.0.9 is released

SDK 2.2.0.9 has 4 fixes in this release, related to threading , Cobol Src generation, fix of owner flag and wizard error

Software Tools that I use daily and update regularly on my Desktop/Laptop

Here is my list of software that I use on a daily basis as part of my regular installs or monitoring:

(versions are the latest @ May 10th 2010)


* UltraVNC .... latest version is 1.0.8.2 check out http://www.uvnc.com/download/

* Pidgin (internal communication) latest version is 2.6.6 check out http://pidgin.im/

* Java 1.6 SDK and RJE (I use the latest and keep it updated) I use it with SQL Developer, Control Central / Mapper, Jdeveloper and with the Windows OS. check out http://www.java.com/en/download/manual.jsp. I use order version for some of the products but just have my scripts configured correctly.

* Tomcat - using 6.0.26 latest version. http://tomcat.apache.org/download-60.cgi

* Perl using 5.8.8 and looking at the newer version too. (5.10.0) (5.10.1) https://www.activestate.com/activeperl/downloads/

* Skype, MSN as well for communication with people all over. http://www.skype.com/download\ and http://download.live.com/messenger

* SQL Developer 2.1 http://www.oracle.com/technology/software/products/sql/index.html

* Adobe ...to read docs updated to 9.3.2 http://get.adobe.com/reader/

* Firefox , Thunderbird, Chrome Browser, Safari, OpenOffice - backup browsers, mail reader and office software.

* FileZilla 3.3.2.1 - ftp to download files http://filezilla-project.org/download.php

* CDBurnerXP for burning data cds - updated to latest version 4.3.2.2140 http://cdburnerxp.se/en/download

Windows Desktop Search Disable

If you like me you tend to put in al patches that Microsoft releases , then you got the new Microsoft Desktop Search Defaulted first rather than the simple file Search Windows Companion (with the little dog !)

to get it back to default the Windows Companion do the following :

regedit

go to HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS

then change ShowStartSearchBand to 0 (Zero)
if it does not exist create it as a DWORD value (it will show up as a REG_WORD type ) and set the value to 0 (Zero Hex)