Payment Error When Paying a Bill with Items of Negative Amount (Doc ID 2432153.1)

Last updated on MARCH 28, 2023

Applies to:

Symptoms

An issue related to payments when having a customer (migrated or not) with the following characteristics:
1. The account has products of negative amounts as credit.
2. The account has one bill with debt.
3. The account is billed so a new bill is generated.
4. Now the account has two bills with debts.
5. The customer makes a payment for the amount of the oldest bill in debt.  

STEPS
-------
0.  The Payment Tool is configured in a way that all the payments are automatically allocated at account level as a bussiness requeriment.
     i.e. PaymentTool.ini has restricted with NoManualAllocation=1 in [CONFIG] section.

1.  On Jun 28, create the account with the product
     One bill generated: B1-178996, Billing Cycle on the same date Jun 28 - Jun 28, Total Item Charges $51,480, Due Date Jul 18.
     Item Charges are:
     Cable - Rent $23,990
              - Rent  $7,490
              - Rent  $3,500
              - Rent  $3,990
              - Rent ($3,500)
              - Rent ($3,990)
      ID - $20,000

2.  Run pin_bill_accts -verbose -file.xml
     A new bill generated: B1-1789997, Billing Cycle Jun 28 - Jul 28, Total Item Charges $31,480, Due Date Aug 17.
     Item Charges are:
     Cable - Rent $23,990
             - Rent  $7,490
             - Rent  $3,500
             - Rent  $3,990
             - Rent ($3,500)
             - Rent ($3,990)
     ID -  Cargos $0

3.  A payment of $51480 is made to pay the oldest bill with debt.


ACTUAL BEHAVIOR  
--------------------
The payment affected 3 items of the oldest bill and 1 of the newest bills.

EXPECTED BEHAVIOR
-----------------------
The customer expects that ONLY the oldest bill is affected with this payment.

Cause

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