Upgrades to Oracle Utilities Application Framework v4.5.0.0.0
New Tables
Table
Description
Table Type
F1_INSIGHT_TYPE
Insight Type
Admin System
F1_INSIGHT_TYPE_CHAR
Insight Type Characteristic
Admin System
F1_INSIGHT_TYPE_L
Insight Type Language
Admin System
F1_INSIGHT_TYPE_ALG
Insight Type Algorithm
Admin System
F1_INSIGHT_TYPE_USER_ACT
Insight Type User Action
Admin System
F1_INSIGHT_TYPE_USER_ACT_ALG
Insight Type User Action Algorithm
Admin System
F1_INSIGHT_TYPE_VISUAL_SETTING
Insight Type Visual Setting
Admin System
F1_COLOR_OPT
Color Option
Admin System
F1_COLOR_OPT_L
Color Option Language
Admin System
F1_COLOR_OPT_ITEM
Color Option Item
Admin System
F1_TREE
Tree
Admin System
F1_TREE_L
Tree Language
Admin System
F1_TREE_NODE
Tree Node
Admin System
F1_TREE_NODE_L
Tree Node Language
Admin System
F1_TREE_NODE_ALG
Tree Node Algorithms
Admin System
F1_INSIGHT_GRP
Insight Group
Admin
F1_INSIGHT_GRP_L
Insight Group Language
Admin
F1_INSIGHT_GRP_TYPE
Insight Group Insight Type
Admin
F1_INSIGHT_GRP_VISUAL_STR
Insight Group Valid Visual Structure
Admin
F1_INSIGHT_GRP_CHAR
Insight Group Characteristics
Admin
New Views
None
Dropped Tables
None
Unsupported Tables
None
Added Columns
Table
Field
Required
SC_USER
DASHBOARD_LOC_FLG
Yes
SC_USER
DASHBOARD_STATE_FLG
Yes
CI_BATCH_INST
START_DTTM
No
CI_BATCH_INST
END_DTTM
No
F1_MD_BI_TBL_FLD
LOGICAL_DM_NAME
No
Dropped Columns
None
Column Format Change
None
Primary Key Change
None
Index Changes
• Modified secondary index, F1T819S1 on table F1_ATTACHMENT to include MO + PK_Val 1-5 + attachment ID.
CREATE UNIQUE INDEX F1T819S1 ON F1_ATTACHMENT (MAINT_OBJ_CD, PK_VAL1, PK_VAL2, PK_VAL3, PK_VAL4, PK_VAL5, ATTACHMENT_ID) ;
 
• Added new index secondary index, F1T819S3 on table F1_ATTACHMENT for columns ATTACHMENT_FILE_NAME + ATTACHMENT_ID
CREATE UNIQUE INDEX F1T819S3 ON F1_ATTACHMENT (ATTACHMENT_FILE_NAME, ATTACHMENT_ID) ;