Upgrade 7.4 DB Model To 7.5 Without Default Values On EVENT_T Table

(Doc ID 1988125.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

On : 7.5.0.0.0 version, Infranet Install

How to Upgrade BRM 7.4 DB model to 7.5 without default values on EVENT_T table ?

In order to manually upgrade BRM 7.4 DB model to 7.5, we have seen that EVENT_T table earns new columns to host LINK_OBJ poid : LINK_OBJ_DB, LINK_OBJ_ID, LINK_OBJ_TYPE, LINK_OBJ_REV. Third of this columns are added with a default value ('0'). Also BAL_GRP_BALS_T table with these new columns : CONSUMED_RESERVED_AMOUNT (default value is 0 too)

For performance purpose, we would like not to initialize with the default value, is BRM is able to work without these values for existing records?



 

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