4 Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 26.10 release of Oracle Utilities cloud services. This includes:
New Tables
| Table | Name | Description |
|---|---|---|
| W1_ASSET_TYPE_MEASUREMENT_TYPE | Asset Type Measurement Type | Used to define types of measurements used with asset types. |
New Columns
| Table_Name | Column_Name | Data Type | Length |
|---|---|---|---|
| W1_BC_LINE | BC_LINE_SEQ_NUM | NUMBER | 5,0 |
| W1_ASSET_TYPE_MEASUREMENT_TYPE | ASSET_TYPE_CD | VARCHAR2 | 30 |
| W1_ASSET_TYPE_MEASUREMENT_TYPE | MEASUREMENT_TYPE_CD | VARCHAR2 | 30 |
| W1_ASSET_TYPE_MEASUREMENT_TYPE | VERSION | NUMBER | 5,0 |
New Indexes
| Table_Name | Index_Name |
|---|---|
| W1_ASSET_TYPE_MEASUREMENT_TYPE | W1C983P0 |
| W1_INVOICE_LINE | W1M595S5 |
| W1_PROJECT | W1M601S13 |
| W1_TIMESHEET_DETAIL | W1M595S5 |