"Ondb Upgrade" Additional Columns In Event_product_fee_cycle_t
(Doc ID 1377710.1)
Last updated on SEPTEMBER 09, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and laterInformation 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
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
Goal |
Solution |