'Transferred' Field Amount of Child Bill Not Summed Up to Parent Account's Bill (Doc ID 2098179.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Symptoms

On :  7.5.0.11.0 version, Core Billing

ACTUAL BEHAVIOR  
--------------------------
The amount in the 'transferred' field of the child bills is not being summed up to the 'transferred' field amount of the parent account's bill.
SUBORDS_TOTAL + TRANSFERRED - RECVD <> DUE

EXPECTED BEHAVIOR
--------------------------
SUBORDS_TOTAL + TRANSFERRED - RECVD = DUE

Pricing Configuration
--------------------------
1. The /item/cycle_forward is individual (not cumulative).
    <ItemTypeElement>
        <ItemTag>cycle_forward</ItemTag>
        <ItemDescription>Cycle forward</ItemDescription>
        <ItemType precreate="false" type="individual" sub_type = "recurring">/item/cycle_forward</ItemType>
    </ItemTypeElement>
2. A plan is with a single deal.
3. A deal is with a product and a 50% discount.
4. The proration is turned on for both purchase and cancellation.

STEPS
--------------------------
1. 11 Apr, Create Parent Account, Create non-paying child account (associate with parent), purchase Plan
    /item/cycle_forward created with ITEM_TOTAL = 15.5

2. 22 Apr, Cancel the Plan
    New /item/cycle_forward created with ITEM_TOTAL = -9.81

3. Immediately after cancellation, amount from cancel item is allocated to the original purchase item (with custom code)
    Original Item ITEM_TOTAL = 15.5, DUE = 5.69
    Cancel Item  ITEM_TOTAL = -9.81, DUE = 0

4. Move pin_virtual_time (PVT) to next Bill Day of the Month (BDOM), 11 May

5. Bill the child account
    Bill object values populated as:
      "CURRENT_TOTAL","SUBORDS_TOTAL","PREVIOUS_TOTAL","TOTAL_DUE","DUE","RECVD","TRANSFERRED","ADJUSTED","DISPUTED"
                 5.69,              0,               0,          0, 5.69,  -9.81,        -9.81,         0,        0
   
    These values are as expected:
     DUE = 5.69 = CURRENT_TOTAL + TRANSFERRED - RECVD, i.e. 5.69 = 5.69 + (-9.81) - (-9.81)

6. Bill the Parent account
    Bill is finalized with parent bill object values as:
          "CURRENT_TOTAL","SUBORDS_TOTAL","PREVIOUS_TOTAL","TOTAL_DUE","DUE","RECVD","TRANSFERRED","ADJUSTED","DISPUTED"
                    0,           5.69,               0,       5.69, 5.69,  -9.81,            0,         0,        0

    These values are not as expected:
    DUE = 5.69 <> SUBORDS_TOTAL + TRANSFERRED - RECVD, i.e.  5.69 <> 5.69 + 0 - (-9.81)

    The above values do not match on bill_t and will cause issues in reporting.
    The TRANSFERRED value should have been taken from the child bills and be equal to 9.81.

Cause

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