Balance Monitoring Not Working Correctly For Hierarchy Accounts (Doc ID 1447625.1)

Last updated on OCTOBER 02, 2023

Applies to:

Symptoms

Balance monitoring is not including all the charges in case of hierarchy accounts with one parent and many child accounts. Not all the charges are rolled up to parent /balance_group/monitor object.

Plan Configuration:
----------------------
(1) A product with 25.92 Euro MCF, Proration enabled, 1 month advance billing on.
(2) Billing Configuration: DOM is fixed to 1st of every month.
(3) Billing time Taxation: Flat 19.6%

Scenario:
-----------

1. Create one account [L1] without any plan with Payinfo/invoice.
2. Create one account [L2] without any plan with Payinfo/invoice, having L1 as a parent
3. Create balance monitor group for this account. Credit Limit = 200 and threshold = 75%
4. Create one account [L3_1] with any plan with Payinfo/invoice L3, having L2 as a parent. [5 March 2012]
5. Run pin_monitor_balance utility
6. Check running total information for balance monitor group created on L2 account.
7. Create one account [L3_2]with any plan with Payinfo/invoice L3, having L2 as a parent [5 March 2012]
8. Run pin_monitor_balance utility
9. Check running total information for balance monitor group created on L2 account.
10. Create one account [L3_3]with any plan with Payinfo/invoice L3, having L2 as a parent [5 March 2012]
11. Run pin_monitor_balance utility
12. Check running total information for balance monitor group created on L2 account.
13. Purchased same plan on [L3_3] [10 March 2012]
14. Run pin_monitor_balance utility
15. Check running total information for balance monitor group created on L2 account.
16. Run the billing and again verify the running total information for balance monitor group created on L2 account
17. Check the mails configured (custom) to report threshold breach if any.
18. Test the balance monitoring feature.

With the above configuration and scenario the following observations can be made:

Note: plan/product has advance billing enabled.

Step 6: Prorated amount for first month bill was visible as running total in balance monitor group.

Step 9: Prorated amount for first month bill was visible as running total in balance monitor group which was visible with step 6, there was no change after step 8.

Step 15: Amount visible in running total of balance monitor group was unexpected

Step 16: After billing, amount visible in running total of balance monitor group was 153.01 Euro though total amount billed for all the accounts was 351.02

Step 17: Received 2 mails for L3_1 and L3_3 respective as follows:
L3_3 - Credit limit or threshold breach - Account ID <0.0.0.1 /account xxxxxxx 0>, Credit limit <200>, Percentage breach <76.5058000000>
L3_1 - Credit limit or threshold breach - Account ID <0.0.0.1 /account xxxxxxx 0>, Credit limit <200>, Percentage breach <76.5058000000>

Monitored balance was not correct. Email had correct information based on whatever was recorded in balance monitor group but it was sent for L3_3 and L3_1 though Balance monitor was configured for L2 account.

Changes

Cause

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