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