My Oracle Support Banner

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 later
Information 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


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