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

Last updated on MARCH 29, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.1 to 7.3.1.0.1 - Release: 7.3.1 to 7.3.1
HP-UX Itanium

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms