CCB Upgrade To 2.5.0.2.0 Takes Way Too Long (40 Hours)

(Doc ID 2277221.1)

Last updated on JUNE 17, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.2.0 and later
Information in this document applies to any platform.

Goal

On : 2.5.0.2.0 version, IP - Installation Upgrade Proc

ACTUAL BEHAVIOR
---------------
Customer Care and Billing upgrade to Release 2.5.0 Service Pack 2 takes way too long (40 hours)

It takes 40 hours to upgrade our CCB database from 2.4.0.3 to 2.5.0.2. Most of that time is spent running these three sql statements:
UPDATE CI_CC SET CC_ENTITY_FLG = ' '
UPDATE CI_CC SET CC_ENTITY_FLG = 'PER' WHERE PER_ID IS NOT NULL
UPDATE CI_CC SET CC_ENTITY_FLG = 'PREM' WHERE PER_ID IS NULL AND PREM_ID IS NOT NULL

There are about 30 million rows in the CI_CC table.
The above 3 statements are executed by: 25020_BUG_23171347.SQL and 25020_BUG_23171347_2.SQL


EXPECTED BEHAVIOR
-----------------------
Upgrade runs smoothly.
 

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