My Oracle Support Banner

Why Does Model Upload Attempt To Drop Tables With Data During 8.1 PFT, FTP, or ALM Upgrade? (Doc ID 2806693.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Goal

When upgrading your environment from PFT, FTP, or ALM 8.1, when uploading the data model, why is it trying to drop tables that contain data?  You are getting many errors like the following in the ETLService.log in $FIC_HOME/logs:

This table FCT_MGMT_REPORTING has been used in Measure definitions and hence cannot be dropped.

This table DIM_CUSTOMER has been used in the Dataset definitions and hence cannot be dropped.

This table FCT_COMMON_ACCOUNT_SUMMARY has been used in Measure definitions and hence cannot be dropped.

There are many similar errors in the log.

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.