OFSAA 8.0.x Model Upload Fails with Errors like 'This column CREATED_BY has been deleted from the table FSI_IRCS' (Doc ID 2293808.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), Funds Transfer Pricing (FTP), or Asset Liability Management (ALM) 8.0.x, when running a model upload in Data Model Maintenance, the model upload fails and the following errors are in the View Log:

Error - Metadata Mapping is Present for Tables, so cannot Drop
Error in Model Upload.
Model Upload Failed..Error in Upload Operation


The model upload log in /<ftpshare>/<infodom>/logs shows many seeded columns being dropped from seeded tables.  For example:

----------------------------------------------
FSI_IRCS.


 This column CREATED_BY has been deleted from the table FSI_IRCS in the new database model

 This column CREATED_DATE has been deleted from the table FSI_IRCS in the new database model

 This column LAST_MODIFIED_BY has been deleted from the table FSI_IRCS in the new database model

 This column LAST_MODIFIED_DATE has been deleted from the table FSI_IRCS in the new database model
(interest_rate_cd NUMBER(7) Not Null,irc_name VARCHAR2(60 CHAR) Not Null,irc_format_cd NUMBER(5) Not Null,accrual_basis_cd NUMBER(5) Not Null,COMPOUND_BASIS_CD NUMBER(5) Not Null,irc_desc VARCHAR2(300 CHAR) Null,irc_structure_type NUMBER(1) Null,generate_frequency_flg NUMBER(1) Null,interpolation_type_flg NUMBER(1) Null,%AttName VARCHAR2(30 CHAR) Not Null


 There is a duplicate column in this Table ....Column Name is %AttName
(interest_rate_cd NUMBER(7) Not Null,irc_name VARCHAR2(60 CHAR) Not Null,irc_format_cd NUMBER(5) Not Null,accrual_basis_cd NUMBER(5) Not Null,COMPOUND_BASIS_CD NUMBER(5) Not Null,irc_desc VARCHAR2(300 CHAR) Null,irc_structure_type NUMBER(1) Null,generate_frequency_flg NUMBER(1) Null,interpolation_type_flg NUMBER(1) Null,%AttName VARCHAR2(30 CHAR) Not Null


 There is a duplicate column in this Table ....Column Name is %AttName
(interest_rate_cd NUMBER(7) Not Null,irc_name VARCHAR2(60 CHAR) Not Null,irc_format_cd NUMBER(5) Not Null,accrual_basis_cd NUMBER(5) Not Null,COMPOUND_BASIS_CD NUMBER(5) Not Null,irc_desc VARCHAR2(300 CHAR) Null,irc_structure_type NUMBER(1) Null,generate_frequency_flg NUMBER(1) Null,interpolation_type_flg NUMBER(1) Null,%AttName VARCHAR2(30 CHAR) Not Null


 There is a duplicate column in this Table ....Column Name is %AttName

 Alter table scripts for the table FSI_IRCSfor dropping a column got created
----------------------------------------------


It is not clear what is causing the Metadata Mapping error.

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