Rounding Differences Between Items And Sub-balances
(Doc ID 1389573.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later
During billing, in case of validity based events,delta_due value of an item is added to all
sub_balances associated to the bill instead of just added to one of them, this is causing incorrect balances.
select sum(amount) from event_bal_impacts_t where bal_grp_obj_id0 = <35984064> and resource_id = <32>
The sum is : 89,5755
But if the opcode PCM_OP_BAL_GET_BALANCES is executed for the same balance group, result is :
0 PIN_FLD_BALANCES ARRAY  allocated 7, used 7
1 PIN_FLD_CONSUMPTION_RULE ENUM  0
1 PIN_FLD_CREDIT_FLOOR DECIMAL  NULL
1 PIN_FLD_CREDIT_LIMIT DECIMAL  NULL
1 PIN_FLD_CREDIT_THRESHOLDS INT  0
1 PIN_FLD_CURRENT_BAL DECIMAL  89,6115
1 PIN_FLD_NEXT_BAL DECIMAL  0
1 PIN_FLD_RESERVED_AMOUNT DECIMAL  0
Note that the sum of event balance impacts is different to current_bal on balance group (89,5755 <> 89,6115)
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