Upgrade CCB To 1.5.20 With Service Pack 3 (Doc ID 744992.1)

Last updated on AUGUST 16, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: 1.5.15 and later   [Release: 1.5 and later ]
Information in this document applies to any platform.

Goal

Q1: After having upgraded CC&B from V1.5.15 to V1.5.20, the V1.5.20 SP3 DB installation stops with the
error:

Processing 6319991 ...

Error: ORA-00904: "ROOT_PK_INFO": invalid identifier (DBD ERROR: OCIStmtExecute)
occurred while executing
CREATE INDEX XT202S3 ON CI_ROOT_OBJ(ROOT_PK_INFO,BATCH_CD,BATCH_NBR,ENV_REF_CD,M
AINT_OBJ_CD,ROOT_STATUS_FLG)


A previous similar experience proved the solution would be to install in order on the DB the
V1.5.20 SP1, SP2 & SP3.
Is this solution the only way to address this issue?
If yes, could V1.5.20 SP1 and V1.5.20 SP2 be delivered, as they are not available on Metalink?


Q2: After having upgraded CC&B from V1.5.15 to V1.5.20, the V1.5.20 SP3 DB installation stops with the
error:

Processing 6319991 ...

Error: ORA-00904: "ROOT_PK_INFO": invalid identifier (DBD ERROR: OCIStmtExecute)
occurred while executing
CREATE INDEX XT202S3 ON CI_ROOT_OBJ(ROOT_PK_INFO,BATCH_CD,BATCH_NBR,ENV_REF_CD,M
AINT_OBJ_CD,ROOT_STATUS_FLG)

A previous similar experience proved the solution would be to install in order on the DB the
V1.5.20 SP1, SP2 & SP3.
Is this solution the only way to address this issue?
If yes, could V1.5.20 SP1 and V1.5.20 SP2 be delivered, as they are not available on Metalink?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms