Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 24C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_BC_LINE_NOTE
Blanket Contract Line Note
Used to capture notes for blanket contract lines
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_BC_LINE_NOTE
BC_LINE_ID
CHAR
14
W1_BC_LINE_NOTE
NOTE_DTTM
DATE
7
W1_BC_LINE_NOTE
NOTE_TYPE_FLG
CHAR
4
W1_BC_LINE_NOTE
NOTE_VALUE
VARCHAR2
4000
W1_BC_LINE_NOTE
SEQNO
NUMBER
22
W1_BC_LINE_NOTE
USER_ID
CHAR
8
W1_BC_LINE_NOTE
VERSION
NUMBER
22
W1_TIMEKEEPER
OWNING_ACCESS_GRP_CD
CHAR
12
New Indexes
 
Table_Name
Index_Name
W1_ACTIVITY
W1T244S21
W1_BC_LINE_NOTE
W1T976P0
W1_BC_LINE_NOTE
W1T976P0
W1_DOCUMENT
W1M577S2
W1_MAT_RET_LINE
W1T400S2