5 Application Framework Database Changes
This chapter provides lists of database changes in Oracle Utilities Application Framework included with the 26.4 release of Oracle Utilities cloud services. This includes:
New Tables
| Table | Name | Description |
|---|---|---|
| F1_HEALTH_ASSESS_TYPE | Health Assessment Type | Used to capture details for health assessment types. |
| F1_HEALTH_ASSESS_TYPE_L | Health Assessment Type Language | Language table for health assessment type |
| F1_HEALTH_ASSESS_TYPE_ALG | Health Assessment Type Algorithm | Used to store algorithms associated with a health assessment type |
| F1_HEALTH_ASSESS_TYPE_CHAR | Health Assessment Type Characteristics | Used to store characteristics associated with a health assessment type |
| F1_HEALTH_ASSESS | Health Assessment | Used to capture details for health assessments |
| F1_HEALTH_ASSESS_CHAR | Health Assessment Characteristics | Used to store characteristics associated with a health assessment |
New Columns
| Table_Name | Column_Name | Data Type | Length |
|---|---|---|---|
| CI_BATCH_CTRL | MULTI_THREADED_FLG | CHAR | 16 |
| CI_BATCH_JOB | F1_NO_PROC_NEEDED | CHAR | 4 |
| CI_PORTAL_ZONE | PANEL_NAME | VARCHAR2 | 120 |
| CI_PORTAL_ZONE | PANEL_WIDTH_FLG | CHAR | 16 |
| CI_SCR | BV_APP_SVC_ID | CHAR | 80 |
| CI_SCR | BV_SCR_ELIG_OPT_FLG | CHAR | 16 |
| F1_IWS_SVC | IN_SVC_BASE_FLG | CHAR | 16 |
| F1_IWS_SVC | IN_SVC_CUSTOM_SW | CHAR | 4 |
| F1_IWS_SVC_OPER | CUSTOM_SCR_CD | CHAR | 48 |
| F1_PROC_PANEL | COND_PANEL_SW | CHAR | 4 |
Updated Columns
| Table_Name | Column_Name | Old | New |
|---|---|---|---|
| F1_MKTCFG | KEY_VALUE1 | Varchar2 50 | Varchar2 100 |
| F1_MKTCFG | KEY_VALUE2 | Varchar2 50 | Varchar2 100 |
| F1_MKTCFG | KEY_VALUE3 | Varchar2 50 | Varchar2 100 |
| F1_MKTCFG | KEY_VALUE4 | Varchar2 50 | Varchar2 100 |
| F1_MKTCFG | KEY_VALUE5 | Varchar2 50 | Varchar2 100 |
| F1_MKTMSG_IN_EXT_REF | EXT_REF_VAL | Char 36 | Char 100 |
| F1_MKTMSG_OUT_EXT_REF | EXT_REF_VAL | Char 36 | Char 100 |
New Indexes
| Table_Name | Index_Name | Notes |
|---|---|---|
| CI_TD_ENTRY | XT039S10 | |
| CI_TD_ENTRY | XT039S11 | |
| CI_BATCH_JOB | XT240S3 | |
| F1T768S3 | F1_MKTPROC | Delivered in a previous release as a hot fix in 25.10 MP 5.3.1 (Bug 38851941) |
| F1T064S3 | F1_GEN_PROC | Delivered in a previous release as a hot fix in 25.10 MP 5.3.1 (Bug 38851751) |