My Oracle Support Banner

Total Invoice Amount is Not Calculating Correctly for Days Overdue Dunning (Doc ID 2098591.1)

Last updated on OCTOBER 25, 2023

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.


When using Days Overdue dunning in Advanced Collections, the Total Invoice Amount is not calculating correctly, and can result in no dunning letter. Running Staged Dunning for
the same customer works fine.


Steps to Reproduce:

Responsibility: Collections Agent
: Run IEX: Send Dunning for Delinquent Customers program

  1. Create a new customer and create 3 invoices for $129 each (total overdue is $387).
  2. Run scoring and make them all delinquent.
  3. Create an on account credit memo for that same customer for $183.
  4. Run Days overdue dunning, no letter is produced, and the log file indicates the following (actual past due balance = $204):

    Total Invoice amount= 129
    Total of open Account Receipts and credit memos= -183
    Total amount due remaining at Billto level= -54
    Total amount due is less than Minimum dunning amount, so returning value "N"
    Error:The dunning amount does not exceed the minimum required in customer profile to send dunning.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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