My Oracle Support Banner

How to Manually Populate FSI_D_BREAK_FUNDING_CHARGES (Doc ID 2711651.1)

Last updated on OCTOBER 04, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

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

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.