My Oracle Support Banner

Upgrade Causing Data Model Upload Issues Due To Different Data Types (Doc ID 3022717.1)

Last updated on MAY 20, 2024

Applies to:

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

Symptoms

Recent model upload failed with the following error after upgrade to Erwin 12.5. The database has data type Number, the model has data type Decimal.

Error:
Model upload log shows the following sample erroneous modification:

fsi_o_cons_detail_template

The Change is made in Column Name :RESULT_SYS_ID
RESULT_SYS_ID DEC(10) DEFAULT NULL *RESULT_SYS_ID NUMBER(10) DEFAULT NULL
The Change is made in Column Name :PRODUCT_ID
PRODUCT_ID DEC(14) DEFAULT NULL *PRODUCT_ID NUMBER(14) DEFAULT NULL
The Change is made in Column Name :COMMON_COA_ID
COMMON_COA_ID DEC(14) DEFAULT NULL *COMMON_COA_ID NUMBER(14) DEFAULT NULL
...etc



Steps To Replicate:
1. Update ERWIN from 2019 R1 to Erwin 12.5 to use in both 8.0.7.4 and 8.1.2.4 environments.
2. Copy $FIC_HOME/ficapp/common/FICServer/conf/Erwin99/Erwin.xsl from 8.1.2.4 to 8.0.7.4 environment.
3. Update existing model in 8.0.7.4 and perform model upload, and it failed with error above.
4. Check data model in Erwin 12.5 and found some NUMBERS fields (ie: RATE) have been changed to DECIMALS.
5. Open ALM Data Model <Patch 29009206> for version 8.0.7.0.0 using Erwin 12.5, found the same issue where NUMBERS field such as RATE are changed to DECIMALS.

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
References


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