My Oracle Support Banner

T2T Mappings Missing for the attributes used in FFIEC009 Report (Doc ID 2744492.1)

Last updated on JANUARY 20, 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.

Symptoms

REG REP USFED

1) Claim- Schedule C-PART-II(FCEXC929(L01007C01), FCEXC932(LC0100C06))

These cells uses below join in data set condition

INNER JOIN DIM_RISK_SECTOR ON FCT_MITIGANTS.N_RISK_SECT_SKEY = DIM_RISK_SECTOR.N_RISK_SECTOR_SKEY

-- There is no mapping available inside the FCT_MITIGANTS T2T for the column FCT_MITIGANTS.N_RISK_SECT_SKEY.


2) Claim- Schedule C-Part1 (FCEXM861(L01007C21))

These cells uses below columns in lineage
‘FCT_REG_ACCOUNT_SUMMARY.N_RISK_TRANSFER_CNTRY_OUT_SKEY’ and ‘FCT_REG_ACCOUNT_SUMMARY.N_RISK_TRSNSFER_SECT_OUT_SKEY’

--There is no mapping available inside the FRAS T2T for N_RISK_TRANSFER_CNTRY_OUT_SKEY and N_RISK_TRSNSFER_SECT_OUT_SKEY columns

Changes

 NA

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
Changes
Cause
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.