Customer Cloud Service Database Changes
This chapter provides lists of database changes in the 21C release of Oracle Utilities Customer Cloud Service. This includes:
Note: Database changes in this release of Oracle Utilities Customer Cloud Service also apply to the 21C releases of the following cloud services:
• Oracle Utilities Billing Cloud Service
• Oracle Utilities Customer Care and Billing Cloud Service
• Oracle Utilities Rate Cloud Service
New Tables
 
Table_Name
C1_BI_FTGL_MONTHLY_A
C1_BI_FT_MONTHLY_A
ERR$_C1_BI_FTGL_MONTHLY_A
ERR$_C1_BI_FT_MONTHLY_A
New Indexes
 
Table_Name
Index_Name
C1_BI_FTGL_MONTHLY_A
C1T159P0
C1_BI_FT_MONTHLY_A
C1T158P0
C1_MKTMSG_CHG_REL_OBJ
C1T138S1
C1_MKTMSG_PAY_REL_OBJ
C1T132S1
C1_MKTMSG_USG_REL_OBJ
C1T126S1
C1_MKT_RP
C1M009S7
C1_MKT_RP_REL_OBJ
C1M014S1
C1_PER_SS_PAYOPT
C1M007S2
C1_PA_RQST
C1T020S2
Deleted Indexes
 
Table_Name
Index_Name
F1_PROC_STORE
C1T747S1
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
C1_BI_BILL_VW
ILM_DT
DATE
10
C1_BI_BILL_VW
ILM_ARCH_SW
CHAR
1
C1_BI_BILLED_USAGE_VW
ILM_DT
DATE
10
C1_BI_BILLED_USAGE_VW
ILM_ARCH_SW
CHAR
1
C1_BI_FTGL_MONTHLY_A
ACCOUNTING_MONTH
NUMBER
6
C1_BI_FTGL_MONTHLY_A
BEGIN_ACCOUNTING_DT
DATE
10
C1_BI_FTGL_MONTHLY_A
CIS_DIVISION
CHAR
5
C1_BI_FTGL_MONTHLY_A
CUST_CL_CD
CHAR
8
C1_BI_FTGL_MONTHLY_A
DST_ID
CHAR
10
C1_BI_FTGL_MONTHLY_A
FT_GL_AMT
NUMBER
15
C1_BI_FTGL_MONTHLY_A
FT_GL_CNT
NUMBER
10
C1_BI_FTGL_MONTHLY_A
FT_GL_CREDIT_AMT
NUMBER
15
C1_BI_FTGL_MONTHLY_A
FT_GL_DEBIT_AMT
NUMBER
15
C1_BI_FTGL_MONTHLY_A
FT_GL_REV_AMT
NUMBER
15
C1_BI_FTGL_MONTHLY_A
FT_GL_TAX_AMT
NUMBER
15
C1_BI_FTGL_MONTHLY_A
FT_TYPE_FLG
CHAR
2
C1_BI_FTGL_MONTHLY_A
GL_ACCT
VARC
254
C1_BI_FTGL_MONTHLY_A
GL_DIVISION
CHAR
5
C1_BI_FTGL_MONTHLY_A
RS_CD
CHAR
8
C1_BI_FTGL_MONTHLY_A
SA_TYPE_CD
CHAR
8
C1_BI_FTGL_MONTHLY_A
STATISTIC_AMT
NUMBER
15
C1_BI_FT_MONTHLY_A
ACCOUNTING_MONTH
NUMBER
6
C1_BI_FT_MONTHLY_A
BEGIN_ACCOUNTING_DT
DATE
10
C1_BI_FT_MONTHLY_A
CIS_DIVISION
CHAR
5
C1_BI_FT_MONTHLY_A
CUR_AMT
NUMBER
15
C1_BI_FT_MONTHLY_A
CUST_CL_CD
CHAR
8
C1_BI_FT_MONTHLY_A
FT_CNT
NUMBER
10
C1_BI_FT_MONTHLY_A
FT_GL_REV_AMT
NUMBER
15
C1_BI_FT_MONTHLY_A
FT_GL_TAX_AMT
NUMBER
15
C1_BI_FT_MONTHLY_A
FT_OTHER_AMT
NUMBER
15
C1_BI_FT_MONTHLY_A
FT_TYPE_FLG
CHAR
2
C1_BI_FT_MONTHLY_A
GL_DIVISION
CHAR
5
C1_BI_FT_MONTHLY_A
RS_CD
CHAR
8
C1_BI_FT_MONTHLY_A
SA_TYPE_CD
CHAR
8
C1_BI_FT_MONTHLY_A
TOT_AMT
NUMBER
15
C1_CS_REQ
C1_CREATED_BY_USER
CHAR
8
C1_CS_REQ
C1_FINAL_DTTM
DATE
26
C1_CS_REQ
C1_FINAL_USER
CHAR
8
C1_PER_CONTDET
CONTACT_EXT_ID
VARC
254
C1_PER_SS_PAYOPT
PER_PAY_OPT_NAME
VARC
254
CI_APAY_SRC
PRENOTE_TENDER_TYPE_CD
CHAR
4
CI_CC_TYPE
BUS_OBJ_CD
CHAR
30
X1_BI_CASE_VW
ILM_DT
DATE
10
X1_BI_CASE_VW
ILM_ARCH_SW
CHAR
1
Dropped Columns
 
Table_Name
Column_Name
CI_APAY_CLR_STG
PRENOTE_SW
Other Database Changes
This release of Oracle Utilities Customer Cloud Service also includes the following database changes: