My Oracle Support Banner

EDM: Facility Amount Available Is Negative (Doc ID 2786133.1)

Last updated on OCTOBER 26, 2021

Applies to:

PeopleSoft Enterprise FIN Deal Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



The facility available amounts and outstanding amounts are incorrect and do not tie. There are negative values, opening balances exceed the facility amount, etc.


1. Create $10 million facility 1/5/21
2.Create $5m deal 1/6/21 matures 8/11/21
3.Verify Facility Amount Available is $5m and Facility Activity Link Total Outstanding and Available Amount is $5m
4.Create $3m deal 1/12/21 matures 8/11/21
5.Verify Facility Amount Available is $2m and Facility Activity Link Total Outstanding is now $8m (initial $5m + $3m) and Available Amount is $2m ($10m facility - $8m outstanding)
6.Add $2m drawdown on 1/19 and $1m paydown on 1/26 – now there is $4m outstanding on deal
7.Facility $8m outstanding + $2m drawdown = $10m - $1m paydown = $9m outstanding ($1million available)
8. Deals 742 & 743 are open
9.Deactivate Deal 743 as of today

Expected Results: $9m currently outstanding on facility - $4m outstanding on deal 743 = $5m outstanding and $5m available

The $4m outstanding on the deal was subtracted from the initial $3m borrowing row ($3m+5m from other deal =$8m) so the $4m that the facility shows as outstanding is incorrect (should be $5m). Since the outstanding amount is incorrect, so is the $6m available (should be $5m). The drawdown and paydown rows should also remain on the facility activity as it is a historical transaction that occurred and has the correct amount outstanding and available to use when the deal is undone.

System (uses initial 1/12 available amount of $2m to add the $4m outstanding on DL743 to - $2M + $4M = $6M, shows $4M total outstanding which is incorrect because the entire deal was deactivated so the $5M on DL 742 should be what is outstanding)

Should be (uses current available amount of $1M since DL 742 & DL743 = $9M outstanding to add the $4M back to which would equal $5m ($1M + $4M = $5M) available and total outstanding would be $5M because DL742 is outstanding in its entirety




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

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