OFSAAI Data Model Upload Failed With %AttName and %entityname() Errors

(Doc ID 1480037.1)

Last updated on MAY 06, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Oracle Financial Services Profitability Management - Version 5.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.1 and later
Oracle Financial Services Asset Liability Management - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Symptoms

On OFSAAI 7.3, when attempting to do a model upload the following error occurs:

ERROR
This Table has been added new %entityname()
(%AttName NUMBER(5) Not Null

There is a duplicate column in this Table ....Column Name is %AttName
(%AttName NUMBER(5) Not Null

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

This Table has been added new %entityname()
(%AttName DATE Not Null

There is a duplicate column in this Table ....Column Name is %AttName
(%AttName DATE Not Null

There is a duplicate column in this Table ....Column Name is %AttName
(%AttName DATE Not Null

As per the above messages, the correct Table and Column Names are not displayed.

The issue can be reproduced at will with the following steps:

1. Make changes to Data Model in CA ERwin 7.3.0.
2. Save changes to .xml file
3. Run model upload

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