Application Framework Database Changes
This chapter provides lists of database changes in Oracle Utilities Application Framework included with the 23B release of Oracle Utilities cloud services. This includes:
New Columns
Table_Name
Column_Name
Data Type
Data Length
F1_MIGR_REQ_INSTR
ENTITY_TAG
Varchar2
30
F1_TD_ENTRY
TD_SUB_STATUS_FLG
Flag
4
F1_TD_LOG
TD_LOG_STATUS_FLG
Flag
4
CI_TD_ENTRY
RTE_BATCH_CD
Character
8
CI_TD_ENTRY
RTE_BATCH_NBR
Number
10
Updated Columns
Table_Name
Column_Name
Old Data Type
New Data Type
F1_CRYPTO_KEY
PUBLIC_KEY
VARCHAR2(4000)
VARCHAR2(32767)
CI_MD_IDX
IDX_CD
CHAR(12)
VARCHAR2 (128)
CI_MD_IDX_FLD
IDX_CD
CHAR(12)
VARCHAR2 (128)
 
Updated Primary Key
Table_Name
Old Fields
New Fields
F1_WEB_CAT_INCL_SVC
"WEB_SVC_CAT_CD", "SEQNO"
"WEB_SVC_CAT_CD", "SEQNO", "OWNER_FLG"
New Indexes
Table
Index
F1_TSPACE_ENTRY
FT001S1 (TSPACE_NAME, TSPACE_ENTRY_TY, TSPACE_ENTRY_ID)
F1_MKTMSG_OUT
F1T782S3 (OUTMSG_ID)
F1_MKTMSG_OUT
F1T782S4 (MKTPROC_ID)
F1_MKTMSG_OUT
F1T782S5 (MKT_REG_NBR
F1_BATCH_RUN_ANALYTICS_SNAP
F1T301S02 (END_DTTM, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR)
F1_BATCH_RUN_ANALYTICS_SNAP
F1T301S03(BATCH_BUS_DT, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR)
F1_BATCH_THD_ANALYTICS_SNAP
F1T401S02 (BATCH_BUS_DT, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR, BATCH_THREAD_NBR)
F1_BATCH_THD_ANALYTICS_SNAP
F1T401S03 (START_DTTM, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR, BATCH_THREAD_NBR)
CI_TD_ENTRY
XT039S9 (RTE_BATCH_CD,RTE_BATCH_NBR,ENTRY_STATUS_FLG)
F1_OUTMSG
FT010S2 (NT_XID_CD, CRE_DTTM, OUTMSG_STATUS_FLG)
 
Updated Views
 
View_Name
Changes
CI_TD_ENTRY_OPEN_VW
 
New Field: TD_SUB_STATUS_FLG
F1_BATCH_RUN_HIST_VW
Used with New Batch Analytics Views feature.
F1_BATCH_THD_HIST_VW
Used with New Batch Analytics Views feature.
F1_BATCH_CONF_VW
Used with New Batch Analytics Views feature.
F1_BATCH_THD_CAP_VW
Used with New Batch Analytics Views feature.