Rerating Fails Due To Non-existent Monitor Sub-balances
Last updated on OCTOBER 05, 2015
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Rerating/Rebilling
Rerating constantly fails for some account due to some non-existent monitor sub-balances.
While investigating one specific account for which rerating fails with below error and found that it fails to backout event /event/billing/product/fee/cycle/cycle_forward_monthly because the corresponding /balance_group/monitor sub-balance element does not exist.
There is no entry in the monitor_queue_t table for this account and this event, which explains that the /balance_group/monitor was not updated with this sub-balance element.
Below is the query
SQL> select status from monitor_queue_t where account_obj_id0=80252661589 and event_obj_id0=291256379701598603;
no rows selected
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms