My Oracle Support Banner

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.

Symptoms

Report- FR 2420

MDRM- SMMRN190

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
1. Weekly
2. Monthly
3. Quarterly
4. Semi-annually
5. Annually
6. Other
7. Daily

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

For Example,

  1. Monthly reset value for V_APR_RESET_REG_DISPLAY_CD should be 2 but it is 1 in DIM_APR_RESET_TYPE
  2. 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:

V_APR_RESET_TYPE_DESC                  V_APR_RESET_REG_DISPLAY_CD

Others

Missing

Fixed rate no reset                                         0

Monthly                                                         1

Every 2 months                                              2

Every 3 months                                              3

Every 6 months                                              4

Every 12 months                                            5

Others Rate Reset Frequency                           6

 

Changes

 This is a product configuration issue

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


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