My Oracle Support Banner

RLUS_FRAS_PERIOD_RATE_CAP_FLR Not Updating N_PERIODIC_RATE_CAP And N_PERIODIC_RATE_FLOOR (Doc ID 2767957.1)

Last updated on APRIL 15, 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.

Symptoms

Report: FFIEC031/041
Schedule: RC-B

RLUS_FRAS_PERIOD_RATE_CAP_FLR updates FCT_REG_ACCOUNT_SUMMARY.N_PERIODIC_RATE_CAP and FCT_REG_ACCOUNT_SUMMARY.N_PERIODIC_RATE_FLOOR by reading from
FCT_EMBEDDED_OPTIONS_SCHEDULE
Investments records for STG_EMBEDDED_OPTION_SCHEULDE are driven based on V_INSTRUMENT_CODE and V_ACCOUNT_NUMBER = MSG/OTH.

Current rule logic works for loans but does not work for investments due to inner join on fct_reg_account_summary.n_acct_skey = fct_embedded_options_schedule.n_acct_skey.

The logic is expected to update the
FCT_REG_ACCOUNT_SUMMARY.N_PERIODIC_RATE_CAP and FCT_REG_ACCOUNT_SUMMARY.N_PERIODIC_RATE_FLOOR from FCT_EMBEDDED_OPTIONS_SCHEDULE based on V_INSTRUMENT_CODE where the
V_ACCOUNT_NUMBER = MSG/OTH

Changes

 NA

Cause

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
Symptoms
Changes
Cause
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.