Oracle Utilities Operational Device Management V2.3.0.0.0 to V2.4.0.0.0
New Tables
The following tables are added to Oracle Utilities Operational Device Management in this release:
Table_Name
W1_ACTIVITY_MEASUREMENT_TYPE
W1_EU_TIMESHEET
W1_PROJECT_CATEGORY_LOG
W1_PROJECT_CATEGORY_LOG_PARM
W1_VENDOR_LOC_PAYTO_LOC
Dropped Tables
There are no dropped tables in this Oracle Utilities Operational Device Management release.
New Fields
The following fields are added to Oracle Utilities Operational Device Management in this release:
Table_Name
Column_Name
Data Type
Data
Length
W1_ACTIVITY_MEASUREMENT_TYPE
ACT_ID
CHAR
14
W1_ACTIVITY_MEASUREMENT_TYPE
MEASUREMENT_TYPE_CD
VARCHAR2
30
W1_ACTIVITY_MEASUREMENT_TYPE
VERSION
NUMBER
22
W1_EMPLOYEE_TRAINING
EFFECTIVE_DT
DATE
7
W1_EMPLOYEE_TRAINING
EMPLOYEE_NOTIFIED
CHAR
1
W1_EMPLOYEE_TRAINING
SUPERVISOR_NOTIFIED
CHAR
1
W1_EMPLOYEE_TRAINING
W1EXPIRATION_DT
DATE
7
W1_EU
AUTO_TS_
CREATION
CHAR
1
W1_EU_TIMESHEET
EU_DT
DATE
7
W1_EU_TIMESHEET
EU_ID
CHAR
12
W1_EU_TIMESHEET
HOURS
NUMBER
22
W1_EU_TIMESHEET
VERSION
NUMBER
22
W1_MAINT_TRIGGER
AUTO_SCHEDULE_FLG
CHAR
4
W1_MAINT_TRIGGER
W1_CREW_ID
CHAR
12
W1_PO_HEADER_DOCUMENT
PRINT_FLG
CHAR
4
W1_PO_LINE
RR_ID
CHAR
14
W1_PO_LINE_DOCUMENT
PRINT_FLG
CHAR
4
W1_PROJECT_CATEGORY
BO_STATUS_CD
CHAR
12
W1_PROJECT_CATEGORY
BO_STATUS_REASON_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
ADHOC_CHAR_VAL
VARCHAR2
254
W1_PROJECT_CATEGORY_LOG
BO_STATUS_CD
CHAR
12
W1_PROJECT_CATEGORY_LOG
BO_STATUS_REASON_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
CHAR_TYPE_CD
CHAR
8
W1_PROJECT_CATEGORY_LOG
CHAR_VAL
CHAR
16
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK1
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK2
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK3
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK4
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK5
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
DESCRLONG
VARCHAR2
4000
W1_PROJECT_CATEGORY_LOG
LOG_DTTM
DATE
7
W1_PROJECT_CATEGORY_LOG
LOG_ENTRY_TYPE_FLG
CHAR
4
W1_PROJECT_CATEGORY_LOG
MESSAGE_CAT_NBR
NUMBER
22
W1_PROJECT_CATEGORY_LOG
MESSAGE_NBR
NUMBER
22
W1_PROJECT_CATEGORY_LOG
PRJ_CAT_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
SEQNO
NUMBER
22
W1_PROJECT_CATEGORY_LOG
USER_ID
CHAR
8
W1_PROJECT_CATEGORY_LOG
VERSION
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
F1_MSG_PARM_
VLONG
VARCHAR2
2000
W1_PROJECT_CATEGORY_LOG_PARM
MSG_PARM_TYP_
FLG
CHAR
4
W1_PROJECT_CATEGORY_LOG_PARM
PARM_SEQ
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
PRJ_CAT_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG_PARM
SEQNO
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
VERSION
NUMBER
22
W1_RR
BC_LINE_ID
CHAR
14
W1_TIMESHEET_DETAIL
EU_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
PAY_TO_LOC
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VENDOR_LOC_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VERSION
NUMBER
22
Updated Fields
There are no updated fields in this Oracle Utilities Operational Device Management release.
Dropped Fields
There are no dropped fields in this Oracle Utilities Operational Device Management release.
New Indexes
The following fields are added to Oracle Utilities Operational Device Management this release:
Table_Name
Index_Name
W1_ACTIVITY
W1T244S18
W1_ACTIVITY
W1T244S19
W1_ACTIVITY
W1T244S20
W1_ACTIVITY_MEASUREMENT_TYPE
W1T962P0
W1_ACTIVITY_TYPE
W1C237S3
W1_EMPLOYEE_TRAINING
W1M502P0
W1_EU_TIMESHEET
W1M961P0
W1_INVOICE_HEADER
W1T500S2
W1_INVOICE_LINE
W1T509S3
W1_INVOICE_LINE
W1T509S4
W1_INVOICE_LINE
W1T509S5
W1_MAINT_TRIGGER
W1M658S3
W1_NODE
W1M205S10
W1_NODE
W1M205S11
W1_NODE_TYPE
W1C200S1
W1_PI_CNT_MST
W1T324S3
W1_PO_HEADER
W1T410S5
W1_PO_LINE
W1T418S5
W1_PO_LINE
W1T418S6
W1_PO_LINE
W1T418S7
W1_PO_LINE
W1T418S8
W1_PROJECT_CATEGORY_LOG
W1C963P0
W1_PROJECT_CATEGORY_LOG_PARM
W1C964P0
W1_PR_LINE
W1T443S3
W1_RCPT_HDR
W1T460S3
W1_RCPT_LINE
W1T468S3
W1_RTN_LINE
W1T483S2
W1_RTN_LINE
W1T483S3
W1_RTN_LINE
W1T483S4
W1_RTN_LINE
W1T483S5
W1_RTN_LINE
W1T483S6
W1_STOCK_ITEM_DTL
W1M568S4
W1_STOCK_ITEM_DTL
W1M568S5
W1_TIMESHEET_DETAIL
W1M595S3
W1_TMPL_ACT
W1M617S1
W1_VENDOR_LOC_PAYTO_LOC
W1M955P0
W1_WO
W1T232S13
W1_WO
W1T232S14
W1_WORK_REQ
W1T298S8
Updated Indexes
There are no updated indexes in this Oracle Utilities Operational Device Management release.
Dropped Indexes
The following fields are dropped in this Oracle Utilities Operational Device Management release:
Table_Name
Index_Name
W1_RTN_LINE
W1M637S2
W1_RTN_LINE
W1M637S3
W1_STOCK_ITEM_DTL
W1M601S13
New Views
There are no views added in this Oracle Utilities Operational Device Management release.
New Materialized Views
There are no materialized views added in this Oracle Utilities Operational Device Management release.