My Oracle Support Banner

Issue With Balance Group VALID_TO Date In Subscription Transfer (Doc ID 1611735.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.

Symptoms

At the time of  subscription transfer from one parent account to another parent account, balance group valid_to dates are not consistent.


Below is the example:

Created account on 4th Oct with Product, which will grant free resources e.g, 1GB (1002504) and 300MB (1002505) and ran the first bill cycle (DOM(accounting day of month)=16) and on 4th Nov transferred the unit to different parent account.
It will split these free resource Grant with different Valid_to date like below:

POID_ID0 POID_TYPE REC_ID REC_ID2 CURRENT_BAL GRANTOR_OBJ_ID0 GRANTOR_OBJ_TYPE VALID_FROM VALID_TO
732094 /balance_group 282 1002504 -396.39 735966 /purchased_product 02/01/1970 16/11/2013
732094 /balance_group 136 1002504 -627.61 730833 /purchased_product 02/01/1970 16/11/2013
732094 /balance_group 284 1002505 -116.13 735966 /purchased_product 02/01/1970 16/11/2013
732094 /balance_group 138 1002505 -183.87 730833 /purchased_product 02/01/1970 04/11/2013  <== This is Wrong

 

Detailed Steps:

============================================================================
1. Account Created on 31st Oct, 2013
    Account Poid = 264458
    Login = <LOGIN>
    Parent Account poid = 259531

    Balance Group for resource id 1002504,1002505 are below
    OBJ_ID0    REC_ID    REC_ID2    VALID_FROM    VALID_FROM_DETAILS    VALID_TO    VALID_TO_DETAILS    CURRENT_BAL    NEXT_BAL    DELAYED_BAL    CONTRIBUTOR    ROLLOVER_DATA    GRANTOR_OBJ_DB    GRANTOR_OBJ_ID0    GRANTOR_OBJ_TYPE    GRANTOR_OBJ_REV    ITD(SB.VALID_TO)
    263050    66    1002504    108000    0    1384581600    0    -528.52    0    0        1073807360    1    264954    /purchased_product    0    16/11/2013    
    263050    68    1002505    108000    0    1384581600    0    -154.84    0    0        1073807360    1    264954    /purchased_product    0    16/11/2013    

2. Transferred on 4th Nov, 2013
    Login = <LOGIN>
    New Account poid = 266385
    New Parent Account poid = 265139
============================================================================


Actual Result After Transfer:

    After Transfer Balance Group for resource id 1002504,1002505 are below
    
    OBJ_ID0    REC_ID    REC_ID2    VALID_FROM    VALID_FROM_DETAILS    VALID_TO    VALID_TO_DETAILS    CURRENT_BAL    NEXT_BAL    DELAYED_BAL    CONTRIBUTOR    ROLLOVER_DATA    GRANTOR_OBJ_DB    GRANTOR_OBJ_ID0    GRANTOR_OBJ_TYPE    GRANTOR_OBJ_REV    ITD(SB.VALID_TO)
    263050    184    1002504    108000    0    1384581600    0    -396.39    0    0        1073807360    1    267865    /purchased_product    0    16/11/2013    
    263050    66    1002504    108000    0    1384581600    0    -132.13    0    0        1073807360    1    264954    /purchased_product    2    16/11/2013    
    263050    186    1002505    108000    0    1384581600    0    -116.13    0    0        1073807360    1    267865    /purchased_product    0    16/11/2013    
    263050    68    1002505    108000    0    1383544800    0    -38.71    0    0        1073807360    1    264954    /purchased_product    2    04/11/2013    

Expected Results After Transfer:

    After Transfer Balance Group for resource id 1002504,1002505 should be like below
    
    OBJ_ID0    REC_ID    REC_ID2    VALID_FROM    VALID_FROM_DETAILS    VALID_TO    VALID_TO_DETAILS    CURRENT_BAL    NEXT_BAL    DELAYED_BAL    CONTRIBUTOR    ROLLOVER_DATA    GRANTOR_OBJ_DB    GRANTOR_OBJ_ID0    GRANTOR_OBJ_TYPE    GRANTOR_OBJ_REV    ITD(SB.VALID_TO)
    263050    184    1002504    108000    0    1384581600    0    -396.39    0    0        1073807360    1    267865    /purchased_product    0    16/11/2013    
    263050    66    1002504    108000    0    1384581600    0    -132.13    0    0        1073807360    1    264954    /purchased_product    2    16/11/2013    
    263050    186    1002505    108000    0    1384581600    0    -116.13    0    0        1073807360    1    267865    /purchased_product    0    16/11/2013    
    263050    68    1002505    108000    0    1383544800    0    -38.71    0    0        1073807360    1    264954    /purchased_product    2    16/11/2013    
============================================================================



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
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.