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 APRIL 26, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and laterOracle 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 |