Discount Bundle Purchase Leads To Multiple Balance Impacts
(Doc ID 3007029.1)
Last updated on MARCH 04, 2024
Applies to:
Oracle Communications Billing and Revenue Management - Version 12.0.0.8.0 and laterInformation in this document applies to any platform.
Goal
Given the following scenario on environment running Oracle Communications Billing and Revenue Management (BRM) 12.0.0.8.0, on which Sequential Discount is enabled:
1. Create an account with a base plan say on 17th Jan 2024.
BRM database after account creation:
bal_grp_sub_bals_t
==============
OBJ_ID0 REC_ID REC_ID2 VALID_FROM VALID_FROM_DETAILS VALID_TO VALID_TO_DETAILS CURRENT_BAL GRANTED_BAL
7913180 0 840 1705449600 0 0 0 241.94 0
7913180 2 1000201 1705449600 1 1706745600 0 -25977624774 -25977624774
event_bal_impacts_t
==============
ACCOUNT_OBJ_ID0 ACCOUNT_OBJ_TYPE BAL_GRP_OBJ_ID0 BAL_GRP_OBJ_TYPE BAL_GRP_OBJ_REV AMOUNT
7910620 /account 7913180 /balance_group 3 241.94
7910620 /account 7913180 /balance_group 3 -25977624774
2. Purchase a discount bundle (say 21% discount bundle) on the same date with a validity period of 12 months. 21% discount is correctly applied on the prorated MRC from step 1.
BRM database:
OBJ_ID0 REC_ID REC_ID2 VALID_FROM VALID_FROM_DETAILS VALID_TO VALID_TO_DETAILS CURRENT_BAL GRANTED_BAL
7913180 0 840 1705449600 0 0 0 191.13 0
7913180 2 1000201 1705449600 1 1706745600 0 -25977624774 -25977624774
ACCOUNT_OBJ_ID0 ACCOUNT_OBJ_TYPE BAL_GRP_OBJ_ID0 BAL_GRP_OBJ_TYPE BAL_GRP_OBJ_REV AMOUNT
7910620 /account 7913180 /balance_group 0 -50.81
7910620 /account 7913180 /balance_group 3 241.94
7910620 /account 7913180 /balance_group 3 -25977624774
3. Purchase another discount bundle (say 2.5% discount bundle) on the same date with a validity of 1 month. 2.5% discount is correctly applied from the net value of step 1 – step 2.
BRM database after purchasing:
OBJ_ID0 REC_ID REC_ID2 VALID_FROM VALID_FROM_DETAILS VALID_TO VALID_TO_DETAILS CURRENT_BAL GRANTED_BAL
7913180 0 840 1705449600 0 0 0 186.35 0
7913180 2 1000201 1705449600 1 1706745600 0 -25977624774 -25977624774
ACCOUNT_OBJ_ID0 ACCOUNT_OBJ_TYPE BAL_GRP_OBJ_ID0 BAL_GRP_OBJ_TYPE BAL_GRP_OBJ_REV AMOUNT
7910620 /account 7913180 /balance_group 0 -50.81
7910620 /account 7913180 /balance_group 3 241.94
7910620 /account 7913180 /balance_group 3 -25977624774
7910620 /account 7913180 /balance_group 0 50.81 <--- !!! !!!
7910620 /account 7913180 /balance_group 0 -50.81 <--- !!! !!!
7910620 /account 7913180 /balance_group 0 -4.78
However, observed that there are multiple records created in event_bal_impacts_t table at this step for the previous discount where there are new records created to re-apply and revert the 21%discount that was already applied in step 2.
Is this expected product behavior or is a bug?
Solution
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
Goal |
Solution |