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)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)
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?
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