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 MAY 10, 2023
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.
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
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