Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 23B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
D1_DYN_OPT_USG_GRP*
Dynamic Option Usage Group
This table is used to define relationships between a Dynamic Option and a Usage Calculation Group. When used with Oracle Utilities Digital Asset Cloud Service this is used to define relationships between Programs and Event Settlement Calculation Groups related to the Customer Settlement feature introduced in release 23B.
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
D1_DYN_OPT_USG_GRP*
D1M652P0
* Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DYN_OPT_EVENT*
DYN_OPT_EXT_EVT_ID_VALUE
VARCHAR2
120
D1_SP*
D1_SERVICE_AREA_CD
VARCHAR2
30
D1_USAGE*
EVT_SETT_REQ_TYPE_FLG
CHAR
4
D1_USAGE_PERIOD_SQ*
D1_AMOUNT
NUMBER
15,2
D1_USAGE_PERIOD_SQ*
DYN_OPT_EVENT_ID
CHAR
14
D1_USAGE_PERIOD_SQ*
D1_QUANTITY1
CHAR
14
D1_USAGE_PERIOD_SQ*
D1_QUANTITY2
CHAR
14
D1_USAGE_PERIOD_SQ*
D1_QUANTITY3
CHAR
14
D1_USAGE_PERIOD_SQ*
D1_QUANTITY4
CHAR
14
D1_USAGE_PERIOD_SQ*
D1_QUANTITY5
CHAR
14
D1_USAGE_PERIOD_SQ*
LINE_DESCR
VARCHAR2
254
D1_USAGE_PERIOD_SQ*
D1_CURRENCY_CD
CHAR
3
D1_USAGE_PERIOD_SQ*
DYN_OPT_ID
CHAR
12
D1_USAGE_PERIOD_SQ_DATA*
D1_PRICE
NUMBER
19,8
D1_USAGE_PERIOD_SQ_DATA*
D1_AMOUNT
NUMBER
15,2
D1_USG_RULE_L*
LINE_DESCR
VARCHAR2
254
D1_US_TYPE*
EVT_SETT_BO_CD
CHAR
30
* Used by Digital Asset Cloud Service
Updated Columns
 
Table_Name
Column_Name
Old Length
New Length
D1_USAGE_SCALAR_DTL
USE_PERCENT
NUMBER(3,0)
NUMBER(9,6)
D1_US_SP
USE_PERCENT
NUMBER(3,0)
NUMBER(9,6)