My Oracle Support Banner

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.

Symptoms

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_REG_ACCOUNT_SUMMARY.N_BRANCH_COUNTRY_SKEY WHEN
FCT_COMMON_ACCOUNT_SUMMARY.N_ACCOUNT_COUNTRY_SKEY NOT IN (0, -1) THEN
FCT_COMMON_ACCOUNT_SUMMARY.N_ACCOUNT_COUNTRY_SKEY ELSE
FCT_REG_ACCOUNT_SUMMARY.N_BRANCH_COUNTRY_SKEY END

FSDF staging table column required are-STG_CASA.V_COUNTRY_ID, STG_TD_CONTRACTS.V_COUNTRY_ID and STG_BORROWINGS.V_COUNTRY_CODE

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.