Data Model Upload Failed after Merge with ALMBI 5.6 (Doc ID 1384581.1)

Last updated on DECEMBER 22, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.9 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to upload merged data model that contains changes from ALMBI 5.6 the following error occurs.

Error:
MODEL UPLOAD FAILED

dim_run
The Change is made in Column ...f_latest_record_indicator
Data exists for the column f_latest_record_indicator in the table dim_run

fsi_bi_setup_table

The Change is made in Column ...TARGET_COL_NAME
Data exists for the column TARGET_COL_NAME in the table fsi_bi_setup_table

The modified column N_COMMON_COA_SKEY is Primary Key of the table FCT_COMMON_ACCOUNT_SUMMARY
###colStr::::::::::N_COMMON_COA_SKEY NUMBER(14) Not Null*n_common_coa_skey NUMBER(10) Null
The Column n_prod_skey has been added new.


Steps:
1. Merge working model with ALMBI 5.6 data model.
2. Upload data model but the upload failed.

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