'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:
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]Information in this document applies to any platform.
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
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 |