There was an error in this gadget

Thursday, June 30, 2016

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



 

Saturday, November 14, 2015

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.

Tuesday, October 13, 2015

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

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.

Friday, October 2, 2015

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)

Thursday, September 17, 2015

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.

Monday, June 29, 2015

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)

Tuesday, April 28, 2015

CCB 2.5.0 just got released

Just checked and CCB 2.5.0 is now available on  Edelivery.



Tuesday, April 21, 2015

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.

Friday, March 20, 2015

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.

Tuesday, February 24, 2015

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.

Wednesday, February 18, 2015

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.

Thursday, October 2, 2014

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.

Sunday, August 17, 2014

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.

Thursday, July 17, 2014

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.

Wednesday, April 30, 2014

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.

Monday, March 10, 2014

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

Thursday, February 6, 2014

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

Monday, December 23, 2013

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.
 

Tuesday, November 12, 2013

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)

 

Friday, October 18, 2013

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
 (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
 

Sunday, October 6, 2013

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.

Monday, March 4, 2013

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.

Sunday, December 2, 2012

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.

 

Friday, July 20, 2012

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.

Sunday, April 8, 2012

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

Thursday, March 22, 2012

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)

Tuesday, February 14, 2012

ORMB in the news

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

Thursday, January 19, 2012

Wednesday, December 14, 2011

ORMB 2.2.4 has been released

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

Monday, November 14, 2011

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

Tuesday, October 4, 2011

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.

Thursday, September 22, 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)

Tuesday, September 20, 2011

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

Thursday, September 8, 2011

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.

Friday, June 10, 2011

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.

Wednesday, March 23, 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.

Friday, March 18, 2011

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)

Tuesday, February 22, 2011

ETM 2.3.1 has been released on FW 4.1.0

it is now available on Oracle eDelivery.

Wednesday, February 16, 2011

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.

Monday, February 14, 2011

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.

Wednesday, February 9, 2011

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.

Tuesday, February 1, 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.

Monday, January 31, 2011

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)

Saturday, January 29, 2011

ORMB 2.2.3 released

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

Thursday, January 6, 2011

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.

Friday, December 17, 2010

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.

Saturday, November 20, 2010

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).

Tuesday, November 16, 2010

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.

Friday, October 22, 2010

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.

Friday, October 15, 2010

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.

Monday, October 4, 2010

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.

Tuesday, September 28, 2010

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.

Thursday, September 23, 2010

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

Tuesday, September 7, 2010

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.

Sunday, August 29, 2010

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

Thursday, August 12, 2010

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.

Thursday, August 5, 2010

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

Friday, July 30, 2010

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.

Wednesday, July 28, 2010

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.

Monday, July 12, 2010

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.

Monday, June 28, 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.

Saturday, June 26, 2010

ORMB 2.2.2 has been released

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

Wednesday, May 26, 2010

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.

Monday, May 24, 2010

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/

Monday, May 3, 2010

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.

Friday, April 30, 2010

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 !

Saturday, April 17, 2010

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

Thursday, February 18, 2010

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)

Monday, February 15, 2010

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.

Wednesday, February 10, 2010

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

Tuesday, January 19, 2010

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

Thursday, December 24, 2009

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)

Thursday, December 17, 2009

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

Thursday, December 10, 2009

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;

Friday, December 4, 2009

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

Wednesday, December 2, 2009

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

Wednesday, November 25, 2009

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

Friday, October 16, 2009

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)

Tuesday, October 6, 2009

RMB 2.2.1 is released

Oracle Revenue Management and Billing version 2.2.1 is now available at http://edelivery.oracle.com/.This is built on the Oracle Utilties Framework v2.2.0 with SP3 .more info can be found at :http://www.oracle.com/industries/financial_services/oracle-revenue-management-billing.html and

http://www.oracle.com/industries/insurance/oracle-revenue-management-billing-insurance.html

Note that both are under the financial sector on Edelivery for download

Tuesday, September 1, 2009

jar command to unzip the jar files for CCB 2.2.0 SP5 and FW 2.2.0 SP5

I found that some times my windows box runs out of memory when doing the "unjar" of the files released as part of the SP.

per the release documentation they state the following

