Customer-Related Database Changes

Customer-Related Database Changes

This chapter provides lists of customer-related database changes in the 23B release of Oracle Utilities cloud services. This includes:

• New Columns

• Dropped Columns

• Updated Columns

• New Columns

New Columns

Table_Name	Column_Name	Data Type	Data Length
C1_CS_REQ_TYPE_REL_UPD	REL_UPD_RESPONSE_VALUE	Varchar2	254
C1_CS_REQ_TYPE_REL_UPD	UPDATE_VALUE	Varchar2	254

Dropped Columns

Table_Name	Column_Name
C1_CS_REQ_TYPE_QUESTION	C1_ANSWER_CD
C1_CS_REQ_TYPE_SVC_CRIT	START_SA_OVRD_SW
C1_CS_REQ_TYPE_SVC_CRIT	STOP_SA_OVRD_SW
C1_QUESTION_ANSWER	C1_ANSWER_STYLE_FLG
C1_QUESTION_ANSWER	CHAR_TYPE_CD
C1_CS_REQ_TYPE_QUESTION	C1_ANSWER_CD

Updated Columns

Table_Name	Column_Name	Old Data Type	New Data Type
C1_CS_REQ_TYPE_QUESTION	QUESTION_APPL_FLG	NULLABLE	NOT NULLABLE
C1_CS_REQ_SA_SP	USE_PCT	NUMBER(3,0)	NUMBER(5,2)
C1_RC_READ_GTT	USE_PCT	NUMBER(3,0)	NUMBER(5,2)
CI_BCHG_READ	USE_PCT	NUMBER(3,0)	NUMBER(5,2)
CI_BCHG_UP_READ	USE_PCT	NUMBER(3,0)	NUMBER(5,2)
CI_BSEG_READ	USE_PCT	NUMBER(3,0)	NUMBER(5,2)
CI_SA_SP	USE_PCT	NUMBER(3,0)	NUMBER(5,2)

New Indexes

Table_Name	Index_Name
CI_PREM	XM174S8