"Ondb Upgrade" Additional Columns In Event_product_fee_cycle_t (Doc ID 1377710.1)

Last updated on DECEMBER 06, 2011

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Goal

There are certain additional columns in the table event_product_fee_cycle_t, offering_obj_*, which get created during upgrade from 73 to 74. However, these columns are not present in fresh installation of BRM 7.4.

Are these columns are required or we can remove them?

The desc event_product_fee_cycle_t outputs --

From upgrade environment:
CREATE TABLE PIN5.EVENT_PRODUCT_FEE_CYCLE_T
(
OBJ_ID0 NUMBER(22),
CYCLE_END_T NUMBER(38),
CYCLE_START_T NUMBER(38),
FLAGS NUMBER(38),
SCALE NUMBER,
OFFERING_OBJ_DB NUMBER, <------------ Additional field
OFFERING_OBJ_ID0 NUMBER, <------------ Additional field
OFFERING_OBJ_TYPE VARCHAR2(255 BYTE), <------------ Additional field
OFFERING_OBJ_REV NUMBER, <------------ Additional field
ORIGINAL_SCALE NUMBER
)

From OOB environment:
CREATE TABLE PIN6.EVENT_PRODUCT_FEE_CYCLE_T
(
OBJ_ID0 INTEGER,
CYCLE_END_T INTEGER,
CYCLE_START_T INTEGER,
SCALE NUMBER,
ORIGINAL_SCALE NUMBER,
FLAGS INTEGER
)

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