My Oracle Support Banner

Updating A Rate Name in Pricing Center Causes a New Row to be Added to Rate_t (Doc ID 1923872.1)

Last updated on SEPTEMBER 30, 2024

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.

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:

 

Changes

 

Cause

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
Symptoms
Changes
Cause
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.