Rounding Differences Between Items And Sub-balances (Doc ID 1389573.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Symptoms

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.

Example:

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 [32] allocated 7, used 7
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1 PIN_FLD_CREDIT_LIMIT DECIMAL [0] NULL
1 PIN_FLD_CREDIT_THRESHOLDS INT [0] 0
1 PIN_FLD_CURRENT_BAL DECIMAL [0] 89,6115
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0

Note that the sum of event balance impacts is different to current_bal on balance group (89,5755 <> 89,6115)

Cause

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