Slice Model Upload Failed With Column 'cannot be deleted as the table has data for this column' Errors
(Doc ID 2067393.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Symptoms
On ALM 8.0.0, when attempting to do a sliced model upload in existing Liquidity Risk Management Infodom, the sliced model upload fails with the following errors in the model upload log:
ERROR
DIM_COMMON_COA.
This column D_RECORD_START_DATE has been deleted from the table DIM_COMMON_COA in the new database model
The Column D_RECORD_START_DATE of table DIM_COMMON_COA cannot be deleted as the table has data for this column.
This column D_RECORD_END_DATE has been deleted from the table DIM_COMMON_COA in the new database model
The Column D_RECORD_END_DATE of table DIM_COMMON_COA cannot be deleted as the table has data for this column.
...
DIM_MATURITY_BUCKETS.
...
This column V_MATURITY_BUCKET_DESC has been deleted from the table DIM_MATURITY_BUCKETS in the new database model
The Column V_MATURITY_BUCKET_DESC of table DIM_MATURITY_BUCKETS cannot be deleted as the table has data for this column.
----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------
Modelupload status..Altering the Model Failed.ERWINUPLOAD ERROR..Modelupload Failed
The issue can be reproduced at will with the following steps:
1. Install LRM 8.0.1.
2. Attempt to run sliced model upload with ALM 8.0 data model.
Changes
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 |
Changes |
Cause |
Solution |