CCB Upgrade To 188.8.131.52.0 Takes Longer than 40 Hours
(Doc ID 2277221.1)
Last updated on MARCH 22, 2019
Applies to:Oracle Utilities Customer Care and Billing - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, IP - Installation Upgrade Proc
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 18.104.22.168 to 22.214.171.124. 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
Upgrade runs smoothly.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document