Customer-Related Database Changes
This chapter provides lists of customer-related database changes in the 24B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
C1_COLL_PROC_ARS_HIST
Collection Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for collection processes.
C1_COLL_PROC_SA_ARS_HIST
Collection Process SA Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for collection processes.
C1_OD_PROC_ARS_HIST
Overdue Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for overdue processes.
C1_SEV_PROC_ARS_HIST
Severance Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for severance processes.
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
C1_COLL_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_COLL_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_COLL_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_COLL_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
COLL_PROC_ID
CHAR
10
C1_COLL_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_COLL_PROC_ARS_HIST
DEBT_CLASS_SW
CHAR
1
C1_COLL_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_COLL_PROC_ARS_HIST
ILM_DT
DATE
10
C1_COLL_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_COLL_PROC_ARS_HIST
UNADJ_ARS_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
VERSION
NUMB
5,2
C1_COLL_PROC_SA_ARS_HIST
ARS_AMT
NUMB
15,2
C1_COLL_PROC_SA_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_COLL_PROC_SA_ARS_HIST
COLL_PROC_ID
CHAR
10
C1_COLL_PROC_SA_ARS_HIST
SA_ID
CHAR
10
C1_COLL_PROC_SA_ARS_HIST
SEQNO
NUMB
5,0
C1_COLL_PROC_SA_ARS_HIST
VERSION
NUMB
5,0
C1_OD_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_OD_PROC_ARS_HIST
ARS_AMT_INDT_SW
CHAR
1
C1_OD_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_OD_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_OD_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_OD_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_OD_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_OD_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_OD_PROC_ARS_HIST
ILM_DT
DATE
10
C1_OD_PROC_ARS_HIST
OD_PROC_ID
CHAR
12
C1_OD_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_OD_PROC_ARS_HIST
VERSION
NUMB
5,0
C1_RC_CALC_LN_GTT
C1_PERCENTAGE
NUMB
11,8
C1_RC_CALC_LN_GTT
C1_UNIT_PRICE
NUMB
19,8
C1_RC_CALC_LN_GTT
CHARGE
NUMB
19,8
C1_RC_CALC_LN_GTT
SEASON_END_DT
DATE
10
C1_RC_CALC_LN_GTT
SEASON_START_DT
DATE
10
C1_RC_CALC_LN_GTT
STEP_SQ_HIGH_VAL
NUMB
18,4
C1_RC_CALC_LN_GTT
STEP_SQ_LOW_VAL
NUMB
18,4
C1_RC_CALC_LN_GTT
STEP_SQ_SEQ
NUMB
5,0
C1_RC_CALC_LN_GTT
VAL_PERIOD_END_DT
DATE
10
C1_RC_CALC_LN_GTT
VAL_PERIOD_START_DT
DATE
10
C1_SEV_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_SEV_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_SEV_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_SEV_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_SEV_PROC_ARS_HIST
DEBT_CLASS_SW
CHAR
1
C1_SEV_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_SEV_PROC_ARS_HIST
ILM_DT
DATE
10
C1_SEV_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_SEV_PROC_ARS_HIST
SEV_PROC_ID
CHAR
10
C1_SEV_PROC_ARS_HIST
UNADJ_ARS_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
VERSION
NUMB
5,0
New Indexes
 
Table_Name
Index_Name
C1_COLL_PROC_ARS_HIST
C1T164P0
C1_COLL_PROC_SA_ARS_HIST
C1T165P0
C1_COLL_PROC_SA_ARS_HIST
C1T165S1
C1_OD_PROC_ARS_HIST
C1T167P0
C1_SEV_PROC_ARS_HIST
C1T166P0
CI_CC_LOG
XT281S2
C1_OFFCYC_BGEN_BSEG
C1T160S1
Updated Columns
 
Table_Name
Column_Name
From
To
C1_MKTMSG_CHG_DTL
MKT_PRICE_PER_UNIT
NUMB 15,2
NUMB 19,6