Application Framework Database Changes
This chapter provides lists of database changes in Oracle Utilities Application Framework included with the 22C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
CI_MD_FLD_ADDTL
Field Additional Attributes
This is an extension of the CI_MD_FLD table and is used to capture additional information about a field.
F1_MO_UPD_BACKUP
Entity Key Backup Table
This table is part of generalized export batch it is used to keep a backup of all entity keys exported by a specific batch run number
F1_MIGR_OBJ_DATA
Migration Object Data
This is a child table to store Migration Object Content that is currently stored directly on the migration object itself
F1_BATCH_RUN_ANALYTICS_SNAP*
Batch Run Analytics Snapshot
Reserved for future use.
F1_BATCH_THD_ANALYTICS_SNAP*
Batch Thread Analytics Snapshot
Reserved for future use.
*Future use only.
Dropped Tables
 
Table
Comments
F1_CRYPTO_KEY_RING_LINK
This table was created in a previous release in anticipation of a future feature. It was not used in any product functionality. Subsequently the design changed such that this table is not longer needed.
New Indexes
 
Table_Name
Index_Name
F1_MIGR_OBJ
F1T188S3
F1_SVC_TASK
F1C474S3
F1_MKTMSG_IN
F1T759S3
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
F1_MIGR_DATA_ST
REDACT_OPT_FLG
CHAR
4
F1_MIGR_DATA_ST
INSERT_ONLY_FLG
CHAR
4
F1_MIGR_DATA_ST
BULK_IMPORT_FLG
CHAR
4
F1_MIGR_OBJ
ENTITIES_CNT
NUMBER
6
F1_MIGR_OBJ_SQL
PK_VALUE1
VARCHAR2
254
F1_MIGR_OBJ_SQL
PK_VALUE2
VARCHAR2
254
F1_MIGR_OBJ_SQL
PK_VALUE3
VARCHAR2
254
F1_MIGR_OBJ_SQL
PK_VALUE4
VARCHAR2
254
F1_MIGR_OBJ_SQL
PK_VALUE5
VARCHAR2
254
SC_APP_SERVICE_L
DESCRLONG
VARCHAR2
4000
F1_CRYPTO_KEY_RING
KEY_RING_CAT_FLG
CHAR
4
CI_CURRENCY_CD
EXT_CURRENCY_CD
CHAR
36
F1_ETL_MP_CTRL
F1_BI_TYPE_FLD
CHAR
30
F1_ETL_MP_CTRL
F1_BI_TYPE_VALUE
CHAR
4
Modified Columns
 
Table_Name
Column_Name
From
To
F1_CRYPTO_KEY
PUBLIC_KEY
VARCHAR (2000)
VARCHAR (4000)
Modified Views
 
View_Name
Changes
CI_TD_ENTRY_OPEN_VW
/*+ no_unnest */ hint added