jar -xvf CCB-V220-SPx-win.jar
... I tend not to do the 'v' command as I really do not need to see the verbose info but ...

I do add the following

jar -xf -J-Xmx1024m CCB-V220-SPx-win.jar
.. this give it at the initial outset 1GB of memory ....

Note for CCB 2.2.0 SP5 on windows , it simply unzips into a folder called win .... previous SP creates a folder called CCB-V220-SPx-win (I have renamed it to CCB-V220-SP5-win to be consistant)

CCB 2.2.0 SP5 and FW 2.2.0 SP5 released

It contains all patches released up until 2009-08-10

For CCB 2.2.0 SP5 :

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 5 (8734749)
* CC&B V2.2.0 Release
* CC&B V2.2.0 Service Pack 1 (7284602)
Note: CCB Service Pack 5 (SP5) includes all fixes from SP2 to SP4 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 (and SP5) introduce a password encryption feature.

You will need to follow these steps after installing either FW V2.2.0 SP5, and BEFORE starting the application (spl.sh/.cmd start).If you have already followed these steps after installing FW V2.2.0 SP4 or FW V2.2.0 SP5, 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)

Friday, May 22, 2009

CCB 2.2.0 SP1 and FW 2.2.0 SP1 - becareful

If you are in the process of putting in a SP remember to ALWAYS backup the database and the appserver.

It is just good practise !

The CCB SP1 and FW SP1 database update does a blueprint fix ... so it clears everything out to make it at the SP1 level for C1 and F1 flags. (your customization will still be there)
.... so if by mistake (a stupid mistake ....) , you have an environment at CCB 2.2.0 SP3 FW SP3 and run the FW SP1 cdxdbi script it will wipe out all the internal metadata related to SP2 / SP3 etc ....
So the story is make a backup both of the Database and the AppServer.

Saturday, May 16, 2009

CCB / FW 2.2.0 SP4 is released

The Service Pack SP4 for OUFW and CCB is released.

The Service does NOT include some single fixes that are not part of the Main App for example other 3rd Party and the XAI Editor. The list that I have compiled is as follows :

3rd Party
8300439 CCB V2.2.0 DOC1 TEMPLATES V2.2.0.2

SDK
8363534 SDK 2.2.0.7 BUG FIX RELEASE8255816 SDK 2.2.0.6 BUG FIX RELEASE

Schema Editor
7594114 XAI Schema Editor Client V2.2.0.3

Language Packs
8483388 CCB V2.2.0 PORTUGUESE (PORTUGAL) LANGUAGE PACK - UI USER INTERFACE)
8399523 CCB V2.2.0 EUROPEAN SPANISH LANGUAGE PACK - UI (USER INTERFACE)
7498832 CCB V2.2.0 FRENCH LANGUAGE PACK8220958 CCB V2.2.0
LATIN AMERICAN SPANISH LANGUAGE PACKAGE

Help Packs
So far only 2.1 new language help has been released (but can be massaged a bit or 2.2)

As like SP3 if installing a new environment you still need to put in SP1.
SP4 contains all single fixes that are in SP2 and SP3 BUT does not contain patches in SP1.
(This is both for CCB and FW)

With respect to ETM FW SP3a .... SP4 includes all single fixes in SP3a
FW SP4 works with BI 2.2 too and with RMB 2.2.0

A new feature with the install is the SPErrorChecker.plx. it has been improved since it was released with SP3. It now does not give an error message if a fix was installed already.

So the following is some stats that can be useful for checking that all was installed correctly.

The order to install is

FW 2.2.0
CCB 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 SP4 (170 SF installed)
CCB SP4 (264 SF installed)

Tuesday, April 21, 2009

My old SPL cap or should I say my new Oracle cap




It seems my old SPL cap , is now a collectors item. The company logos on the cap are now all Oracle Business Units . Front: SPL acquired November 2006 - left side: Siebel eBusiness acquired September 2005 and right side: - now Sun Microsystem acquired April 2009







Monday, April 20, 2009

TUGBU Integration

If you have had the problem of where to find the files :

So far the following Integration Packages have been released.

