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