Dimension Table - DIM_APR_RESET_TYPE Has Incorrect And Missing Values For V_APR_RESET_REG_DISPLAY_CD (Report FR2420)
(Doc ID 2597446.1)
Last updated on OCTOBER 17, 2019
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.6 and later
Information in this document applies to any platform.
Report- FR 2420
Instruction says to report this MDRM according to the values mentioned below (example report '0' for No Reset and '1' for Weekly)
0. No Reset
For this purpose product configuration is using the following attribute 'DIM_APR_RESET_TYPE.V_APR_RESET_REG_DISPLAY_CD' but the display codes used in this column is not as expected by FED instructions
- Monthly reset value for V_APR_RESET_REG_DISPLAY_CD should be 2 but it is 1 in DIM_APR_RESET_TYPE
- For Daily reset the value for V_APR_RESET_REG_DISPLAY_CD should be 7 but it's missing in DIM_APR_RESET_TYPE
Below is the table DIM_APR_RESET_TYPE data with existing reg display codes:
Fixed rate no reset 0
Every 2 months 2
Every 3 months 3
Every 6 months 4
Every 12 months 5
Others Rate Reset Frequency 6
This is a product configuration issue
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