Upgrades to Oracle Utilities Application Framework v4.3.0.6.0
New Tables
Table
Description
Table Type
F1_ATTACHMENT_K
Attachment Key
Transaction
F1_CRYPTO_KEY
Key Ring Key
Admin
F1_CRYPTO_KEY_RING
Key Ring
Admin
F1_CRYPTO_KEY_RING_L
Key Ring Language
Admin
F1_CRYPTO_KEY_RING_LOG
Key Ring Log
Admin
F1_CRYPTO_KEY_RING_LOG_PARM
Key Ring Log Parameter
Admin
F1_CUBE_TYPE
Cube Type
Admin
F1_CUBE_TYPE_L
Cube Type Language
Admin
F1_CUBE_VIEW
Cube View
Transaction
F1_CUBE_VIEW_L
Cube View Language
Transaction
F1_CUBE_VIEW_LOG
Cube View Log
Transaction
F1_CUBE_VIEW_LOG_PARM
Cube View Log Parameters
Transaction
F1_DEPLOYMENT_K
Deployment Key
Transaction
F1_ERASURE_SCHED
Object Erasure Schedule
Transaction
F1_ERASURE_SCHED_K
Object Erasure Schedule Key
Transaction
F1_ERASURE_SCHED_LOG
Object Erasure Schedule Log
Transaction
F1_ERASURE_SCHED_LOG_PARM
Object Erasure Schedule Log Parameter
Transaction
F1_MDT_K
Mobile Data Terminal Key
Transaction
F1_MIGR_OBJ_SQL_PK
Migration Object SQL Primary Key
Transaction
F1_PROC_DEFN
Process Flow Type
Admin
F1_PROC_DEFN_L
Process Flow Type Language
Admin
F1_PROC_NEXT_PANEL
Next Panel
Admin
F1_PROC_PANEL
Process Panel
Admin
F1_PROC_STORE
Process Flow
Transaction
F1_PROC_STORE_DTL_ELEMENTS
Process Flow Detail Elements
Transaction
F1_PROC_STORE_K
Process Flow Key
Transaction
F1_PROC_STORE_LOG
Process Flow Log
Transaction
F1_PROC_STORE_LOG_PARM
Process Flow Log Parameters
Transaction
F1_REMOTE_MSG_K
Mobile Remote Message Key
Transaction
F1_STATS_SNPSHT_K
Statistics Snapshot Key
Transaction
 
