Master Excess Allocation Is Over Allocating the payments (Doc ID 2905661.1)

Last updated on OCTOBER 30, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Master Excess Allocation is Over Allocating

Allocating more than Payment Excess.

After running MEA batch job, USD 0.1 was getting allocated as Payment Excess to the Master account which was resulting into doubling of the net excess amount on the Master account.

After running MEA batch job, USD 0.89 was getting allocated to Associated account as Payment Excess. 

EXPECTED BEHAVIOR
-----------------------

USD 0.1 should not get allocated as Payment Excess to the Master account.

USD  0.89 should remain at Master account as net excess amount. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Case 1
1. Create a Line Master and Associated accounts
2. Generate bill
3. Make payment equal to the due amount for each account
4. Run MEA batch job, verify that account is not picked and MEA run date next also not updated as there is no excess payment on the account
5. After few days make payment of 0.1 amount on Master account, verify that payment allocates to Payment Excess on the account
6. Run MEA batch job, verify that account is picked and MEA run date next also updated as there is an excess payment on the account. Check 0.1 is not allocated since there are no dues available on the accounts

Before the fix – .

Case 2
1. Create a Line Master and few Associated accounts
2. Make excess payment on Master account that is more than total due amount
of Master and Associated accounts. For example, if total due amount is 300 then make payment of 300.89 on Master account
3. Generate bill
4. Run MEA batch job, verify that account is picked and MEA run date next also updated as there is an excess payment on the Master account and after allocating 300 to all the accounts. Remaining 0.89 amount should be left at Master
account as excess payment

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.