Upgrading from Oracle Utilities Market Settlements Management V2.4.0.0.2 to V2.5.0.0.0
New Tables
Table_Name
D1_ACTIVITY_TYPE_DIV
D1_SP_TYPE_DISCONNECT_LOCATION
D1_SP_TYPE_DIV
New Indexes
Table_Name
Index_Name
D1_ACTIVITY_TYPE_DIV
D1C636P0
D1_SP_TYPE_DISCONNECT_LOCATION
D1C637P0
D1_SP_TYPE_DIV
D1C635P0
New Columns
Table_Name
Column_Name
Data Type
D1_ACTIVITY
RESCHEDULE_REASON
VARCHAR2
D1_ACTIVITY_ADJ_TYPE
D1_SP_TYPE_CD
VARCHAR2
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_CD
CHAR
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_NBR
NUMBER
D1_AGG_GROUP_RUN_MC_SET
SCAN_BATCH_RERUN_NBR
NUMBER
Deleted Columns
Table_Name
Column_Name
D1_ACTIVITY_ADJ_TYPE
BUS_OBJ_CD