ERL-6693: FCT_REG_FUND_LEND_DETAILS.N_REG_LOAN_PURPOSE_SKEY Population
(Doc ID 2810270.1)
Last updated on OCTOBER 04, 2021
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.
Version: RRS 80980, FSDF 80940
Report/Schedules: 009-C Part I
Col/MDRM: 5,10, 17, 22
Issue: Currently as part of 8098, PRUS_FUND_LEND_ACC_REG_COLS_02 is deprecated which was used to populate FCT_REG_FUND_LEND_DETAILS.N_REG_LOAN_PURPOSE_SKEY (until 80971) and we currently have the below logic in T2T, CASE WHEN FCT_COMMON_ACCOUNT_SUMMARY.N_ACCOUNT_PURPOSE_SKEY = -1 THEN -1 ELSE 0 END
However RLFD_FRFLRM_REG_RL_009C_02 & RLFD_FRFLRM_REG_RL_009C_03 use dim_reg_loan_purpose as criteria and expect values like 'HFP', 'AIRCRFT', 'DBCON', 'MED', 'EDU', 'PURCH', 'RESI PROP', 'LHP', 'MOT VEH ', 'HMIMP', 'REVMORT', 'CFAMRES1-4', 'CSHREF', 'RTRMFIN', 'OTHREFIN'
Clarification required on how 'FCT_REG_FUND_LEND_DETAILS.N_REG_LOAN_PURPOSE_SKEY' is expected to be populated with above values.
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