My Oracle Support Banner

Usage of hard coded value V_ACCT_STATUS_CODE ='FORECLOSURE' in FSDF T2T expression (Stg Loans/OD/Leases) (Doc ID 2706495.1)

Last updated on SEPTEMBER 07, 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

 Version : FSDF 8.0.8

Usage of V_ACCT_STATUS_CODE & V_FORECLOSURE_STATUS_CODE

Data element sheet for RRS 8084 mentions V_ACCT_STATUS_CODE as a required attribute referring to DIM_ACCT_STATUS populated through SCD however following T2Ts from Stg Loans/OD/Leases use the hard coded value V_ACCT_STATUS_CODE ='FORECLOSURE' that seems to be incorrect.

For example : While mapping the attribute N_FORECLOSURE_BALANCE_RCY into FCT_LOAN_ACCOUNT_SUMMARY table, OFSAA uses following expression :

CASE WHEN STG_OD_ACCOUNTS.V_ACCT_STATUS_CODE ='FORECLOSURE' THEN STG_OD_ACCOUNTS.N_EOP_BAL*FSI_EXCHANGE_RATES.N_EXCHANGE_RATE ELSE 0 END

We observe that there is already a field V_FORECLOSURE_STATUS_CODE (in Stg OD, Leases, Loans per DE sheet v8084 ) referring to DIM_FORECLOSURE_STATUS and having value 'FRCSD' (Foreclosed) to determine foreclosure status,

The current usage of hard coded value in source expression looks 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.