Installing OFS LLFP 8.1.2 with Oracle 26ai Database
Oracle Database 26ai validates the default value lengths during the DDL execution. As a result, a two-character default value such as -1 cannot be assigned to a CHAR(1) or VARCHAR(1) column.
If the OFS LLFP 8.1.2.0.0 data model contains these invalid default values, the data model upload fails during installation with the following error.
Figure 5-1 Error Message
To successfully install OFS LLFP 8.1.2.0.0 on Oracle Database 26ai, update the affected column default values before performing the model upload.
The following columns contain invalid default values that must be updated.
Table 5-4 Affected Columns
| Table | Column | Data Type | Current Default | Required Default |
|---|---|---|---|---|
| FSI_IFRS_ACCOUNTING_DIM_MAP | F_LATEST_RECORD_INDICATOR | CHAR(1) | -1 | N |
| FCT_IFRS_ACCOUNT_EVENT_DTLS | FCT_IFRS_ACCOUNT_EVENT_DTLS | CHAR(1) | -1 | N |
| FCT_IFRS_ACCOUNT_EVENT_DTLS | FCT_IFRS_ACCOUNT_EVENT_DTLS | CHAR(1) | -1 | N |
| FCT_IFRS_GROUP_EVENT_DTLS | FCT_IFRS_GROUP_EVENT_DTLS | CHAR(1) | -1 | N |
| FCT_IFRS_GROUP_EVENT_DTLS | FCT_IFRS_GROUP_EVENT_DTLS | CHAR(1) | -1 | N |
Note:
Replace the default value -1 with N,Y or 1 for every CHAR(1) column that currently has a default value of -1.