My Oracle Support Banner

How to Delete Records from Fct_ftp_account_summary Prior to T2T Run (Doc ID 2717728.1)

Last updated on OCTOBER 07, 2020

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.7 and later
Oracle Financial Services Data Foundation - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
OBIEE Repository Database (RPD)
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Reporting
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)

Goal

What is the best way to delete records from fct_ftp_account_summary table for different instruments?

For the fct_common_account_summary table, there is a n_data_source_cd field, so for different source, this can be used as a filter.
Why does fct_ftp_account_summary not have a source indicator?  How to delete one instrument record and then rerun the T2T to copy that instrument records back to it?

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


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