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