Overview of Dunning in Oracle Fusion Applications

What is Dunning?

Dunning is the business practice of letting delinquent customers know about their overdue payments for their transactions. This is usually done through a printed letter, and can be delivered via fax, printed letter, or as a PDF attachment.

How are delinquent transactions identified for Dunning?

These transactions are identified automatically from the program called “Collections Delinquency Management Process”. This program runs and identifies those delinquent transactions that need to be included in a dunning letter.

How is a Customer Site Enabled for Dunning?

There are a couple of additional setups required to enable a Customer to be receive Dunning Letters.

1. Enable “Send Dunning Letters” at the Customer Profile Class Level
2. The Customer Site should have a Business Purpose of “Dunning”
3. The Customer Site should have a contact with a "Dunning" responsibility. If there is no specific contact that will receive the letter, the template can be addressed to a generic title, such as "Accounts Payables Manager".
4. Additional Setups in the Manage Collections Preferences task
5. Additional Setups in the Manage Dunning Configurations task

Dunning Features

Oracle already has a pre-configured dunning letter template that can be personalized and can be sent automatically from the system. The templates can be edited so that it meets your business requirements, such as putting in your company logo, or changing the wording in the template itself.

Oracle also offers the flexibility to exclude certain customers from dunning. There might be situations where your organization might decide that certain customers are going to be exempt from receiving dunning letters.

Dunning in Collections also includes the assignment of follow-up call activities in the form of Collection Tasks. You can assign a collector to do follow up phone calls and record the customer interaction in the application. There is also the ability to resend dunning letters even if they were already previously sent.

There's also the ability also for a collector to see the dunning history. You can view the correspondence history of dunning letters that have been sent to the customer and when they have been sent and what was the method (Email, Printed, etc). This includes who was the contact that received the letter.

Oracle also provides the ability to set thresholds to know when a customer is eligible to be sent a Dunning Letter.

Manage Collections Preferences

The Manage Collections Preferences page contain some important setups and defaults, such as the return email address for dunning correspondence, maximum number of transactions to send with dunning letters, default aging method, etc.

To Navigate to this page, go to the Functional Setup Manager > “Financials” offering > “Collections” functional area > Search for the Task "Manage Collections Preferences".

The Global Preferences section applies to all Business Units, while the Preferences and Correspondence section could be business unit specific, depending your reference data sets are mapped to your business units.

Below is a video demonstration showing you how to set Collections Preferences and Correspondence in Oracle Fusion applications:

There are two types of Dunning Thresholds: "minimum dunning amount" and "minimum dunning invoice amount".

Dunning Thresholds

In "minimum dunning amount", this means that this amount is the minimum dunning amount set for all overdue transactions to have correspondence generated. For example, you might have a minimum dunning amount that's $100. There are two overdue transactions for Customer A, one for $55 and another one for $40. When you add up those two transactions, the total will be $105. This means this Customer is eligible to be sent a Dunning Letter.

In "minimum dunning invoice amount", it's similar to the "minimum dunning amount" but only at the transaction level. For the same earlier example, the minimum dunning invoice amount set is $100. There are two overdue transactions for Customer A, one for $55 and another one for $40. This means this Customer is NOT eligible to be sent a Dunning Letter.

Dunning Methods

Aged method – The collection letters are going to be sent to customers based on the oldest aged transaction. Aging means that you're going to be looking at the balances of the customer transactions (invoices and debit memos). These transaction balances will be grouped in “buckets”  such as 1 to 30 days, 31 to 60 days, 61 to 90 days, and so on.

Staged method – This method is based on collection letters being sent based on the number of days since the last dunning letter was sent. It doesn't really look at the oldest aged transaction. It looks at the number of days since the last dunning letter was sent.

Dunning Configuration Tasks

This page is what dunning configurations the system will use such as, Dunning method, Aging Buckets, and the Set ID the system will use. You might decide that you have one dunning configuration for all business units, or maybe specific dunning configurations for specific business units.

To Navigate to this page, go to the Functional Setup Manager > “Financials” offering > “Collections” functional area > Search for the Task "Manage Dunning Configurations".

Dunning Letter Templates

Oracle delivers four dunning letter templates, the soft, medium, hard, and final. These templates correspond to the number of days the delinquent customer hasn’t remit the payment.

For Example, if the transaction is overdue between 1 and 30 days, the system will send a Soft Dunning Letter. If it's 31 to 60 days, you're going to send a medium dunning letter. The difference with these letters are the wordings. These letters will be more assertive as time goes on. And then, at the end, you have a final demand letter, and that will be when transactions fall in this bucket, 91 days or older.

Modifying the pre-defined Dunning Letter Templates

If you're interested in seeing or editing the wording in these templates and how they look, The pre-defined Dunning Letter template can be modified using the Business Intelligence Publisher tool. To do this, Navigate to Tools > Reports and Analytics > Browse Catalog > Shared Folders > Financials > Collections.

Note that you should have the relevant Business Intelligence roles to be able to do this.

Next, go to the “Correspondence” folder and open the “Collections Send Dunning Letters” report. This will show you the Soft, Medium, Hard and Final Dunning Letters. You can download, view, edit and upload the templates from this screen.

Below is a video demonstration of Modifying Collection Dunning and Dispute Letter Templates in Oracle Fusion Applications:

Validate Customer Dunning Setups

There is a report that you can run to the validate dunning setups aptly called “Validate Customer Dunning Setup report”. This will help you in identifying issues with these required customer setups. It is best practice to run this report to make sure that your customers are set up correctly. The mandatory parameters are business unit and business level. In the business level parameter denotes that there are three levels that you can perform collections at, Customer Party, Account, and Site level. You can also run the report for specific customers if you wish to do so.

Send Dunning Letters Program

The program “Send Dunning Letters” allows a collections user to run the standalone delivery of Dunning Letters. What this process does is it generates a the dunning letter, even if it has already been previously sent. If the contact method is email, then it will send an email to the dunning contact of the customer along with the attached report in PDF Format.

The “Send Dunning Letters” process can also be launched automatically after the “Collections Scoring and Strategy Assignment” process runs. “Collections Scoring and Strategy Assignment” process is applicable if you’ve implemented the strategies feature in Collections. If not, then you can run or schedule the program “Send Dunning Letters” on its own.

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/

Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)