Unusable Index During Pinrel Results In Item_t.Item_total != Evt_bal_impatcs.Amt (Doc ID 818162.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On Oracle Communications Billing and Revenue Management(BRM) Applications, unusable index during pin_rel results in item_t.item_total != evt_bal_impatcs.amt.

Steps To Reproduce:

1)Check the item_t.ITEM_TOTAL for the current bill cycles /item/usage = sum(amount) from event_bal_impacts_t for the /item/usage item. 

   Queries :  

   a) select item_total from item_t where poid_id0 = <item_poid>
   b) select sum(amount) from event_bal_impacts_t where item_obj_id0 = <item_poid> 

2) Create a CDR with multiple calls from the same MSISDN.
3) Rate the CDR.
4) While loading the rated CDR thorugh PIN_REL, make the index "I_EVENT__ID" unusable.
5) Check the below queries:

    a) select item_total from item_t where poid_id0 = <item_poid>
    b) select sum(amount) from event_bal_impacts_t where item_obj_id0 = <item_poid>

Results of query a is not equal to result of query b.

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