Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 22C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_TMPL_WO_DOCUMENT
Template Work Order Document
Child table of Template Work Order table, used to store documents related to template work orders.
W1_WO_DOCUMENT
Work Order Document
Child table of Work Order table, used to store documents related to work orders.
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACT_RECON_PROP_UNIT
CU_ID
CHAR
48
W1_ASSET
FIXED_ASSET_NUM
VARCHAR2
240
W1_CU
FIXED_ASSET_NUM
VARCHAR2
240
W1_PROJECT
ERP_CAPITAL_PRJ_FLG
CHAR
16
W1_TMPL_WO_DOCUMENT
ATTACHMENT_ID
CHAR
56
W1_TMPL_WO_DOCUMENT
CRE_DTTM
DATE
7
W1_TMPL_WO_DOCUMENT
DOCUMENT_ID
CHAR
48
W1_TMPL_WO_DOCUMENT
TMPL_WO_ID
CHAR
48
W1_TMPL_WO_DOCUMENT
USER_ID
CHAR
32
W1_TMPL_WO_DOCUMENT
VERSION
NUMBER
22
W1_WORK_LOC
CITY
VARCHAR2
360
W1_WORK_LOC
W1_CITY_UPR
VARCHAR2
360
W1_WORK_REQ
CITY
VARCHAR2
360
W1_WORK_REQ
W1_CITY_UPR
VARCHAR2
360
W1_WO_DOCUMENT
ATTACHMENT_ID
CHAR
56
W1_WO_DOCUMENT
CRE_DTTM
DATE
7
W1_WO_DOCUMENT
DOCUMENT_ID
CHAR
48
W1_WO_DOCUMENT
USER_ID
CHAR
32
W1_WO_DOCUMENT
VERSION
NUMBER
22
W1_WO_DOCUMENT
WO_ID
CHAR
56
Modified Columns
 
Table_Name
Column_Name
New Data Type
Old Length
New Length
W1_WORK_LOC
CITY
VARCHAR2
30
90
W1_WORK_LOC
W1_CITY_UPR
VARCHAR2
30
90
W1_WORK_REQ
CITY
VARCHAR2
30
90
W1_WORK_REQ
W1_CITY_UPR
VARCHAR2
30
90
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_TMPL_WO_DOCUMENT
W1T970P0
ATTACHMENT_ID
W1_TMPL_WO_DOCUMENT
W1T970P0
DOCUMENT_ID
W1_TMPL_WO_DOCUMENT
W1T970P0
TMPL_WO_ID
W1_WO_DOCUMENT
W1T969P0
ATTACHMENT_ID
W1_WO_DOCUMENT
W1T969P0
DOCUMENT_ID
W1_WO_DOCUMENT
W1T969P0
WO_ID