2 Customer-Related Database Changes

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

New Tables

Table Name Description
C1_NTF_PREF_SA SA Communication Preference Used to capture service agreement communication preferences
C1_NTF_PREF_SA_K SA Communication Preference Key Used to capture the relationship between service agreement communication preferences and an environment
C1_NTF_PREF_SA_CHAR SA Communication Preference Characteristic Used to store characteristics related to service agreement communication preferences
C1_NTF_PREF_SA_LOG SA Communication Preference Log Used to capture log details for service agreement communication preferences
C1_NTF_PREF_SA_LOG_PARM SA Communication Preference Log Parameters Used to capture log parameters for service agreement communication preferences

New Columns

Table_Name Column_Name Data Type Length
C1_NTF_PREF_SA BO_DATA_AREA CLOB 1073741824
C1_NTF_PREF_SA BO_STATUS_CD CHAR 12
C1_NTF_PREF_SA BUS_OBJ_CD CHAR 30
C1_NTF_PREF_SA C1_CONTACT_ID CHAR 10
C1_NTF_PREF_SA C1_SS_DELIVERY_TYPE CHAR 4
C1_NTF_PREF_SA F1_SVC_TASK_ID CHAR 14
C1_NTF_PREF_SA ILM_ARCH_SW CHAR 1
C1_NTF_PREF_SA ILM_DT DATE 10
C1_NTF_PREF_SA NPRF_ACT_INACT_FLG CHAR 4
C1_NTF_PREF_SA NPRF_OPT_OUT_FLG CHAR 4
C1_NTF_PREF_SA NTF_PREF_SA_ID CHAR 14
C1_NTF_PREF_SA NTF_TYPE_CD VARCHAR 30
C1_NTF_PREF_SA SA_ID CHAR 10
C1_NTF_PREF_SA SP_ID CHAR 10
C1_NTF_PREF_SA STATUS_UPD_DTTM DTTM 26
C1_NTF_PREF_SA VERSION NUMBER 5,0
C1_NTF_PREF_SA_CHAR ADHOC_CHAR_VAL VARCHAR 254
C1_NTF_PREF_SA_CHAR CHAR_TYPE_CD CHAR 8
C1_NTF_PREF_SA_CHAR CHAR_VAL CHAR 16
C1_NTF_PREF_SA_CHAR CHAR_VAL_FK1 VARCHAR 50
C1_NTF_PREF_SA_CHAR CHAR_VAL_FK2 VARCHAR 50
C1_NTF_PREF_SA_CHAR CHAR_VAL_FK3 VARCHAR 50
C1_NTF_PREF_SA_CHAR CHAR_VAL_FK4 VARCHAR 50
C1_NTF_PREF_SA_CHAR CHAR_VAL_FK5 VARCHAR 50
C1_NTF_PREF_SA_CHAR NTF_PREF_SA_ID CHAR 14
C1_NTF_PREF_SA_CHAR SEQ_NUM NUMBER 3,0
C1_NTF_PREF_SA_CHAR SRCH_CHAR_VAL VARCHAR 50
C1_NTF_PREF_SA_CHAR VERSION NUMBER 5,0
C1_NTF_PREF_SA_K ENV_ID NUMBER 6,0
C1_NTF_PREF_SA_K NTF_PREF_SA_ID CHAR 14
C1_NTF_PREF_SA_LOG ADHOC_CHAR_VAL VARCHAR 254
C1_NTF_PREF_SA_LOG BO_STATUS_CD CHAR 12
C1_NTF_PREF_SA_LOG BO_STATUS_REASON_CD VARCHAR 30
C1_NTF_PREF_SA_LOG CHAR_TYPE_CD CHAR 8
C1_NTF_PREF_SA_LOG CHAR_VAL CHAR 16
C1_NTF_PREF_SA_LOG CHAR_VAL_FK1 VARCHAR 50
C1_NTF_PREF_SA_LOG CHAR_VAL_FK2 VARCHAR 50
C1_NTF_PREF_SA_LOG CHAR_VAL_FK3 VARCHAR 50
C1_NTF_PREF_SA_LOG CHAR_VAL_FK4 VARCHAR 50
C1_NTF_PREF_SA_LOG CHAR_VAL_FK5 VARCHAR 50
C1_NTF_PREF_SA_LOG DESCRLONG VARCHAR 4000
C1_NTF_PREF_SA_LOG LOG_DTTM DTTM 26
C1_NTF_PREF_SA_LOG LOG_ENTRY_TYPE_FLG CHAR 4
C1_NTF_PREF_SA_LOG MESSAGE_CAT_NBR NUMBER 5,0
C1_NTF_PREF_SA_LOG MESSAGE_NBR NUMBER 5,0
C1_NTF_PREF_SA_LOG NTF_PREF_SA_ID CHAR 14
C1_NTF_PREF_SA_LOG SEQNO NUMBER 5,0
C1_NTF_PREF_SA_LOG USER_ID CHAR 8
C1_NTF_PREF_SA_LOG VERSION NUMBER 5,0
C1_NTF_PREF_SA_LOG_PARM MSG_PARM_TYP_FLG CHAR 4
C1_NTF_PREF_SA_LOG_PARM MSG_PARM_VAL VARCHAR 2000
C1_NTF_PREF_SA_LOG_PARM NTF_PREF_SA_ID CHAR 14
C1_NTF_PREF_SA_LOG_PARM PARM_SEQ NUMBER 3,0
C1_NTF_PREF_SA_LOG_PARM SEQNO NUMBER 5,0
C1_NTF_PREF_SA_LOG_PARM VERSION NUMBER 5,0
C1_NTF_TYPE NTF_LEVEL_FLG CHAR 4
C1_NTF_TYPE SP_REQ_SW CHAR 1

Updated Columns

Table_Name Column_Name Old New
C1_PA_RQST PA_RQST_NBR_INSTALLMENT NUMBER (3,0) NUMBER (5,0)

New Indexes

Table_Name Index_Name
CI_SA_SP XM206S5
CI_SA XM199S5
CI_BSEG XT048S4
CI_FA XT094S6
CI_SP_MTR_HIST XT232S3
C1_NTF_PREF_SA C1T172P0
C1_NTF_PREF_SA C1T172S1
C1_NTF_PREF_SA C1T172S2
C1_NTF_PREF_SA C1T172S3
C1_NTF_PREF_SA C1T172S4
C1_NTF_PREF_SA C1T172S5
C1_NTF_PREF_SA_CHAR C1T174P0
C1_NTF_PREF_SA_CHAR C1T174S1
C1_NTF_PREF_SA_K C1T173P0
C1_NTF_PREF_SA_LOG C1T175P0
C1_NTF_PREF_SA_LOG C1T175S1
C1_NTF_PREF_SA_LOG C1T175S2
C1_NTF_PREF_SA_LOG_PARM C1T176P0

Updated Views

View_Name Changes
C1_SYRQ_PREM_ALL_VW  
C1_SYRQ_PREM_NF_VW