My Oracle Support Banner

Days Sales Outstanding (DSO) Shows As 0 When There Are No Sales Within The DSO Days (Doc ID 1900782.1)

Last updated on JULY 14, 2020

Applies to:

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


On : 12.1.3 version, Collections Agent UI

Days Sales Outstanding (DSO) now shows as zero when Total Sales for DSO days is zero.

This has changed from previous functionality, in which you would substitute a 1, when the sales were 0.

DSO Formula:
DSO = (total outstanding receivables/total sales for last DSO days) * (DSO Days)
NOTE: If Total Sales for DSO days is null or zero, then one (1) is substituted in the calculation.

You have the following:
GET_CONV_DSO_OCM : l_op_bal 40
GET_CONV_DSO_OCM : l_tot_bal 0
(40/0) * 30 = 0

Based on note, this should be (40/1) * 30 = 1200
So the code does NOT include this substitution:  iexvmtib.pls latest version 120.12.12010000.7
l_conv_dso := l_op_bal/l_tot_bal*l_dso_days;

Steps to Reproduce:
1. DSO days = 30
2. Create new customer, and invoice for 01-FEB-2014, sysdate = 05-JUN-2014.
3. Run scoring engine, customer is delinquent. DSO = 0
4. Create invoice for 01-JUN-2014, rerun scoring.
5. DSO now shows as 45.




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.