EDM: TRX_POSITION_VW Record Shows Incorrect Deal Principal Balance For Open Ended Deals
(Doc ID 2922514.1)
Last updated on JULY 25, 2023
Applies to:
PeopleSoft Enterprise FIN Deal Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
A Deal is created. After Paydowns, the Principal Balance is zero. After running Deal Position Update, the TRX_POSITION_VW record shows some sets of rows with the original Principal Balance and not the current balance of zero.
STEPS
-----------------------
1. Deal Management > Administer Deals > Define Instruments > Add Instrument Type = SPT_LN_O3M
2. Setup Financials/Supply Chain > Common Definitions > Market Rates > Market Rate Index > Add Index = RBC_LIB3M
3. Setup Financials/Supply Chain > Product Related > Treasury > Rate Reset Codes > Add Rate Reset Index = RBC_LIB3M
4. Setup Financials/Supply Chain > Common Definitions > Market Rates > Market Rate Definition for Index = RBC_LIB3M > Term = 90, Currency = USD, Day Count Basis = Actual/360, Maximum Variance = 3.0
5. Setup Financials/Supply Chain > Common Definitions > Market Rates > Market Rates > Add Market Rate for Index = RBC_LIB3M > add an Effective Date for each year 2016 - 2022
6. Deal Management > Administer Deals > Facilities for Issuing Debt > Add Facility ID = FACILITY, Use Rate Index = RBC_LIB3M
7. Deal Management > Capture Deals > Deal > Add Deal = 000000000378, use Instrument Type = SPT_LN_O3M, Facility ID = FACILITY, Reset Index = RBC_LIB3M > Save
8. Click Cashflows icon at bottom of Deal page > 13 rows of Cashflows generated starting with 09/22/2016 and Ending with 09/23/2019 > click Return icon
9. Back to bottom of Deals page > click link for Interest Dates > Interest and Payment Dates window > 12 rows of Interest Payment starting with 12/22/2016 and ending with 3/22/2019
10. Still in Interest and Payment Dates window, add three different Paydowns > click icon for Add Paydown/Drawdown for each Paydown: 11/29/2017 = 4514000, 12/21/2017 = 562000, 01/18/2018 = 5000 after 01/18/2018 Paydown, Payment Amount = 0.00
11. Reporting Tools > Query > Query Manager > Record = TRX_POSITION_VW > TREAS_MASTER_ID = 000000000378
a. Rows 1 – 91, Balance = -5081000, Interest = 28716.96
b. Rows 92 - 433, Balance = -5081000, Interest = 0.00
c. Rows 434 – 455, Balance = -567000, Interest = 0.00
d. Rows 456 – 483, Balance = -5000, Interest = 0.00
e. Rows 484 – 1096, Balance = 0.00, Interest = 0.00
12. Deal Manager > Capture Deals > Deal Position Update > Processing Option = Process Openended Maturity
13. Deal Management > Capture Deals > Deals > Open Deal ID = 000000000378 > click on the Interest Dates link
14. Additional dates added after Deal Position Update, now shows 1 of 2 and Query TRX_INTEREST_TR returns the 27 rows
15. Query Record = TRX_POSITION_VW > 2192 total rows returned
a. Row 1 – 433 > PRINCIPAL_BALANCE = -5081000, PERIOD_INT_ACCRUAL = -28716.96
b. Row 92 > PERIOD_INT_ACCRUAL = 0
c. Row 434 – 455 > PRINCIPAL_BALANCE = -567000
d. Row 456 – 483 > PRINCIPAL_BALANCE = -5000
e. Row 484 - 1096 > PRINCIPAL_BALANCE = 0
f. Row 1097 – 1187 > PRINCIPAL_BALANCE = -5081000
g. Row 1188 – 2192 > PRINCIPAL_BALANCE = 0
Changes
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 |
Changes |
Cause |
Solution |
References |