Upgrading from Oracle Utilities Application Framework V4.3.0.4.0 to V4.3.0.5.0
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.