CCB-EBS 1.1 - on edelivery.oracle.com - part #B55798-01, file is V17373-01.zip
( old - CCB-EBS 1.0 - check out metalink 7452629 or on edelivery.oracle.com - Part # B54121-01, file is V15970-01.zip)

CCB-PS 1.1 - on edelivery.oracle.com - Part #B55862-01, file is V17401-01.zip
(old - CCB-PS 1.0 - on edelivery.oracle.com - Part #B54123-01, file is V15972-01.zip)

CCB-JDE 1.1 - on edelivery.oracle.com - Part #B56026-01, file is V17534-01.zip
(old - CCB-JDE 1.0 - on edelivery.oracle.com - Part #B54137-01, file is V15980-01.zip )

WAM-EBS 1.0 - check out metalink 7691153

CCB-NMS 1.0 - documentation is in metalink 8304750 , scripts are part of CCB 2.2.0 release

ETM-EBS 1.1 - on edelivery.oracle.com - Part # B55687-01, file is V17284-01.zip
(old - ETM-EBS 1.0 - on edelivery.oracle.com - Part # B53612-01, file is V15508-01.zip)

ETM-PS 1.1 - on edelivery.oracle.com - Part # B55614-01, file is V17268-01.zip
(old - ETM-PS 1.0 - on edelivery.oracle.com - Part # B53614-01, file is V15517-01.zip)

ETM-SIEBEL (Case Management) 1.0
on edelivery.oracle.com - Part # B57150-01, file is V17853-01.zip

ETM-SIEBEL (Public Sector) 1.0
on edelivery.oracle.com - Part # B55624-01, file is V16615-01.zip

SDK 2.2.0.5 to SDK 2.2.0.6 upgrade

If you have a previous SDK 2.2.0.x install and have not done any development work and want to upgrade to 2.2.0.6 here are some quick notes on how it can be done:

* Download the software (metalink 8255816) * Unzip it
* uninstall the existing SDK version form C:\SPLSDK\SDK\2.2.0.5\_uninst\uninstaller.exe
* install new (it will create a 2.2.0.6 folder)
* install eclipse in C:\SPLSDK\SDK\2.2.0.6\Eclipse
* Copy C:\SPLSDK\SDK\2.2.0.5\Eclipse folder to C:\SPLSDK\SDK\2.2.0.6\Eclipse

* copy the plugins C:\SPLSDK\SDK\2.2.0.5\tools\Eclipse\plugins on to C:\SPLSDK\SDK\2.2.0.6\Eclipse\plugins (RECOMMENDED - as eclipse plugins might change. If not done, old plugins might still exist)
* copy the jars into eclipse folder as mentioned in InstallationGuide.doc (hibernate, jta and c3p0, etc...)

* do the below 2 steps ONLY if a new version of C:\SPLSDK\SDK\UtilitiesEclipseConfig.exe is available (perhaps check the time stamp)
* uninstall the Oracle Utilities Eclipse Config 2.2.0 from Start -> Program Files -> Oracle Utilities Eclipse Config 2.2.0 -> Uninstall Oracle Utilities Eclipse Config 2.2.0
* install the new version of the Oracle Utilities Config 2.2.0 from C:\SPLSDK\SDK\UtilitiesEclipseConfig.exe

* Click on Start Eclipse script and per page 61 of the install guide re-configure the External Tools --> properties tab folder details i.e. \2.2.0.5 becomes 2.2.0.6. Also double check the setsplenv.bat script in C:\SPLSDK\SDK it should have reference to 2.2.0.6

* create the Linked Resource with application Server base
* Add default SPL Database properties from Eclipse -> Window -> Preferences -> SPL DataBase Properties [SHOULD be done before eclipse wizards are invoked]
* recopy AppServer Package scripts and DB PAckage scripts to CISDevelopment folder to override older copies

Friday, April 17, 2009

Bundle Object issues POST SP3/3a - FW 2.2.0 patch 8219901

FW patch 2.2.0 8219901 released March 23 2009

Hi
just finished installing a FW patch for Eyal for ETM 2.2.0 FW SP3a.
This patch helps fix a Bundle issues.
it has a few co-reqs and some pre-reqs (don't they all) but All are already installed for ETM 2.2.0 as they are in FW 2.2.0. SP3a , For CCB 2.2.0 folks here are the details:

Pre-req for this fix:
# 7132250 - in ETM-FW SP3a, FW SP1
# 7148799 - in ETM-FW SP3a, FW SP1
# 7353080 - in ETM-FW SP3a, FW SP3
# 7385001 - in ETM-FW SP3a, FW SP3
# 7493398 - in ETM-FW SP3a, FW SP3
# 7558419 - in ETM-FW SP3a, FW SP3
# 7692933 - in ETM-FW SP3a, needs to be installed for CCB first

and you will also need FW patches (in FW SP3a)
7692933
7694811
7715778
8207076
8219387
8248932 due to the dependencies
(thanks Douw)

it also has a database component (do not forget)

Wednesday, April 1, 2009

AWB v2.2.0

Oracle Utilities Customer Care and Billing Application WorkBench 2.2.0.0.0 Media Pack is

on http://edelviery.oracle.com/

under section , Oracle Utilities Framework for platform Microsoft Windows 32 bit

CCB/ETM/OUBI v2.1.0/v2.1.5/v2.2.0/v2.2.1 Language and Help files

On My Oracle Support (Metalink) you can see newly release Language Packs and Help Packs
CCB:
CCB V2.3.0 LATIN AMERICAN SPANISH LANGUAGE PACK 9177319
CCB V2.2.0 EUROPEAN SPANISH LANGUAGE PACK 8399523
CCB V2.2.0 RUSSIAN LANGUAGE PACK 8399698
CCB V2.2.0 FRENCH LANGUAGE PACK 7498832
CCB V2.2.0 LATIN AMERICAN SPANISH LANGUAGE PACK 8220958 (older)
CCB V2.2.0 ARABIC LANGUAGE PACK 9022400
CCB V2.2.0 ESTONIAN LANGUAGE PACK 8552277
CCB V2.2.0 JAPANESE LANGUAGE PACK 8769805
CCB V2.2.0 POLISH LANGUAGE PACK 8220977
CCB V2.2.0 BRAZILIAN PORTUGUESE LANGUAGE PACK 8483388
CCB V2.1.0 SIMPLIFIED CHINESE LANGUAGE PACK 7275049
CCB V2.1.0 TRADITIONAL CHINESE LANGUAGE PACK 6790161

and for CCB on-line help
SIMPLIFIED CHINESE TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8340322 (2.1.0)
BRAZILIAN PORTUGUESE TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8340534 (2.1.0)
POLISH TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8613623 (2.1.0)
FRENCH TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8642438 (2.2.0)
PORTUGUESE TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8642100 (2.2.0)
RUSSIAN TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 9053820 (2.2.0)
EUROPEAN SPANISH TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8679089 (2.2.0)
LATIN AMERICAN SPANISH TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8619370 (2.2.0)

ETM:
ETM V2.1.5 ARABIC LANGUAGE PACK 7656886
ETM V2.2.0 LATIN AMERICAN SPANISH LANGUAGE PACK 8641536

and for ETM on-line help
ARABIC TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8312186 (2.1.5)
LATIN AMERICAN SPANISH TRANSLATION FOR ONLINE HELP (USER ASSISTANCE) 8875372 (2.2.0)

OUBI:
OUBI V2.2.0 LATIN AMERICAN SPANISH LANGUAGE PACK 9140581

Tuesday, March 31, 2009

ETM v2.2.0

Oracle Enterprise Taxation Management version 2.2.0 is now available at http://edelivery.oracle.com/.This is built on the Oracle Utilties Framework V2.2.0. More info can be found at : http://www.oracle.com/industries/government/oracle-enterprise-taxation-management.html

Java 1.5.0_22 is now out

For though who keep track of the Java the new version for 1.5 is not 1.5.0_22. This has some interesting fixes http://java.sun.com/j2se/1.5.0/ReleaseNotes.html#150_22

RMB v2.2.0

Oracle Revenue Management and Billing version 2.2.0 is now available at http://edelivery.oracle.com/.
This is built on the Oracle Utilties Framework v2.2.0.
more info can be found at :
http://www.oracle.com/industries/financial_services/oracle-revenue-management-billing.html