RC-B M2d - Removal Of Next Payment Date (Doc ID 2824752.1)

Last updated on DECEMBER 05, 2021

Applies to:

Goal

Version: RRS 80982, FSDF 80941
Report/Schedule: FFIEC-031 RC-B
Line/MDRM: Memo 2d - RCFDA248

Issue:
Client has requested enhancement to consider only time remaining till Put date while reporting Securities with put option in M2d, and not consider the next payment date (which is only applicable for other MDRMs like M2a/M2b which need to report earlier of put date or next repricing date for exercised floating rate put bonds)

Current logic (in BPRG1116)
WHEN DIM_INTEREST_TYPE.V_INTEREST_TYPE IN ('Fixed Rate', 'Floating Rate')
AND COALESCE(DERG0601.BPRG0612, DERG0602.BPRG0662) = 'Y'
THEN CASE
WHEN COALESCE(DERG0601.BPRG0618, DERG0602.BPRG0668, FCT_REG_ACCOUNT_SUMMARY.N_NEXT_PAYMENT_IN_MONTHS) IS NOT NULL
THEN LEAST(COALESCE(DERG0601.BPRG0618, DERG0602.BPRG0668, 2401), COALESCE(FCT_REG_ACCOUNT_SUMMARY.N_NEXT_PAYMENT_IN_MONTHS, 2401))
ELSE 0
END
Expected logic:
WHEN DIM_INTEREST_TYPE.V_INTEREST_TYPE IN ('Fixed Rate', 'Floating Rate')
AND COALESCE(DERG0601.BPRG0612, DERG0602.BPRG0662) = 'Y'
THEN CASE
WHEN COALESCE(DERG0601.BPRG0618, DERG0602.BPRG0668) IS NOT NULL
THEN COALESCE(DERG0601.BPRG0618, DERG0602.BPRG0668)
ELSE 0
END
 

Solution

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