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 |