My Oracle Support Banner

Rerating Fails Due To Non-existent Monitor Sub-balances (Doc ID 2060046.1)

Last updated on MARCH 24, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


On : 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

Error Log   


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

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