My Oracle Support Banner

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.