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

(Doc ID 1900782.1)

Last updated on MAY 11, 2017

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.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms