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

Last updated on MARCH 19, 2019

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 + transfered - recvd <> Due

EXPECTED BEHAVIOR
-----------------------
Subords total + transfered - recvd = Due


STEPS
-----------------------
Pricing Configuration -
1) /item/cycle_forward is individual (not cumulative)
2) Plan with a single deal. Deal with Product and 50% discount
3) Proration configuration turned on for both purchase and cancellation

Steps -
1. 11 Apr - Create Parent Account, Create non-paying child account (associate with parent), purchase Plan
    Actual Amount and Expected Amount correct - Net =15.5 (Amt 31, Disc 15.5)
    /item/cycle_forward created with ITEM_TOTAL = 15.5 and DUE 15.5
2. 22 Apr - Cancel the Plan
    Actual Amount and Expected Amount correct - Net = -9.81 (Amt -19.36, Disc 9.82)
    New /item/cycle_forward created with ITEM_TOTAL = -9.81 and DUE -9.81
3. Immediately after cancellation, amount from cancel item is allocated to original purchase item (custom code)
    Orig Item  - ITEM_TOTAL = 15.5, DUE = 5.69
    Cancel Item - ITEM_TOTAL = -9.81, DUE = 0
    All the values are as expected
4. Move PVT to next 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
    Values are as expected:  DUE 5.69 = Current_total + transfered - recvd, i.e.   5.69 = 5.69 + (-9.81) - (-9.81)
6. Bill the Parent account. Bill is finalized with parent bill obj 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
    The values are not as expected -
    DUE 5.69 = Subords_total + transfered - recvd
    5.69 = 5.69 + 0 - (-9.81)
    The above values do not match
    The TRANSFERED value should have been taken from the child bills and be equal to 9.81

The database values on bill_t don't match up and will cause issues in reporting.

Cause

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