Is It Possible to Delete Unused FSI_D_% Instrument and Related Staging Tables From the Erwin Data Model? (Doc ID 1276477.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Goal

When using Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) with Oracle Financial Services Profitability Management (PFT), is it possible to drop and delete the FSI_D_ instrument tables and related staging tables that are not being used?

For example:

FSI_D_ANNUITY_CONTRACTS
FSI_D_BORROWINGS
FSI_D_BREAK_FUNDING_CHARGES
FSI_D_GUARANTEES
FSI_D_LEASES
FSI_D_LOAN_CONTRACTS
FSI_D_MERCHANT_CARDS
FSI_D_MM_CONTRACTS
FSI_D_MORTGAGE_BACK_SEC
FSI_D_OTHER_SERVICES
FSI_D_TRUSTS
STG_ANNUITY_CONTRACTS
STG_BILLS_CONTRACTS
STG_BORROWINGS
STG_FUTURES
STG_FX_CONTRACTS
STG_GUARANTEES
STG_LEASES_CONTRACTS
STG_LOAN_CONTRACTS
STG_MERCHANT_CARDS
STG_MM_CONTRACTS
STG_OPTION_CONTRACTS
STG_OTHER_SERVICES
STG_SWAPS_CONTRACTS
STG_TRUSTS


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms