My Oracle Support Banner

RLUS_FRAS_REG_PROD_CLASS_08 Is Using N_REPAYER_SKEY And Leading To Incorrect Reclassification (Doc ID 2732198.1)

Last updated on DECEMBER 02, 2020

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

RRS 80951

RLUS_FRAS_REG_PROD_CLASS_08 is using

[HIFD1010].A_DIM_BOOLEAN_REPAYER_NPO_FLG.V_FLAG_CODE as 'Y' is used to classify OTHLOAN
[HIFD1010].A_DIM_BOOLEAN_REPAYER_NPO_FLG.V_FLAG_CODE as 'N' is used to classify COMINDLOAN

Data in N_REPAYER_SKEY is not present in some cases and as per rule data set whenever this column is NULL then A_DIM_BOOLEAN_REPAYER_NPO_FLG.V_FLAG_CODE is defaulting to 'N' hence getting classified as COMINDLOAN instead of OTHLOAN

Issue -
V_REPAYER_CODE is an optional field. Logic in Dataset "DSFD5059" does a COALESCE(A_DIM_PARTY_REPAYER.F_NON_PROFIT_ORG_FLAG, 'N')) which is incorrect



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.