Note that the following tables have system generated keys but do not have a separate key table. Per the new table list, the key tables are provided and these tables are updated accordingly.
Table
Description
F1_ATTACHMENT
Attachment
F1_DEPLOYMENT
Deployment
F1_MDT
Mobile Data Terminal
F1_REMOTE_MSG
Mobile Remote Message
F1_STATS_SNPSHT
Statistics Snapshot
New Views
None
Dropped Tables
Table
F1_IWS_SVC_OPER_L
Unsupported Tables
The table below has been added for future functionality and is not currently in use.
Table
F1_CRYPTO_KEY_RING_LINK
Added Columns
Table
Column
Required
CI_BATCH_RUN
END_DTTM
N
CI_BATCH_RUN
START_DTTM
N
CI_COUNTRY
ADDR1_USG_FLG
Y
CI_COUNTRY
ADDR2_USG_FLG
Y
CI_COUNTRY
ADDR3_USG_FLG
Y
CI_COUNTRY
ADDR4_USG_FLG
Y
CI_COUNTRY
CITY_USG_FLG
Y
CI_COUNTRY
COUNTY_USG_FLG
Y
CI_COUNTRY
GEO_CODE_USG_FLG
Y
CI_COUNTRY
HOUSE_TYPE_USG_FLG
Y
CI_COUNTRY
IN_CITY_LIM_USG_FLG
Y
CI_COUNTRY
NUM1_USG_FLG
Y
CI_COUNTRY
NUM2_USG_FLG
Y
CI_COUNTRY
POSTAL_USG_FLG
Y
CI_COUNTRY
STATE_USG_FLG
Y
F1_ATTACHMENT
ATTACHMENT_EXT_ID
N
F1_ATTACHMENT
COMMENT_LONG
N
F1_IWS_SVC
RESOURCE_CAT_XFLG
N
F1_IWS_SVC
WEB_SVC_CLASS_FLG
Y
F1_IWS_SVC_OPER
RESOURCE_URI
N
F1_IWS_SVC_OPER
REST_HTTP_METHOD_FLG
N
F1_SVC_CATALOG
WEB_SVC_CLASS_FLG
Y
Dropped Columns
None
Column Format Change
None
Primary Key Change
None
Index Changes
None
 
 
New Tables
Table
Description
Type of Table
F1_DEPLOYMENT
Deployment
Transaction
F1_DEPLOYMENT_ITEM
Deployment Item
Transaction
F1_DEPLOYMENT_ITEM_METADATA
Deployment Item Meta Data
Transaction
F1_DEPLOYMENT_PART
Deployment Part
Master
F1_DEPLOYMENT_PART_L
Deployment Part Language
Master
F1_DEPLOYMENT_TYPE
Deployment Type
Master
F1_DEPLOYMENT_TYPE_L
Deployment Type Language
Master
F1_DEPTYP_DEPPART
Deployment Type / Deployment Part
Transaction
F1_DEPTYP_MDT_TYPE
Deployment Type / MDT Type
Transaction
F1_DEPTYP_MSG_CAT
Deployment Type Message Category
Transaction
F1_DEPTYP_USR_GRP
Deployment Type User Group
Transaction
F1_MDT
Mobile Data Terminal
Transaction
F1_MDT_CHAR
Mobile Data Terminal Characteristics
Transaction
F1_MDT_TYPE
Mobile Data Terminal Type
Master
F1_MDT_TYPE_CHAR
Mobile Data Terminal Type Characteristics
Master
F1_MDT_TYPE_L
Mobile Data Terminal Type Language
Master
F1_MOB_COMP_CHAR
Mobile Component Characteristics
Admin - System
F1_MOB_COMP_CNT
Mobile Component Content
Admin - System
F1_MOBILE_COMPONENT
Mobile Component
Admin - System
F1_MOBILE_COMPONENT_L
Mobile Component Language
Admin - System
F1_REMOTE_MSG
Remote Message
Transaction
F1_REMOTE_MSG_CHAR
Remote Message Characteristics
Transaction
F1_REMOTE_MSG_LOG
Remote Message Log
Transaction
F1_REMOTE_MSG_LOG_PARM
Remote Message Log Parameters
Transaction
F1_WEB_CAT_L
Web Service Category Language
Admin - System
F1_WEB_CAT_INCL_SVC
Web Service Category - Included Services
Admin - System
F1_WEB_CAT
Web Service Category
Admin - System
 
Note that in addition, the following table was added to 4.3.0.4.0 via a hot fix, but was not included in 4.3.0.5.0 until after the final build and is therefore added as a hot fix. Clients upgrading to 4.3.0.5.0 may see that the table is dropped via the blueprint and then reinstated after applying the bug fixes.
Table
Description
Type of Table
F1_MIGR_OBJ_SQL_PK
Migration Object SQL Primary Key
Transaction
New Views
None
Dropped Tables
Table
F1_IWS_ANN_CHAR
F1_IWS_ANN_TYPE_CHAR
Unsupported Tables
None
Added Columns
Table
Column
Required
CI_MD_SVC
APP_SVC_ID
N
F1_OUTMSG
BO_XML_DATA_AREA
N
F1_OUTMSG_TYPE
OUTMSG_PRIOR_FLG
Y
F1_OUTMSG_TYPE
OWNER_FLG
N
F1_OUTMSG_TYPE
TYPE_BUS_OBJ_CD
N
F1_OUTMSG_TYPE_L
OWNER_FLG
N
Dropped Columns
None
Unsupported Table Columns
None
Column Format Change
None
Primary Key Change
None
Index Changes
Index S1C675S1 for table F1_EXT_LOOKUP_VAL_CHAR has been renamed to F1C675S1.