ERL-7130 - 009 - Remaining Maturity
(Doc ID 2809863.1)
Last updated on OCTOBER 03, 2021
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.
Version: RRS 80970, FSDF 80940
Report/Schedule: FFIEC-009, Sch C Part I
MDRM: Col 11, C921
As per 009 instructions,
"In Column 11, show all claims reported in Columns 1 through 10 that have a remaining contractual maturity of one year or less except as described below. The definition of “one year” should be consistent with the definition used in the FFIEC 031 and the FR Y-9C.
Marketable equity investments, both trading and available-for-sale, should be reported as maturing in less than one year.
Debt securities held for trading should be reported as maturing in less than one year. All other debt securities should be reported according to the remaining maturity."
1) The definition of “one year” should be consistent with the definition used in the FFIEC 031 and the FR Y-9C
031 and Y9C have handling for Fixed - Remaining Maturity, Floating to Fixed - Remaining maturity, Float - Time to next repricing, Embedded option - time to option date, etc. Same is not addressed in 009
2) All marketable equity investments (all holding type) and HFT Debt Securities should be reported <1Year, irrespective of instrument maturity
3) RC-C has specific handling for maturity of fixed rate/revolving cards, that they should be considered >1year irrespective of maturity date.
Current configuration uses remaining maturity, which does not address above criteria.
TRUNC(TO_DATE(COALESCE(FCT_COMMON_ACCOUNT_SUMMARY.N_EFF_MATURITY_DATE_SKEY, FCT_COMMON_ACCOUNT_SUMMARY.N_MATURITY_DATE_SKEY, FCT_COMMON_ACCOUNT_SUMMARY.N_ORIG_MATURITY_DATE_SKEY), 'YYYYMMDD') - TO_DATE(FCT_COMMON_ACCOUNT_SUMMARY.N_MIS_DATE_SKEY, 'YYYYMMDD'))
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