CMT Does Not Manage Rollovers Correctly (Doc ID 1523755.1)

Last updated on FEBRUARY 08, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.1 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

On BRM 7.3.1.0.0 version, Conversion Manager component :
   CMT does not allow to set the correct values for rollover sub-balances.

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

We tested several values into the tags UOR, Frq, NetQnty for the sub-balance to be created but we cannot 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?



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