My Oracle Support Banner

CMT Does Not Manage Rollovers Correctly (Doc ID 1523755.1)

Last updated on NOVEMBER 09, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.

Symptoms

CMT does not allow to set the correct values for rollover sub-balances.

During migration of postpaid accounts, the user needs to set the rollover for non consumed credit of free minutes from previous billing cycle.

Tested with several values into the tags UOR, Frq, NetQnty for the sub-balance to be created, but it is failed to get the correct values into the /balance_group.PIN_FLD_BALANCES[].PIN_FLD_SUB_BALANCES[].PIN_FLD_ROLLOVER_DATA.

For example, consider the following input xml file to migrate 2 sub-balances:

<ActBalArr parentRef="" serviceRef="ACT_SRV_1" Resource="101011100" elem="2">
 <BSBArr elem="0" grtObjRef="/purchased_product">
   <CurBal>-14400</CurBal>
   <VldFrm>2012-09-10T00:00:00+02:00</VldFrm>
   <ValTo>2012-10-10T00:00:00+02:00</ValTo>
   <GrtObj>PURPRD_0ecM_2</GrtObj>
   <UOR>M</UOR>
   <Frq>1</Frq>
   <NetQnty>-14400</NetQnty>
 </BSBArr>
 <BSBArr elem="1" grtObjRef="/purchased_product">
   <CurBal>-1200</CurBal>
   <VldFrm>2012-08-10T00:00:00+02:00</VldFrm>
   <ValTo>2012-10-10T00:00:00+02:00</ValTo>
   <GrtObj>PURPRD_0ecM_6</GrtObj>
 </BSBArr>
<ConRule>UN</ConRule>
</ActBalArr>

- the first related to the new bucket initialised with -14400, having ValidFrom=2012-09-10 and ValidTo=2012-10-10
- the second related to the rollover generated from previous un used bucket with -1200 value and having ValidFrom=2012-08-10 and ValidTo=2012-10-10

After running CMT, it creates 3 sub balances like below:
- two sub-balances with ValidFrom=0, one with current bal = 0, rollover_data=65536 and the second with current bal = -14400, rollover_data=1073807361
- the third sub-balance with current bal = -1200, rollover_data = 0 and ValidFrom=2012-08-10 and ValidTo=2012-10-10

There are several problems with the CMT behaviour:
1- the ValidFrom should never be equal to 0 for the sub balance related to new bucket (-14400)
2- the rollover sub balance should have rollover_data = 65536 and current bal equal to -1200, but from the two sub balances one is having current bal = 0 and the other has rollover_data = 0
3- there should be only 2 sub balances created, what is the purpose of creating the one with current_bal = 0?



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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