Questions on T2T Mapping for Next Payment Date and Payment Frequency Definition
(Doc ID 2429798.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Goal
Question 1: On T2T for FSI_D_INVESTMENTS, Next Payment Date is mapped to NVL(D_DATE_P, D_DATE_I) where D_DATE_P is Next Principal Payment Date and D_DATE_I is next interest payment date. In case of coupon paying instruments where principal payment happens on maturity only, NEXT_PAYMENT_DATE in FSI_D_INVESTMENTS table get populated with maturity date instead of next interest payment date because of the mapping in the T2T.
Please advise how to address such cases so that next payment date is populated correctly in FSI instrument table.
Question 2: What are the following Payment Frequency Columns for STG_INVESTMENTS and how are they mapped to FSI_D_INVESTMENTS?
N_INT_PAYMENT_FREQUENCY
N_PRIN_FREQUENCY
N_COUPON_FREQUENCY
Solution
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
Goal |
Solution |
References |