Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 23B release of Oracle Utilities cloud services. This includes:
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACT_RECON_COST_CENTER
W1_AMOUNT
NUMBER
18,7
W1_ACT_RECON_PROP_UNIT
COST_CENTER_CD
VARCHAR2
30
W1_ACT_RECON_PROP_UNIT
CU_USAGE_CD
VARCHAR2
30
W1_ASSET_TYPE
ASSET_NO_CAL_PREFIX_FLG
CHAR
4
W1_ASSET_TYPE
ASSET_NO_GEN_FLG
CHAR
4
W1_ASSET_TYPE
ASSET_NO_PREFIX
CHAR
4
W1_ASSET_TYPE
ASSET_NO_SEQ_LEN
NUMBER
2
W1_ASSET_TYPE
BADGE_NO_CAL_PREFIX_FLG
CHAR
4
W1_ASSET_TYPE
BADGE_NO_GEN_FLG
CHAR
4
W1_ASSET_TYPE
BADGE_NO_PREFIX
CHAR
4
W1_ASSET_TYPE
BADGE_NO_SEQ_LEN
NUMBER
2
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_ODC_DTL
W1T340S3
ACT_RESRC_REQMT_ID
W1_PO_LINE
W1T418S9
ACT_RESRC_REQMT_ID
W1_TIMESHEET_DETAIL
W1M595S4
ACT_RESRC_REQMT_ID