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:

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

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