Upgrading from Oracle Utilities Market Settlements Management V2.4.0.0.0 to V2.5.0.0.0
New Tables
Table_Name
D1_ACTIVITY_TYPE_DIV
D1_DVC_TYPE_VALID_DVC_CHAR
D1_SP_TYPE_DISCONNECT_LOCATION
D1_SP_TYPE_DIV
Added Columns (View)
Table_Name
Column_Name
D1_ON_DOE_VW
ADHOC_CHAR_VAL
D1_ON_DO_VW
ADHOC_CHAR_VAL
D1_ON_DVC_CFG_VW
ADHOC_CHAR_VAL
D1_ON_IE_VW
ADHOC_CHAR_VAL
New Indexes
Table_Name
Index_Name
D1_ACTIVITY_TYPE_DIV
D1C636P0
D1_DVC_TYPE_VALID_DVC_CHAR
D1C634P0
D1_DVC_TYPE_VALID_DVC_CHAR
D1C634S1
D1_SP_REL
D1M317S1
D1_SP_TYPE_DISCONNECT_LOCATION
D1C637P0
D1_SP_TYPE_DIV
D1C635P0
Columns Added (Tables)
Table_Name
Column_Name
Data_Type
D1_ACTIVITY
RESCHEDULE_REASON
VARCHAR2(254)
D1_ACTIVITY_ADJ_TYPE
D1_SP_TYPE_CD
VARCHAR2(30)
D1_ACTIVITY_TYPE
THROTTLE_OPT_FLG
CHAR(4)
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_CD
CHAR(8)
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_NBR
NUMBER(10,0)
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_RERUN_
NBR
NUMBER(10,0)
D1_SVC_TYPE
STD_SVC_TYPE_FLG
CHAR(4)
Columns Deleted (Tables)
Table_Name
Column_Name
D1_ACTIVITY_ADJ_TYPE
BUS_OBJ_CD
Updated Columns (Tables)
Table_Name
Column_Name
From
To
D1_SP
D1_LS_SL_DESCR
NOT NULL
NULL