Advanced Collections - EBS (MOSC)

MOSC Banner

Reg one preconfigured metrics not calculating as documented in the Advanced Collections Module

The Advanced Collections Module comes with preconfigured metrics documented here:

My organization enabled "True DSO" and reviewed the source code in IEX_COLL_IND.pkb. Contrary to the implementation guide which defined True DSO as:

True DSO per invoice = Number of days from invoice date to reporting date * (invoice amount / net credit sales for the month in which sale occurred)

The source code in IEX_COLL_IND.pkb follows this formula:

True DSO = Avg Open Balance / Daily Sales

Where daily sales = past 12-month receivables / 365, and

Avg Open Balance = (Current open balance + Open balance 12-mo ago)/2

This seems like a big misalignment to me, as with the current code True DSO will not represent actual days unpaid; instead, it's basically calculating a conventional DSO based on past 12-month. Can this be patched?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center