My Oracle Support Banner

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.

Goal

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.
 

Solution

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