"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

	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
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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

Applies to:

Goal

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!