My Oracle Support Banner

Incorrect Expression used For Populating column 'N_REPRICING_FREQ_MON' In table 'FCT_CREDIT_LINE' (Doc ID 2679297.1)

Last updated on JUNE 17, 2020

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

T2T mappings for N_REPRICING_FREQ_MON in FCT_CREDIT_LINE in FSDF 808 and 809 is as mentioned below:

 

CASE
WHEN UPPER(STG_CREDIT_LINE_DETAILS.V_REPRICE_FREQ_UNIT) = 'D' THEN
ROUND(STG_CREDIT_LINE_DETAILS.N_REPRICING_FREQ * 30)
WHEN UPPER(STG_CREDIT_LINE_DETAILS.V_REPRICE_FREQ_UNIT) = 'Y' THEN
ROUND(STG_CREDIT_LINE_DETAILS.N_REPRICING_FREQ / 12)
WHEN UPPER(STG_CREDIT_LINE_DETAILS.V_REPRICE_FREQ_UNIT) = 'M' THEN
STG_CREDIT_LINE_DETAILS.N_REPRICING_FREQ
ELSE
NULL
END

 

The column 'N_REPRICING_FREQ_MON' should store the reprice data in 'MONTHS'

As per existing logic, for the reprice freq units 'D' (days) and 'Y' (year) incorrect data is getting loaded into N_REPRICING_FREQ_MON in FCT_CREDIT_LINE

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
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.