Technical data

Automatic Data Upgrade
B-2 Oracle Utilities Meter Data Management Database Administrator’s Guide
Automatic Data Upgrade
This section describes what the upgrade script will populate in new tables and columns to
preserve the existing base product application functions of the previous version of Oracle Utilities
Application Framework.
Nullable column support
FW410 Group Fix 2 supports Nullable columns. This means that FW will write NULLs instead of
a blank space or zero (for numeric columns). NULLABLE_SW (which already exists) on
CI_MD_TBL_FLD is used for this. If the REQUIRED_SW is 'N' and the NULLABLE_SW ='Y'
then FW will write a NULL in that column. The artifact generator will create hibernate mapping
files with appropriate parameters so that the OUAF hibernate mapping types will know whether a
given property supports null value or not.
NULLABLE_SW has existed for a while, but has only been actually read and used for certain
fields (dates, and some string and number foreign-key columns). This means that there is the
possibility that there is incorrect metadata for some columns, and that turning on this new feature
that uses the suspect metadata could result in incorrect behavior. As a part of upgrade script added
to FW410 Group Fix 2 all existing metadata will be fixed to make sure that the existing tables will
not be affected.
This new feature of allowing null values to be stored on table columns will only be supported by
Java maintained tables. Thus, enhancing any existing tables to use null columns must take place
after assuring that the tables are maintained directly by Java, and not COBOL code.
Schema Change
New Tables
The following new tables are added to Oracle Utilities Application Framework V4.1.0.
New Views
Tables Description
F1_GENERIC_GTT Generic Global Temporary Table
F1_SVC_TASK Service Task
F1_SVC_TASK_CHAR Service Task Characteristics
F1_SVC_TASK_K Service Task Key
F1_SVC_TASK_LOG Service Task Log
F1_SVC_TASK_LOG_PARM Service Task Log Parameters
F1_SVC_TASK_REL_OBJ Service Task Related Objects
F1_SVC_TASK_TYPE Service Task Type
F1_SVC_TASK_TYPE_CHAR Service Task Type Characteristics
F1_SVC_TASK_TYPE_L Service Task Type Language
F1_SYNC_REQ_EXTRACT Sync Request Extract