5.9.1 Oracle Database 26ai Data Model Updates for Columns with Default Value
A new installation of OFS CRA 8.1.2.0.0 with Oracle AI Database 26ai will fail for the 8.1.2.0.0 Erwin patch. To fix this issue, follow these steps
Table 5-11 Oracle Database 26ai Data Model Updates for Columns with Default Value
| Physical Name | Physical Name | Physical Data Type | Domain Parent | Value |
|---|---|---|---|---|
| Dim_Mr_Mntcrlo_Sim_Def | f_business_approach_ind | CHAR(1) | Flag | -1 |
- Correct the default values in Erwin model for the above-mentioned columns, default value recommendation shall be provided by PM based on functional relevance. e.g. Y/N/1
- Generate Repository xml.
- Place the repository xml in server and mention the location of xml in silent props file and modify below parameters in Silent.props file
# Specify whether you want to use the released datamodel or customized datamodel for model upload process
# 0 = If you want to upload the released datamodel
# 1 = If you want to upload the customized datamodel
MODEL_TYPE=1
# Specify the path (DM_DIRECTORY) and file (DATAMODEL) name for the customized datamodel
# Mandatory only if you want to upload the customized datamodel
# i.e you have specified MODEL_TYPE=1
DATAMODEL=MODEL_NAME
DM_DIRECTORY=MODEL_LOCATION_FOLDER_NAME
Follow below steps if we have corrected repository xml changes
Erwin Folder Setup
-
- Since we have used latest Erwin version to correct the repository xml (and older versions used for 8.1.2 is Erwin98 ), DB support requires an Erwin100
- For each Erwin version, a corresponding folder must exist under $FIC_HOME.
- The installer looks for the Erwin XML conversion utility in this version-specific folder.
- Currently, the 8.1.2 installer includes only Erwin98 and Erwin99
- Therefore, Erwin100 must be created immediately after Platform installation in the following location {$FIC_HOME}/ficapp/common/FICServer/conf