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 MARCH 17, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information 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.

Cause

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