Lineage Issue for schedule RC-E, FFIEC031/041- Lineage is unable to show the V_COUNTRY_ID from STG_CASA and STG_TD_CONTRACTS tables and V_COUNTRY_CODE from STG_BORROWINGS
(Doc ID 2642441.1)
Last updated on FEBRUARY 26, 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.
Data element sheet 809 is showing following columns are applicable for RC-E schedule (STG_CASA.V_COUNTRY_ID, STG_TD_CONTRACTS.V_COUNTRY_ID and STG_BORROWINGS.V_COUNTRY_CODE). The lineage document extracted is not showing these columns for RC-E schedule
Below is the data flow for one RC-E MDRM (RCON2202) which indicates that these columns are applicable for this MDRM code but not shown in the lineage doc :
H M Linkage uses HREG2353 (HIR - RR Reported as Domestic Acct Flag) for the requirement of Domestic offices for this MDRM
HREG2353-> Rule RLUS_FRAS_REG_BRANCH_COUNTRY -> BPFD1001 that has logic
CASE WHEN FCT_REG_ACCOUNT_SUMMARY.N_BRANCH_COUNTRY_SKEY NOT IN (0, -1) THEN
FCT_COMMON_ACCOUNT_SUMMARY.N_ACCOUNT_COUNTRY_SKEY NOT IN (0, -1) THEN
FSDF staging table column required are-STG_CASA.V_COUNTRY_ID, STG_TD_CONTRACTS.V_COUNTRY_ID and STG_BORROWINGS.V_COUNTRY_CODE
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