Incorrect Current_bal Calculation During Updating Leading To Numeric Overflow (Doc ID 3014027.1)

Last updated on APRIL 05, 2024

Applies to:

Symptoms

On Oracle Communications Billing and Revenue Management (BRM) 12.0.0.7.0 multischema environment having Pipeline Manager as rating engine (Elastic Charging Engine(ECE) is not installed here) it was observed that for some executions of PCM_OP_ACT_USAGE, PIN_FLD_CURRENT_BAL of currency balance (985) ends with very large numbers (tens/hundreds of digits).

Problem cannot be reproduced at will, but it was accidentally catch on DEBUG level in production environment. For the example covered by respective cm.pinlog, it was observed that PIN_FLD_CURRENT_BAL increased from -392820059324649715415360616.06 to -785640118649299430830717974.94.
This is happening during execution of "sync of sub-balances between brm and ece". To be noted ECE is not installed in this environment.

It can be seen current_bal has been multiplied by 2, even though the bal_impact amount was only -0.73. Multiple multiplication of current_bal for the same balance group leads to values >1e130 which exceeds database number range (-1 x 1e-130 to 9.99..99 x 1e125). Manual correction is needed in order to avoid reaching numeric overflow values.

Cause

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