Work and Asset Cloud Service Database Changes
This chapter provides lists of database changes in the 21B release of Oracle Utilities Work and Asset Cloud Service. This includes:
Note: Database changes in this release of Oracle Utilities Work and Asset Cloud Service also apply to the 21C release of Oracle Utilities Operational Device Cloud Service.
New Tables
 
Table_Name
W1_EU_TIMESHEET
W1_VENDOR_LOC_PAYTO_LOC
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_EU
AUTO_TS_CREATION_FLG
CHAR
4
W1_EU_TIMESHEET
EU_DT
DATE
7
W1_EU_TIMESHEET
EU_ID
CHAR
12
W1_EU_TIMESHEET
HOURS
NUMBER
22
W1_EU_TIMESHEET
VERSION
NUMBER
22
W1_TIMESHEET_DETAIL
EU_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
PAY_TO_LOC
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VENDOR_LOC_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VERSION
NUMBER
22
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_EU_TIMESHEET
W1M961P0
EU_DT
W1_EU_TIMESHEET
W1M961P0
EU_ID
W1_NODE
W1M205S11
BUILDING
W1_PI_CNT_MST
W1T324S3
STOCK_ITEM_DTL_ID
W1_TIMESHEET_DETAIL
W1M595S3
EU_ID
W1_VENDOR_LOC_PAYTO_LOC
W1M955P0
PAY_TO_LOC
W1_VENDOR_LOC_PAYTO_LOC
W1M955P0
VENDOR_LOC_ID
W1_WO
W1T232S14
PARENT_WO_ID
Other Database Changes
This release of Oracle Utilities Work and Asset Cloud Service also includes the following database changes: