Upgrade Causing Data Model Upload Issues Due To Different Data Types
(Doc ID 3022717.1)
Last updated on SEPTEMBER 17, 2024
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7.4.0 and laterOracle 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 |