Updating A Rate Name in Pricing Center Causes a New Row to be Added to Rate_t

(Doc ID 1923872.1)

Last updated on DECEMBER 19, 2016

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.
Checked for relevance on 19-Dec-2016.

Symptoms

On :  7.5.0.6.0 version, PricingCenter

ACTUAL BEHAVIOR  
---------------------------------
When updating a rate name in Pricing Center, BRM inserts a new rate into rate_t instead of updating the rate_t.descr. Same is the case with rate_bal_impacts_t.
Pricing Center only displays the more recent rate, and so far in the testing, BRM is selecting the newer rate for rating events.

EXPECTED BEHAVIOR
---------------------------------
New row should not be inserted, but the same row should be updated in relevant column.

STEPS
---------------------------------
1. create a product in Pricing Center and commit it to BRM DB
2. update the 'Name' on the Rate Data tab and then commit to BRM DB again. This will insert another row into the rate_t table ( and also rate_bal_impacts_t ) for the same rate_plan but with the updated descr.  

Alternatively, you can verify it by SQL queries, for example:

1. Check the existing records in rate_t:

SQL> select poid_id0, poid_type, rate_plan_obj_id0, descr from rate_t;

 POID_ID0 POID_TYPE  RATE_PLAN_OBJ_ID0 DESCR
--------- ---------- ----------------- ------------------------------------
   149175 /rate                 151223 $9.95 a month
   147895 /rate                 150967 $2 per hour
   149943 /rate                 150967 $1 per hour
   148919 /rate                 150967 $1 per hour
   148599 /rate                 150647 $3 a month
   149111 /rate                 147831 $7.50 before 6/1/2000
   151159 /rate                 147831 $15 Sign-Up Fee
   149879 /rate                 150903 No Monthly Fee
   148855 /rate                 150903 $19.95 a Month
   148727 /rate                 150775 No Charges
   149239 /rate                 151287 $45/quarter, 3rd quarter discount
   557938 /rate                 559986 Rate 1
   558962 /rate                 561010 Rate 1
   323584 /rate                 346326 renta_motot

14 rows selected.

 
2. From Pricing Center, create one new product IP100.
    Check the rate_t in again:

SQL> select poid_id0, poid_type, rate_plan_obj_id0, descr from rate_t;

 POID_ID0 POID_TYPE  RATE_PLAN_OBJ_ID0 DESCR
--------- ---------- ----------------- -------------------------------------
   149175 /rate                 151223 $9.95 a month
   147895 /rate                 150967 $2 per hour
   149943 /rate                 150967 $1 per hour
   148919 /rate                 150967 $1 per hour
   148599 /rate                 150647 $3 a month
   149111 /rate                 147831 $7.50 before 6/1/2000
   151159 /rate                 147831 $15 Sign-Up Fee
   149879 /rate                 150903 No Monthly Fee
   148855 /rate                 150903 $19.95 a Month
   148727 /rate                 150775 No Charges
   149239 /rate                 151287 $45/quarter, 3rd quarter discount
   557938 /rate                 559986 Rate 1
   558962 /rate                 561010 Rate 1
   680068 /rate                 682116 Rate 1    <--------- new record -------
   323584 /rate                 346326 renta_motot

15 rows selected.

 

3. From Pricing Center, update the new IP product on the rate name from default Rate 1 to IP100.
    Check the rate_t again:

SQL> select poid_id0, poid_type, rate_plan_obj_id0, descr from rate_t;

 POID_ID0 POID_TYPE  RATE_PLAN_OBJ_ID0 DESCR
--------- ---------- ----------------- -----------------------------------
   149175 /rate                 151223 $9.95 a month
   147895 /rate                 150967 $2 per hour
   149943 /rate                 150967 $1 per hour
   148919 /rate                 150967 $1 per hour
   148599 /rate                 150647 $3 a month
   149111 /rate                 147831 $7.50 before 6/1/2000
   151159 /rate                 147831 $15 Sign-Up Fee
   149879 /rate                 150903 No Monthly Fee
   148855 /rate                 150903 $19.95 a Month
   148727 /rate                 150775 No Charges
   149239 /rate                 151287 $45/quarter, 3rd quarter discount
   557938 /rate                 559986 Rate 1
   558962 /rate                 561010 Rate 1
   680068 /rate                 682116 Rate 1    <---- the new record from last step
   682628 /rate                 682116 IP100     <---- another new record created with rate name
   323584 /rate                 346326 renta_motot

16 rows selected.

 

Changes

 

Cause

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