Items Not Getting Updated With Correct Event's Usage Amount (Doc ID 1901174.1)

Last updated on JULY 07, 2014

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.

Goal

On BRM 7.5PS4, Item_total in item_t is not matching with total of event_bal_impacts_t amount for particular item. Cross checked all the events and found that there is one event where there are two impacts, one is for rated amount (0.43333 ) and the other is for discount amount (-0.43333). It seems only discounted amount is impacted in item_t table, but not the rated one. In Item_t table, there are only -0.43333 but sum (total rated events) is equal to 0.
 

Solution

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