Data Model Upload Fails With 'This table <TABLE NAME> has data in it and hence cannot be dropped.'
(Doc ID 2974909.1)
Last updated on OCTOBER 13, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7 and laterOracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Symptoms
When adding data model changes to your OFSAA environment, the model upload fails with the following error in the model upload log:
Custom_Investment_Table.
This table CUSTOM_INVESTMENT_TABLE has been deleted in the new database model.
This table CUSTOM_INVESTMENT_TABLE has data in it and hence cannot be dropped.
As a result, the model upload changes are not added to the OFSAA database.
Cause
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
Symptoms |
Cause |
Solution |