How to Manually Populate FSI_D_BREAK_FUNDING_CHARGES (Doc ID 2711651.1)

Last updated on AUGUST 01, 2023

Applies to:

Goal

Manually populating the FSI_D_BREAK_FUNDING_CHARGES. Here is the logic being used based on an interpretation of the OFSAA FTP User Guide (note: the "p." prefix represents PREVIOUS month instrument record and "c." prefix is CURRENT month instrument record). Need assistance to verify if this is correct as the LAST_PAYMENT_DATE logic does not seem sensible:

PARTIAL Breaks - previous record
AS_OF_DATE:
Current AS_OF_DATE (c.as_of_date)

LAST_PAYMENT_DATE:
CASE WHEN p.NEXT_PAYMENT_DATE <= c.AS_OF_DATE THEN p.NEXT_PAYMENT_DATE ELSE p.LAST_PAYMENT_DATE END

LAST_REPRICE_DATE:
CASE WHEN p.NEXT_REPRICE_DATE <= c.AS_OF_DATE THEN p.NEXT_REPRICE_DATE ELSE p.LAST_REPRICE_DATE END

NEXT_PAYMENT_DATE:
CASE WHEN p.NEXT_PAYMENT_DATE <= c.AS_OF_DATE THEN
  CASE WHEN p.PMT_FREQ_MULT=''M'' THEN ADD_MONTHS(p.NEXT_PAYMENT_DATE,p.PMT_FREQ)
  WHEN p.PMT_FREQ_MULT=''Y'' THEN ADD_MONTHS(p.NEXT_PAYMENT_DATE,12*p.PMT_FREQ)
  WHEN p.PMT_FREQ_MULT=''D'' THEN p.NEXT_PAYMENT_DATE+p.PMT_FREQ END
  ELSE p.NEXT_PAYMENT_DATE END

NEXT_REPRICE_DATE:
CASE WHEN p.NEXT_REPRICE_DATE <= c.AS_OF_DATE THEN
  CASE WHEN p.PMT_FREQ_MULT=''M'' THEN ADD_MONTHS(p.NEXT_REPRICE_DATE,p.PMT_FREQ)
  WHEN p.PMT_FREQ_MULT=''Y'' THEN ADD_MONTHS(p.NEXT_REPRICE_DATE,12*p.PMT_FREQ)
  WHEN p.PMT_FREQ_MULT=''D'' THEN p.NEXT_REPRICE_DATE+p.PMT_FREQ END
  ELSE p.NEXT_REPRICE_DATE END NEXT_REPRICE_DATE,

BREAKAGE_AMOUNT:
0

RECORD_IND:
-1

PARTIAL Breaks - current record
All records from instrument pulled in "as is"

BREAKAGE_AMOUNT:
p.CUR_BOOK_BAL-c.CUR_PAR_BAL BREAKAGE_AMOUNT (FYI - Are award this should be p.AFTER_PAYMENT_BALANCE-c.cur_par_bal)

RECORD_IND:
1
 

Solution

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