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_OUTMSG_TYPE_FLDTEXT | Outbound Message Type Help Text Field | Used to store help text for outbound message types. |
New Columns
| Table_Name | Column_Name | Data Type | Length |
|---|---|---|---|
| F1_INSIGHT_TYPE_USER_ACT | ACCESS_MODE | CHAR | 16 |
| F1_INSIGHT_TYPE_USER_ACT | APP_SVC_ID | CHAR | 80 |
| F1_OUTMSG_TYPE_FLDTEXT | EXAMPLE_TEXT | VARCHAR2 | 16000 |
| F1_OUTMSG_TYPE_FLDTEXT | FLD_NAME | CHAR | 120 |
| F1_OUTMSG_TYPE_FLDTEXT | OUTMSG_HELP_TXT | VARCHAR2 | 16000 |
| F1_OUTMSG_TYPE_FLDTEXT | OUTMSG_TYPE_CD | CHAR | 48 |
| F1_OUTMSG_TYPE_FLDTEXT | OWNER_FLG | CHAR | 16 |
| F1_OUTMSG_TYPE_FLDTEXT | TEXT_NAME | CHAR | 120 |
| F1_OUTMSG_TYPE_FLDTEXT | VERSION | NUMBER | 22 |
New Indexes
| Table_Name | Index_Name | Notes |
|---|---|---|
| F1_SVC_TASK | F1C474S4 | CRE_DTTM,F1_STASK_TYPE_CD,F1_SVC_TASK_ID |
Updated Indexes
| Table_Name | Index_Name | Notes |
|---|---|---|
| F1_SVC_TASK | F1C474S1 | Added F1_SVC_TASK_ID |
| F1_SVC_TASK | F1C474S2 | Added CRE_DTTM, F1_SVC_TASK_ID |