Questions About Break Funding Process and Breakage Data in FTP (Doc ID 2820702.1)

Last updated on APRIL 24, 2023

Applies to:

Goal

Question 1: What is the meaning of breakage flag? How is breakage_flag getting populated and how to exclude some values?

Question 2: The filter used during Break Funding process, does it filter out all data while writing to FSI_D_BREAK_FUNDING_CHARGES table or it filters out only when it writes back to FSI Prepayment tables?

As per understanding, it first writes breakage value for all data in FSI_D_BREAK_FUNDING_CHARGES and while writing back to PP tables, it filters out data as per the used filter. Can you confirm?
 
Question 3: Why change in Cur Net Rate is logged as break for adjustable rate instruments?
 
Question 4: Can T2T be used for setting breakage_Flg = 0 or 1?

Question 5: For given record(s), below six fields are not equal to last month's data (break identification table compared to underlying instrument table). How does it happen?

LAST_REPRICE_DATE

LAST_PAYMENT_DATE

NEXT_REPRICE_DATE

NEXT_PAYMENT_DATE

TRAN_RATE_REM_TERM

REMAIN_NO_PMTS_C

Question 6. For CUR_BOOK_BAL and CUR_PAR_BAL fields, is the data coming from AFTER_PAYMENT_BALANCE on Prepayment table?

Solution

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