My Oracle Support Banner

FCT_REG_ACCOUNT_MITIGANT_MAP Load: T2T Loads Same Data Multiple Time With Different Run Skeys (Doc ID 2719797.1)

Last updated on OCTOBER 16, 2020

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

RRS USFED T2T

T2T_FCT_REG_ACCOUNT_MITIGANT_MAP

FCT_REG_ACCOUNT_MITIGANT_MAP is getting loaded from FCT_ACCOUNT_MITIGANT_MAP which stores the mapping between an instrument and its corresponding mitigants, with no corresponding legal Entitiy references.

Since there are no reference to the Legal Entity,  during the loads all the instruments are getting reloaded in the table, stamped with different run_skey creating duplicate data for each partition.

Enhancement request to restrict data in FCT_REG_ACCOUNT_MITIGANT_MAP for reporting LE only by making changes to the T2T object
 

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.