Upgrades to Oracle Utilities Application Framework v4.4.0.2.0
New Tables
Table
Description
Table Type
F1_MKTPROC
Market Process
Transaction
F1_MKTPROC_LOG
Market Process Log
Transaction
F1_MKTPROC_LOG_PARM
Market Process Log Parameter
Transaction
F1_MKTPROC_CHAR
Market Process Characteristics
Transaction
F1_MKTPROC_ID
Market Process
Identifiers
Transaction
F1_MKTPROC_REL_OBJ
Market Process Related Objects
Transaction
F1_MKTPROC_REL_PROC
Related Market
Processes
Transaction
F1_MKTMSG_IN
Inbound Market Message
Transaction
F1_MKTMSG_IN_LOG
Inbound Market Message Log
Transaction
F1_MKTMSG_IN_LOG_PARM
Inbound Market Message Log Parameter
Transaction
F1_MKTMSG_IN_CHAR
Inbound Market Message Characteristics
Transaction
F1_MKTMSG_IN_DATA
Inbound Market Message Data
Transaction
F1_MKTMSG_IN_EXT_REF
Inbound Market Message References
Transaction
F1_MKTMSG_IN_ID
Inbound Market Message Identifiers
Transaction
F1_MKTMSG_IN_REL_OBJ
Inbound Market Message Related Objects
Transaction
F1_MKTCFG
Market Configuration
Admin
F1_MKTCFG_L
Market Configuration Language
Admin(non system)
F1_MKTCFG _CHAR
Market Configuration Characteristics
Master
F1_MKTMSG_TYPE
Market Message Type
Admin(non system)
F1_MKTMSG_TYPE_L
Market Message Type
Admin (non system)
F1_MKTMSG_TYPE_CHAR
Market Message Type Characteristics
Admin (non system)
F1_MKTPROC_EVT
Market Process Event
Transaction
F1_MKTPROC_EVT _LOG
Market Process Event Log
Transaction
F1_MKTPROC_EVT _LOG_PARM
Market Process Event Log Parameter
Transaction
F1_MKTPROC_EVT _CHAR
Market Process Event Characteristics
Transaction
F1_MKTPROC_EVT _REL_OBJ
Market Process Event Related Objects
Transaction
F1_MKTMSG_OUT
Outbound Market
Message
Transaction
F1_MKTMSG_OUT_LOG
Outbound Market
Message Log
Transaction
F1_MKTMSG_OUT_LOG_PARM
Outbound Market
Message Log Parameter
Transaction
F1_MKTMSG_OUT_CHAR
Outbound Market
Message Characteristics
Transaction
F1_MKTMSG_OUT_DATA
Outbound Market
Message Data
Transaction
F1_MKTMSG_OUT_EXT_REF
Outbound Market
Message References
Transaction
F1_MKTMSG_OUT_ID
Outbound Market
Message Identifiers
Transaction
F1_MKTMSG_OUT_REL_OBJ
Outbound Market
Message Related Objects
Transaction
F1_MKTPROC_TYPE
Market Process Type
Admin(non system)
F1_MKTPROC_TYPE_L
Market Process Type Language
Admin(non system)
F1_MKTPROC_TYPE_CHAR
Market Process Type Characteristics
Admin(non system)
F1_MKTPROC_TYPE_EVT
Market Process Type Events
Admin(non system)
F1_CALENDAR_D
Calendar Dimension
Transaction
F1_TIME_D
Time Dimension
Transaction
F1_IWS_SVC_OPER_PARM
Inbound Web Service Operations Parameter
Admin
New Views
None
Dropped Tables
None
Unsupported Tables
None
Added Columns
Table
Description
Table Type
CI_BATCH_THD
THD_RETRY_CNT
N
F1_IWS_SVC
URI_COMPONENT
N
Dropped Columns
None
Column Format Change
None
Primary Key Change
None
Index Changes
create index XT039S8 on CI_TD_ENTRY(ENTRY_STATUS_FLG,TD_TYPE_CD,MESSAGE_CAT_NBR,MESSAGE_NBR)
CREATE INDEX XT026S5 ON CI_NT_DWN (SPR_CD,CRE_DTTM)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CISTS_01"