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)

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

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)

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.

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)

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

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

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)

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

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