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 FEBRUARY 03, 2019

Applies to:

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

Symptoms

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
DSO_DAYS = 30
(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.

Cause

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


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