Oracle Utilities Meter Data Management Database Administrator’s Guide Release 2.0.
Oracle Utilities Meter Data Management Database Administrator’s Guide E18181-07 Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws.
Contents Preface................................................................................................................................................................ i-i Audience ............................................................................................................................................................................ i-i Related Documents................................................................................................................................
Owner Flag...................................................................................................................................................... 3-7 Version............................................................................................................................................................. 3-7 Chapter 4 Database Implementation Guidelines..............................................................................................................
Business Object ............................................................................................................................................. FK Reference................................................................................................................................................. Lookups.......................................................................................................................................................... Maintenance Object................
iv
Preface This guide provides instructions for installing and maintaining the database for Oracle Utilities Meter Data Management. This preface contains these topics: • Audience • Related Documents • Updates to this Documentation • Conventions Audience Oracle Utilities Meter Data Management Database Administrator’s Guide is intended for database administrators who will be installing and maintaining the database for Oracle Utilities Meter Data Management.
Conventions The following text conventions are used in this document: ii Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.
Chapter 1 Database Overview This section provides an overview of the Oracle Utilities Meter Data Management database, including: • Supported Database Platforms • Database Maintenance Rules Database Overview 1-1
Supported Database Platforms Supported Database Platforms This section defines the platforms on which Oracle Utilities Meter Data Management is verified to operate. Supported Platforms Summary Table Oracle Utilities Meter Data Management is certified on the following platforms: Platform Database Version AIX 6.1 TL4 (POWER 64-bit) Oracle Database Server 11.2.0.1 (64-bit) Oracle Linux 5.6 (64-bit) x86_64 (64-bit) Oracle Database Server 11.2.0.1 (64-bit) Red Hat Enterprise Linux 5.
Database Maintenance Rules Database Maintenance Rules The database supplied with the product consists of the following elements: • A set of users to administrate, execute and read the database schema provided. • A set of database roles to implement security for each of the users provided. • A tablespace and a schema containing the base database objects used by the product. The installation of these components is outlined in the installation section of this document.
Database Maintenance Rules 1-4 Oracle Utilities Meter Data Management Database Administrator’s Guide
Chapter 2 Database Installation This section provides the steps required to install or upgrade the Oracle Utilities Meter Data Management database, including: • Installation Overview • Oracle Database Installation Database Installation 2-1
Installation Overview Installation Overview Note: Refer to the Oracle Utilities Meter Data Management Installation Guide for the hardware and software versions required for the installation on Unix or Windows. This installation is for Oracle Utilities Meter Data Management V2.0.1 and the upgrade of Oracle Utilities Meter Data Management V2.0.0 to V2.0.1. The following type of installation is available for Oracle Utilities Meter Data Management: • Initial Install - a database with no demo data.
Oracle Database Installation Oracle Database Installation This section describes how to install the Oracle Database for Oracle Utilities Meter Data Management. It contains the following topics: • Database Scripts and Utilities • Initial Install • Upgrade Install • Demo Install • Creating the Database • Security Configuration • Populating Language Data • Installing Service Packs and Patches Note: The installation tools outlined in this guide run on Windows and UNIX/Linux only.
Oracle Database Installation The CDXDBA utility provided in the DatabaseCreation folder may be used to automate the process. See Creating the Database on page 2-9 for more details. For an initial install, do not import the demo install data when you create the database. Install the Database Install Oracle Utilities Application Framework V4.1.0 prior toOracle Utilities Meter Data Management 2.0.1. The files for Oracle Utilities Application Framework installation are located in the FW410 folder: 1.
Oracle Database Installation 3. After setting up roles and users, the utility continues upgrading schema and system data definitions. If an error occurs while executing an SQL or another utility, it logs and displays the error message and allows you to re-execute the current step. 4. Run CDXDBI.exe from MDM/Install-Upgrade. The utility prompts you to enter values for the following parameters: • The name of the target database.
Oracle Database Installation Post-Install Tasks: Refer to Populating Language Data on page 2-11 if the application is to run in another language other than English. Database Statistics Generation During an install process, new database objects may be added to the target database. Before starting to use the database, generate the complete statistics for these new objects using the DBMS_STATS package. Upgrade Install The following section assumes an existing Oracle Utilities Meter Data Management V2.
Oracle Database Installation • TUGBU JAR files location. • The password for the user (in silent mode). • The Oracle user with read-write privileges to the Database Schema. • The Oracle user with read-only privileges to the Database Schema. • The Oracle database role with read-write privileges to the Database Schema. • The Oracle database role with read-only privileges to the Database Schema. 3.
Oracle Database Installation • Verifies whether the tablespace names already exist in Storage.xml file (the process aborts, if not). • Upgrades the schema, upgrades the system data, and configures security. • Maintains upgrade log tables in the database. • Updates release id when the upgrade is completed successfully. • If an error occurs while executing a SQL script or another utility, it logs and displays the error message and allows you to re-execute the current step. Log files CDXDBI###.
Oracle Database Installation Create the Database and Import Demo Data The CDXDBA utility provided in the “Database Creation” folder may be used to automate the process. Complete the steps in Creating the Database on page 2-9 to create the database and import the Demo Install data into the database. The Database Creation folder contains the instructions for the import of the Demo Install data.
Oracle Database Installation Do you want to import a demo database dump into this database (Y/ N)? • For an initial install, select N to exit the database utility. Follow the steps in Initial Install on page 2-3 to complete the database installation. • For a demo install, select Y to import the demo database. For the Demo Install use the dump file exp_demo.dmp. Do you want to import a demo database dump into this database (Y/ N)? Y • Enter the name of the dump file (exp_demo.
Oracle Database Installation • For the Demo Install use the dump file exp_demo.dmp. The data_pump_dir must exist in the database created above before continuing with the import. You should also copy the exp_demo.dmp file to the data_pump_dir. • Update the oratab, tnsnames.ora and listener.ora files for the new database and check the connectivity to this database from another server and from your desktop. After importing the demo install data, the demo install of the database is complete.
Oracle Database Installation Installing Service Packs and Patches Periodically, Oracle Utilities releases a service pack of single fixes for its products. A service pack is an update to an existing release that includes solutions to known problems and other product enhancements. A service pack is not a replacement for an installation, but a pack consisting of a collection of changes and additions for it. The service pack may include changes to be applied to the application server, the database, or both.
Chapter 3 Database Design This section provides a standard for database objects such as tables, columns, and indexes, for products using the Oracle Utilities Application Framework. This standard helps smooth integration and upgrade processes by ensuring clean database design, promoting communications, and reducing errors.
Database Object Standard Database Object Standard This section discusses the rules applied to naming database objects and the attributes that are associated with these objects. Categories of Data A table can belong to one of the three categories: • Control (admin) • Master • Transaction For purposes of physical table space design, metadata and control tables can belong to the same category.
Database Object Standard • Use the suffix FLG to define a lookup table field. Flag columns must be CHAR(4). Choose lookup field names carefully as these column names are defined in the lookup table (CI_LOOKUP_FLD) and must be prefixed by the product owner flag value. • Use the suffix CD to define user-defined codes. User-defined codes are primarily found as the key column of the admin tables. • Use the suffix ID to define system assigned key columns. • Use the suffix SW to define Boolean columns.
Database Object Standard - - CISTS_01 Y 8192 N Y Y N Where Parallel defines the number of threads, that Oracle DB Server will use to access a table or create an index. For instance, if a DBA decided to allocate table CI_ACCT in a tablespace MyTablespace, then they would have to change the storage.
Database Object Standard For Example: F1T220_BO_STATUS_CD_SEQ and F1T220_BUS_OBJ_CD_SEQ 3. If sequence is used for a generic requirement and not specific to a table, then use the following sequence name. [OF]Column_Name_SEQ • OF stands for Owner Flag. For example, the framework is F1. Other examples are M1,C1,D1,D2, etc. For Example: F1FKVALID_SEQ Trigger The base trigger name must be prefixed with the owner flag value of the product.
Column Data Type and Constraints Column Data Type and Constraints This section discusses the rules applied to column data type and constraints, and the attributes that are associated with these objects. User Defined Code User Defined Codes are defined as CHAR type. The length can vary by the business requirements but a minimum of eight characters is recommended.
Column Data Type and Constraints Default Value Setting The rules for setting the database default values are as follows: • When a predefined default value is not available, set the default value of Non-null CHAR or VARCHAR columns to blank except the primary key columns. • When a predefined default value is not available, set the default value Non-null Number columns to 0 (zero) except the primary key columns.
Column Data Type and Constraints 3-8 Oracle Utilities Meter Data Management Database Administrator’s Guide
Chapter 4 Database Implementation Guidelines The following section outlines the general implementation guidelines for the database components, including: • Configuration Guidelines Note: Refer to My Oracle Support for more information. See Appendix D: Partitioning Recommendations for Oracle Utilities Meter Data Management for additional information about configuring the Oracle Utilities Meter Data Management database.
Configuration Guidelines Configuration Guidelines This section includes general recommendations for configuring various database objects and includes a brief syntax overview. It covers the general aspects of the database objects and does not cover any specific implementation requirements. Index Index recommendations specify points that need to be considered when creating indexes on a table. 1.
Configuration Guidelines • Tablespace level encryption is also supported using the following command: Create tablespace logging datafile '' size reuse autoextend on next maxsize unlimited extent management local uniform size encryption using 'AES128' default storage(encrypt) ; • Indexed columns can only be encrypted using the NO SALT Option. Salt is a way to strengthen the security of encrypted data.
Configuration Guidelines Storage Recommendations This section specifies recommended options for storing the database objects. SecureFile for Storing LOBs Beginning with Oracle 11g, tables having fields with data type of CLOB or BLOBS should have the LOB Columns stored as SecureFiles. • The storage options with SecureFiles for Heap Tables should be ENABLE STORAGE IN ROW, CACHE and COMPRESS.
Configuration Guidelines Database Syntax SecureFile CREATE TABLE ( COLUMN1 …., COLUMN2 (CLOB) ) LOB(COLUMN2) STORE AS SECUREFILE (CACHE COMPRESS); CREATE TABLE ( COLUMN1 …., COLUMN2 (CLOB) CONTRAINT <> PRIMARY KEY(…) ) ORGANIZATION INDEX PCTTHRESHOLD 50 OVERFLOW LOB(COLUMN2) STORE AS SECUREFILE (ENABLE STORAGE IN ROW CHUNK CACHE COMPRESS); Database Initialization Parameters The recommended Initialization Parameters are given below.
Configuration Guidelines 4-6 Oracle Utilities Meter Data Management Database Administrator’s Guide
Appendix A Upgrades to the Oracle Utilities Meter Data Management Database This document highlights the changes made to Oracle Utilities Meter Data Management database from V2.0.0.1 to V2.0.1 In the last section of this document you will find a list of the schema objects added or dropped in MDM 2.0.1.
Automatic Data Upgrade 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. Set Business Status for Measurement Data As life cycle is added to BO an upgrade script is used to update the business status code in all existing customer records.
Schema Change Schema Change New Tables The following new tables are added to Oracle Utilities Meter Data Management V2.0.1. Tables Description D1_SP_MSRMT_CYC_SCHED_RTE SP/Measurement Cycle Schedule Route Dropped Tables None Unsupported Tables None Added Columns The following Table Columns are added to Oracle Utilities Meter Data Management V2.0.
New System Data New System Data This section lists the new system data that are added for business process configuration. Algorithm Type The following algorithm types are new to V2.0.1.
New System Data Algorithm Type Description D1-COOC Cancel Outstanding Outbound Communication D1-COUTMSG Create Outbound Message D1-CRAINFO Command Request Activity Information D1-CRE-TDNVE Create IMD To Do for Error States D1-CREATELOG Create Log Entries for Device Event Seeder D1-CREATTODO Create Device Event To Do D1-CRENEGACK Create Negative Acknowledgement D1-CREPOSACK Create Positive Acknowledgement D1-DCVALDEC Default Configuration Validation of Device Event Category D1-DDACINFO
New System Data Algorithm Type Description D1-DVEVTINFO Device Event Info D1-EVCRBONSC Event Creation Based on Status Codes Additional D1-EXCMPEVTS Execute Completion Events D1-FAILPA Fail Parent Activity D1-FINDCMD Find Command to Cancel D1-FRER Send Fail Response to External Requester D1-GINPVAL Common Input Validation D1-HLPRDDEVT Hold Paired Device Event D1-IMD-RETRY Retry Initial Measurement Data Processing D1-IMD-SD-TR IMD Seeder Transition Determinant D1-IMD-TRNS IMD Transitio
New System Data Algorithm Type Description D1-SNDDVSTCK Send Device Status Check Notification to Edge Application D1-SNDRDTEA Send On Demand Read to Edge Application D1-SODRTEA Send On-Demand Read to Edge Application D1-SPLCONSMO Split into Constituent Device Configuration and MC Sync Requests D1-SPRID Service Provider Identification D1-SR-CRSEED Instantiate a Sync Request Seeder D1-SR-PREADD Sync Request Pre-Add Data D1-SR-UPDDAT Sync Request Update Data D1-SRCNTEA Send Connect or Disco
New System Data Algorithm Type Description D1-VALDVCSTS Validate Install Event Status D1-VALIDCMD Validate Head-End's Capability to Perform Command D1-VALIMPINT Validate Start and End Date Time D1-VALMAXRT Validate Maximum Retries If Retry Frequency Is Populated D1-VALMDEST Validate Measurement Destination D1-VALMREQO Validate Measurement Requested D1-VALOUTCOM Validate Outbound Communication D1-VALSCHTRU Validate Schema D1-VALSTCOND Validate State Condition of Smart Device D1-VALSYNCBO
New System Data Algorithm Type Description D2-CRE-UTSD D2-CHKTRNPUT Set Try To Transition Parent Usage Transaction to Yes D2-DET-UTDT Determine Usage Transaction Period D2-OACHKVAL Zero Consumption Outage Activity Validation D2-RETRY Retry D2-SEND-EROR Send Error Notification D2-TNAFCALCH Transition After Calculation (Sub Usage Transaction) D2-TNORBATCH Proceed With Calculation Or Defer Calculation D2-TRNRATESC Transform Rate Schedule D2-VAL-AMCT Validate Aggregator Measuring Component T
New System Data Algorithm Description D1-AUD-UEFLG Audit User Edited Flag D1-BODIFFDT BO Differs By Device Type D1-CCINPVAL Cancel Command Input Validation D1-CCSRER Cancel Command Send Success Response to External Requester D1-CDCCSRTBO Transform to Connect Command Request or Connect Service Request Transaction BO D1-CDCOBC Create Decommission Outbound Communication for Activities D1-CDDCSRTBO Transform to Disconnect Command Request or Disconnect Service Request Transaction BO D1-CECD Che
New System Data Algorithm Description D1-CRDOC Create Remote Disconnect Outbound Communication D1-CRE-TDNVE Create IMD To Do for Error States D1-CREATELOG Create Log Entries D1-CREATTODO Create Device Event To Do D1-CREDVSTCK Create Device Status Check Outbound Communication D1-CREDVSTLD Create Device Status Check Outbound Communication D1-CRENEGACK Create Negative Acknowledgement D1-CREPOSACK Create Positive Acknowledgement D1-CROBCA Create Outbound Communication for OnDemand Read (Scal
New System Data Algorithm Description D1-DFLSYNCBO Default Composite Sync Request BO D1-DFTSTDTTM Default Start Date/Time D1-DIFDVEVTC Method Differs By Device Event Category D1-DMRO Default Measurement Requested D1-DMT Default Measurement Type D1-DRDTBO Determine Read Device Transaction BO D1-DSCFRER Send Fail Response to External Requester D1-DSCPRDEVT Discard Pair of Events D1-DSCRRER Send Received Response to External Requester D1-DVCEVTVAL Validate Device Event Processing Method C
New System Data Algorithm Description D1-RFINTM Retrieve Interval Final Measurements D1-RIINTM Retrieve Interval Initial Measurements D1-RMVCE Retrieve Measurements via Completion Events D1-RMVCERC Retrieve Measurements via Completion Events Remote Connect D1-RRER Send Received Response to External Requester D1-RSINIMS Retrieve Scalar Initial Measurements D1-RSTEXPDT Reset Expiration Date Time D1-SANFS Alert - Show Activities in Non-Final State D1-SENDTOSUB Send to Subscribers D1-SETCMP
New System Data Algorithm Description D1-TIMEOUT Time Out D1-TODOCOMPL Generic To Do Completion D1-TODORETRY Sync Request Retry for To Do's D1-TPATOF Transition Parent Activity To Failed D1-TRANRELCS Transition Related Composite Sync Request D1-TRANTONEG Do Not Clear Exceptions and Transition to Negative State D1-TRNIESTAT Translate Install Event Status D1-TRNONOFF Translate/Suppress On/Off History D1-UPAEDT Update Parent Activity's Event Date Time D1-VALACTTDI Validate Activity Type a
New System Data Algorithm Description D1-VALMDEST Validate Measurement Destination D1-VALMREQO Validate Measurement Requested D1-VALOUTCOM Validate Outbound Communication D1-VALSCHTRU Validate Schema D1-VALSTCOND Validate State Condition of Smart Device D1-VALSYNCBO Perform BO Validation D1-VHCPCD Validate Head-end's Capability to perform Connect Disconnect D1-VHCPCOMMS Validate Head-End's Capability to Commission Device D1-VHCPDCOMM Validate Head-end's Capability to perform Decommission
New System Data Algorithm Description D2-DET-CMC Find Constituent Measuring Components Based on Service Type and Postal D2-DET-UTDT Determine Usage Transaction Period D2-DETTARGUS Determine Sync Request Target BO Usage Subscription D2-DETUSID Determine Usage Subscription ID D2-DETUTBO Determine Usage Transaction Business Object D2-INTADJSCA Interval Adjustment Based on Related Scalar Measurement D2-MATH Math D2-OACHKVAL Zero Consumption Outage Activity Validation D2-RETRY Retry D2-SCAPR
New System Data Application Service The following Application Services are new to V2.0.
New System Data Application Service Description D1DVCEVT Device Event Portal D1DVCEVTTYP Device Type Portal D1MCTYQ Measuring Component Type Query D1SYNCIN Sync Request Inbound Portal D1SYNCIQ Sync Request Inbound Query Portal D1SYNCRINM Sync Request Portal D1SYNCRINQ Sync Request Query Portal D1SYRINE Sync Request Inbound Exceptions Portal D2-AGGBOAS Aggregator Measuring Component BO D2-AGGDSBOAS Agg Dimension Scanner Activity BO D2-SYNCADDUSBOAS US Synchronization Add BO D2-USAGET
New System Data Batch Control Description D1-OCWT Outbound Communication Wait - Monitor D1-PSPSR Process SP / MC Schedule Route Records D1-SIIER Initial Sync Request - Error D1-SIKCN Initial Sync Request - Resolve Keys Contact D1-SIKDC Initial Sync Request - Resolve Keys DC D1-SIKDV Initial Sync Request - Resolve Keys Device D1-SIKIE Initial Sync Request - Resolve Keys IE D1-SIKMC Initial Sync Request - Resolve Keys MC D1-SIKSP Initial Sync Request - Resolve Keys SP D1-SIKUS Initial Sy
New System Data Business Object Description D1-AuditList IMD - Audit List Section Only (Lite) D1-BusinessObject Business Object D1-BusinessObjectMO Business Object MO D1-CancelCommand Cancel Command D1-CancelCommandType Cancel Command Type D1-CommInLite Inbound Communication Lite D1-CommOutLite Outbound Communication Lite D1-CommTypeBundlingAddBO Bundling Add BO for Communication Type D1-CommunicationLite Communication Lite D1-CommunicationTypePhysicalBO Physical BO for Communication T
New System Data Business Object Description D1-ExternalActTypeIdentifier External Activity Type Identifier D1-ExternalCommTypeLookup External Communication Type D1-GenericConnect Generic Connect Device D1-GenericDisconnect Generic Disconnect Device D1-HeadendUOMLookup Headend UOM Code to Standard UOM D1-HowToProcDvcEvtsInformation How to Process Device Event Related Info D1-HowToProcessDeviceInfo How to Process Device Related Information D1-IBCommunicationTypeBasis Inbound Communication Ty
New System Data Business Object Description D1-OngoingSyncRequestDC Device Configuration Ongoing Sync Request D1-OngoingSyncRequestDevice Device Ongoing Sync Request D1-OngoingSyncRequestIE Install Event Ongoing Sync Request D1-OngoingSyncRequestMC Measuring Component Ongoing Sync Request D1-OngoingSyncRequestSP Service Point Ongoing Sync Request D1-PairedEventFirstDeviceEvent Device Event - Paired Event (First) D1-PairedEventFirstDvcEvtType Device Event Type - Paired Event (First) D1-Paire
New System Data Business Object Description D2-AggregatorType Aggegator Type D2-AggregatorTypeLite Aggregator Type - Lite D2-CCBRateScheduleLookup CCB Rate Schedule D2-HowToSendUSInfoBatch How To Send US Related Information Batch D2-HowToSendUSInfoOnline How To Send US Information - Online D2-InitialSyncRequestUS Usage Subscription Initial Sync Request D2-Math Usage Rule - Math D2-SubUsageTransaction Sub Usage Transaction D2-USMainContactLITE Usage Subscription Main Contact Lite D2-Usag
New System Data FK Reference Description D1CE-BO Valid Completion Event Business Object D1SA-BO BO Option - Measurement Log BO D1VB-BO BO Option - Valid Command Request BO D1VC-BO BO Option - Valid Completion Event D1-USGRE Usage Transaction Parent Lookups The following Lookups are new to V2.0.1.
New System Data Lookup Field Name Field Value Language Description ACTIVITY_REL_OBJ _TYPE_FLG D1IE ENG Initiating Event ACTIVITY_REL_TYP E_FLG D1CN ENG Cancel ACTIVITY_TYPE_CA T_FLG D1DE ENG Device Event Activity AUTO_RETRY_FLG D1NO ENG No AUTO_RETRY_FLG D1YS ENG Yes BAR_DATA_TYPE_F LG D1DE ENG Device Events BO_TR_COND_FLG D1AC ENG Active BO_TR_COND_FLG D1DR ENG Discard BO_TR_COND_FLG D1IN ENG Inactive BO_TR_COND_FLG D1VE ENG VEE State BUS_OBJ_OPT_FLG D1CC ENG
New System Data Lookup Field Name Field Value Language Description D1_EVT_DUR_FLG D1CN ENG Continuous D1_EVT_DUR_FLG D1IN ENG Individual D1_SHOW_ALL_CO MMT_FLG D1YE ENG Yes D1_SHOW_ALL_DVC _EVT_TYP_FLG D1YE ENG Yes D1_SHOW_ALL_SYN C_REQ_IN D1YS ENG Yes DATE_TIME_STAND ARD_FLG D1NO ENG No DATE_TIME_STAND ARD_FLG D1YS ENG Yes DVC_EVT_ACTION_ FLG D1SB ENG Subscribe DVC_EVT_ACTION_ FLG D1US ENG Unsubscribe DVC_EVT_OUTCOM E_FLG D1SB ENG Subscribed DVC_EVT_OUTCOM E_FLG
New System Data Lookup Field Name Field Value Language Description MSRMT_TYPE_FLG D1SC ENG Scalar PROCESS_FLG D1NP ENG Do Not Process PROC_ROLE_FLG D1AM ENG Obtain AMI Device Identifier PROC_ROLE_FLG D1DC ENG Device Commission PROC_ROLE_FLG D1DD ENG Device Decommission PROC_ROLE_FLG D1DM ENG Device Event Mapping PROC_ROLE_FLG D1DS ENG Device Status Check PROC_ROLE_FLG D1EP ENG Event Processing Default Configuration PROC_ROLE_FLG D1IN ENG On-Demand Read (Interval) PRO
New System Data Lookup Field Name Field Value Language Description FALSE_ACTION_FLG D2AT ENG Apply False Formula FALSE_ACTION_FLG D2CN ENG Check Next Condition INSERT_SQ_ENTRY_ FLG D2NO ENG No INSERT_SQ_ENTRY_ FLG D2YS ENG Yes INTV_SET_FLG D2FV ENG FV - Final Vector Interval Value INTV_SET_FLG D2V1 ENG IV1 - Vector 1 Interval Value INTV_SET_FLG D2V2 ENG IV2 - Vector 2 Interval Value INTV_SET_FLG D2V3 ENG IV3 - Vector 3 Interval Value INTV_SET_FLG D2V4 ENG IV4 - Vector
New System Data Lookup Field Name Field Value Language Description SCALAR_SET_FUNC_ FLG D2MN ENG Min SCALAR_SET_FUNC_ FLG D2MX ENG Max SCALAR_SET_FUNC_ FLG D2TL ENG Total SET_FUNC_DRV_VE C_FLG D2AV ENG Average SET_FUNC_DRV_VE C_FLG D2CT ENG Count SET_FUNC_DRV_VE C_FLG D2MN ENG Min SET_FUNC_DRV_VE C_FLG D2MX ENG Max SET_FUNC_DRV_VE C_FLG D2TL ENG Total SQ_ENTRY_QTY_SR C_FLG D2DV ENG Set Function Against Derived Vector SQ_ENTRY_QTY_SR C_FLG D2SC ENG Scalar Formula R
New System Data Lookup Field Name Field Value Language Description VECTOR_TYPE_FLG D2MC ENG Specific Measuring Component VECTOR_TYPE_FLG D2PF ENG Profile Factor VECTOR_TYPE_FLG D2US ENG Channels Linked To Usage Subscription VECTOR_TYPE_FLG D2UT ENG Usage Transaction Service Quantity VEC_FORMULA_SRC _FLG D2CV ENG Conditional Vector Formula VEC_FORMULA_SRC _FLG D2SV ENG Simple Vector Formula Maintenance Object The following Maintenance Objects are new to V2.0.1.
New System Data Script Description D1-AuditVis Should Show if Audit List has an entry D1-BoFltrVal Validate Identifier Filters D1-CCInpVal Cancel Command Input Validation D1-CCOUTMSG Create OutBound message (Connect/ Disconnect) D1-CECD Check for existing future Connects or Disconnects D1-CEvtGoTo Completion Event - Go to Completion Event D1-CEvtRetDt Completion Event - Retrieve Details for Display D1-CHKIMD Check for IMD D1-CHKMST Check Existence of Measurements D1-CLCOC Create Outbou
New System Data Script Description D1-CreSRSeed Instantiate a Sync Request Seeder D1-CreSyRSdr Create Sync Request Seeder from Error Record D1-DCVALDEC Default Configuration Validation of Device Event C D1-DDACINFO Device Activity with Duration Information D1-DEvtMain Device Event - Maintenance D1-DEvtTMain Device Event Type - Maintenance D1-DIFDVEVTC Method Differs By Device Event Category D1-DMRO Default Measurement Requested D1-DVCEVTVAL Validate Device Event Parameters D1-DVEVTINFO
New System Data Script Description D1-IMDEvUpld Multiple IMD and Event Upload D1-IMDEvtUpl IMD and Event Upload D1-IMDUpPosM Online IMD and Event Upload: Post Map Processing D1-IMDUpPosP Online IMD and Event Upload: Post Processing D1-INITACT Initiate Activity D1-InitCmd Initiate Meter Command D1-MeasValDe Get Measurement Value Descriptions D1-MsrmtDisp Measurement Data Display D1-MsrmtMain Measurement Maintenance D1-RFINSC Retrieve Scalar Final Measurements D1-RFINTM Retrieve Interv
New System Data Script Description D1-RtODRDtls Retrieve Details On Demand Read Display D1-RtODRSCDt Retrieve Details On Demand Read Scalar Display D1-RtRCDtls Remote Connect - Retrieve Details for Display D1-RtRDDtls Remote Disconnect - Retrieve Details for Display D1-SANFS Alert - Show Non-Final Activities linked to MC, US, Device, MC, Contac D1-SNDRDTEA Send On Demand Read to Edge Application D1-SODRTEA Send On-Demand Read to Edge Application D1-SRCNTEA Send Connect or Disconnect Notifi
New System Data Script Description D1-TranRelCS Transition Related Composite Sync Request D1-TranToNeg Do Not Clear Exceptions and Transition to Negative State D1-TrnIEStat Translate Install Event Status D1-TrnOnOff Translate/Suppress On/Off History D1-VALCOMTP Validate Communication Type D1-VALDEVMC Validate that Device has appropriate MC D1-VALDVCEVT Validate Device Event D1-VALDVCNAC Validate Device Not Already Commissioned D1-VALDVCNAD Validate Device Not Already Decommissioned D1-V
New System Data Script Description D2-ADS-Info Aggregator Dimension Scanner Information D2-ADS-TR Check if Aggregator Creator has Performed a Single Scan D2-AMC-Info Service Type and Postal Aggregator Information D2-ActDisp Retrieve Activity Details D2-AddCCBAlg Insert CCB-specific algorithms to Sync Request BOs (MDM) D2-AddCCBSS Insert CCB-specific algorithms to Sync Request BOs D2-AggDisp Retrieve Service Type and Potal Aggregator Details D2-AggFltVal Validate Aggregator Identifier Filte
New System Data Script Description D2-UTSeedVal Usage Transaction Seeder Validation D2-UsgTraPre Usage Transaction Pre-Processing D2-V360Addr Validate Address filters D2-V360Dvc Validate Device filters D2-V360Name Validate Name filters D2-Val-AMCT Validate Aggregator Measuring Component Type D2_MCCalcInf Get MC Calc Information D2_QtyInfo Format the quantity information D2_SEDttmInf Format the start and end date/time information D2_SEQtyInfo Format the start and end quantity informatio
New System Data Portal Description D1COMMQ Communication Query D1COMMTY Communication Type D1DETYP Device Event Type D1DVCEVQ Device Event Query D1DVCEVT Device Event D1DVCEVTL Device Event Log D1MCTYQ Measuring Component Type Query D1SYNCILOG Sync Request Inbound Log D1SYNCIN Sync Request Inbound D1SYNCIQ Sync Request Inbound Query D1SYRINE Sync Request Inbound Exceptions D2360ADD 360 Search by Address D2360DEV 360 Search by Device D2360NAM 360 Search by Name D2TOTR Total an
New System Data Portal Zone D1DETYP D1-DETYPDISP D1DETYP D1-DETYPLIST D1DVCEVQ D1-DVCEVTQRY D1DVCEVT D1-DVEVTDISP D1DVCEVTL D1-DVCEVTLOG D1DVCTYP D1-DETYPDISP D1IMDSA D1-MSRMTIM D1IMLOG D1-AUDLSDISP D1MC D1-MSRMTS D1MCTYQ D1-MCTYQRY D1SP D1-SPMCSRLST D1SYNCILOG D1-SYNINLOG D1SYNCIN D1-SYNINDISP D1SYNCIN D1-SYNINEXCZ D1SYNCIQ D1-SYNRINQRY D1SYRINE D1-SYNCRINED D1SYRINE D1-SYNCRINES D1UTNM D2-SUBUTLIST D1UTNM D2_UTSCLARDT D2360ADD D2-360SRCAD D2360DEV D2-360SRCDV D
New System Data UI Map The following UI Maps are new to V2.0.1.
New System Data Map Description D1-CommNmAdrDtQryFltr Communication - Name Address Date Query D1-CommTypeCommonAction Communication Type Common Action Buttons D1-CommTypeCommonMaint Communication Type Common Maintenance D1-CommTypeCommonOnClick Communication Type Common On Click Actions D1-CommTypeMainDisp Communication Type Common Display Main D1-CommTypeRecordInfoDisp Comm Type Common Display - Record Info D1-CommonIMDMainDisplay Common Initial Measurement Data Fragment D1-CommunicationCo
New System Data Map Description D1-DeviceEventSeederDisp Device Event Seeder - Display D1-DeviceEventSeederMainDisp Device Event Seeder Main Display D1-DeviceEventSeederMainMaint Device Event Seeder Main Maintenance D1-DeviceEventSeederMaint Device Event Seeder - Maintenance D1-DeviceEventSenderDisp Device Event Sender Display D1-DeviceEventSenderMaint Device Event Sender Maintenance D1-DeviceEventTypeDisp Device Event Type Main Display D1-DeviceEventTypeMaint Device Event Type Main Mainte
New System Data Map Description D1-DvcFuncStateLookupMaint SGG Device Func State Lkup Maintenance D1-DvcWithDuratnActivityDisp Device Activity with Duration - Display D1-DvcWithDuratnActivityMaint Device Activity with Duration - Maint D1-EnterDiscardReason Enter Discard Reason D1-EventBarDeviceEventType Event Bar Device Event Type Grid D1-ExcHndlMaint Exception Handling Maintenance D1-ExecutionPriorityDisplay Execution Priority Lookup - Display D1-ExecutionPriorityLookupDisp Execution Prio
New System Data Map Description D1-IMDUploadDispRslt Online IMD and Event Upload Results D1-IntStsCodeToCondMapDisp Interval Status Code to Condition Mapping Lookup - Display D1-IntStsCodeToCondMapMaint Interval Status Code to Condition Mapping - Maintenance D1-LoadActionCodeLookupDisplay Load Action Code Lookup - Display D1-LoadActionCodeLookupMaint Load Action Code Lookup - Maintenance D1-MCMeasurementsFilter Measurements Filter Fragment D1-NoValidCEvtForActivity No valid Completion events
New System Data Map Description D1-ParentActQryFltr Parent Activity Query Filter D1-ProcessingMethodCommonMaint Processing Method Common Maintenance D1-RemoteConnectDisplay Remote Connect - Display D1-RemoteConnectMaint Remote Connect - Maintenance D1-RemoteConnectTypeDisplay Remote Connect Type - Display D1-RemoteConnectTypeMaint Remote Connect Type Maintenance Map D1-RemoteDisconnectDisplay Remote Disconnect - Display D1-RemoteDisconnectMaint Remote Disconnect - Maintenance D1-RemoteDis
New System Data Map Description D1-YesNoLookupMaint Lookup Maintenance - Yes/No This is a Maintenance UI Map f Maintenance UI Map for the Head-end UOM D2-360AddressSearchFilter 360 Search by Address Filter Area D2-360DeviceSearchFilter 360 Search by Device Filter Area D2-360NameSearchFilter 360 Search by Name/Address Filter Area D2-AggDimScannerActDisp Aggregator DS Activity-Display D2-AggDimScannerActMaint Aggregator DS Activity-Maintenance D2-AggDimScannerActTypeDisp Aggregator DS Activi
New System Data XAI Inbound Service The following XAI Inbound Services are new to V2.0.1.
New System Data Zone Zone Type Description D1-OMSPEXT F1-DE-SINGLE Build Service Provider Outbound Message Type D1-RETCRSIE F1-DE-SINGLE Retrieve bo and Arming Status for IE D1-RETDCINSY F1-DE-SINGLE Get related Device Config Sync Request D1-RETLATLOG F1-DE-SINGLE Retrieve latest log entry D1-RETSTCOND F1-DE-SINGLE Validate State Condition of Smart Device D1-SYNCRINED F1-MAPEXPL Sync Request Inbound Exception Details D1-CHKSREXST F1-DE-SINGLE Check Sync Request Inbound existence D1-
New System Data Zone Zone Type Description D1-SYNCRINES F1-DE-SINGLE Sync Request Inbound Exception Summary D1-SYNINEXCP F1-DE-SINGLE Sync Request Exception Details D1-SYNRINQ2 F1-DE-QUERY Sync Request Inbound Id D1-TBLSRCH F1-DE-QUERY Table Search D1-COMMQ2 F1-DE-QUERY Device Information D1-COMMQ3 F1-DE-QUERY Communication Identifier D1-DETYPLIST F1-DE-SINGLE Device Event Type List D1-DVCEVTQ2 F1-DE-QUERY Device Event ID D1-RETCEVT F1-DE-SINGLE Retrieve Completion Event D1-RE
New System Data Zone Zone Type Description D1-RETRR F1-DE-SINGLE Retrieve Requesters D1-SYNEXCDET F1-DE-SINGLE Sync Request Exception Details D1-CEVTRELOB F1-DE Completion Event Related Objects D1-COMMQRY F1-DE-MULQRY Communication Search D1-DETMCTYP F1-DE-SINGLE Determine Measuring Component Type D1-EXTACT F1-DE-SINGLE Retrieve Activity from External Activity D1-MCTYQ1 F1-DE-QUERY Measuring Component Type Search D1-MCTYQRY F1-DE-MULQRY Measuring Component Type Search D1-RETDDVCB
New System Data Zone Zone Type Description D1-SYNRINQRY F1-DE-MULQRY Sync Request Inbound Search D2-TMDPRD F1-DE-SINGLE Date Period for which TOU Map Data Exists D2-AGGMCQRY F1-DE-MULQRY Aggregator Search D2-UTSUB F1-DE-SINGLE Obtain list of Sub Usage Transaction D2_UTSCLARDT F1-DE Usage Transaction Scalar Details D2_GETSCLSP F1-DE-SINGLE Retrieve SP Details From Usage Scalar Details D2-360SRCAD F1-DE Search by Address D2_GETSCLMC F1-DE-SINGLE Retrieve MC Details From Usage Scalar
New System Data A-52 Oracle Utilities Meter Data Management Database Administrator’s Guide
Appendix B Upgrades to the Oracle Utilities Application Framework Database This document describes the database upgrade process for the Oracle Utilities Application Framework database from last released blueprint version of V4.1.0 to V4.1.0 Group Fix 2 It highlights changes made to the administrative tables and how those changes should be applied to the data in order for your current database to work with the V4.1.0.
Automatic Data Upgrade 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.
Automatic Data Upgrade None Dropped Tables None Unsupported Tables None Added Columns The following Table Columns are added to Oracle Utilities Application Framework V4.1.0.
New System Data New System Data This section lists the new system data that are added for business process configuration. Algorithm Type The following algorithm types are new to V4.1.0 Group Fix2. Algorithm Type Description F1-ATCHM-INF Attachment Information F1-BOSTATFS Take BO Status/Reason Final Snapshot F1-CMPSNAPSR Compare Initial and Final Snapshot.
New System Data Algorithm Description F1-WAITFRSRE Wait for Finalized Related Sync Request to be Extracted Application Service The following Application Services are new to V4.1.0 Group Fix2. Application Service Description F1-ATTACHMENTBOAS Attachment Based BO F1-STASKTYPE Service Task Type MO F1-SVCTASK Service Task MO Access Mode Added to Application Service The following Access Mode is added to existing Application Services and is new to V4.1.0 Group Fix2.
New System Data Business Object The following Business Objects are Framework Owned system data in V4.1.0 Group Fix2.
New System Data Lookup Field Name Field Value Languag e ALG_ENTITY_FLG F1SE ENG Sync Request - Initial Load Eligibility ALG_ENTITY_FLG F1SF ENG Sync Request - Initial Load Filter BUS_OBJ_OPT_FLG F1BI ENG Binary BUS_OBJ_OPT_FLG F1BO ENG Business Object to Read BUS_OBJ_OPT_FLG F1CT ENG Content Type BUS_OBJ_OPT_FLG F1DA ENG Snapshot Data Area BUS_OBJ_OPT_FLG F1EP ENG Element Population Rule BUS_OBJ_OPT_FLG F1ET ENG Batch Process for Extract BUS_OBJ_OPT_FLG F1MC ENG Manage
New System Data Lookup Field Name Field Value Languag e Description INS_ALG_ENTITY_FLG F1LD ENG Ldap Import NAV_OPT_TYPE_FLG F1AT ENG Attachment NBR_GRP_SYMBOL Z ENG South Asian RCVR_CTXT_FLG JMSP ENG JMS Password RCVR_CTXT_FLG JMSU ENG JMS User SENDER_CTXT_FLG JMSH ENG JMS Header UI_MAP_TYPE_FLG F1XL ENG Complete XHTML Document UI_MAP_TYPE_FLG F1XR ENG XHTML Fragment XAI_OPTION_FLG ALOC ENG WSDL service address location Maintenance Object The following Maintenance O
New System Data Script Description F1-VSyncBoOp Validate Sync BO Options F1-WaitFRSRE Wait for Finalized Related Sync Request to be Extracted F1-XMLSnapBO Return XML Snapshot of a BO Instance To do Type The following To Do type is new to V4.1.0 Group Fix2. None Portal The following Portal is new to V4.1.0 Group Fix2. None Portal Zone The following Portal Zones are added to V4.1.0 Group Fix2 None UI Map The following UI Maps are Framework Owned system data in V4.1.0 Group Fix2.
New System Data The following new Zones are added to V4.1.0 Group Fix2.
Appendix C Oracle Application Framework System Table Guide This section lists the system tables owned by the Oracle Utilities Application Framework V4.1.0 and explains the data standards of the system tables. The data standards are required for the installation of Oracle Utilities Application Framework, development within the Oracle Utilities Application Framework, and the configuration and customization of Oracle Utilities products.
About the Application Framework System Tables About the Application Framework System Tables System tables are a subset of the tables that must be populated at the time the product is installed. They include Metadata and configuration tables. The data stored in the system tables are the information that Oracle Utilities Application Framework product operations are based on. As the product adds more functionality, the list of system tables can grow.
Guidelines for System Table Updates Guidelines for System Table Updates This section describes guidelines regarding the updating of the system table properties. Business Configuration Tables The majority of data in the tables in this group belongs to the customer. But these tables are shipped with some initial data in order for the customer to login to the system and begin configuring the product.
Guidelines for System Table Updates DB Process Properties Description Tables CI_DB_PROC, CI_DB_PROC_L, CI_DB_INSTR, CI_DB_INSTR_L, L, CI_DB_INSTR_OVRD Initial Data Copy DB Process (CL-COPDB). This DB process allows users to copy a DB process from one database to another using Config Lab utility. Display Profile The Display Profile Code is referenced in the User (SC_USER) table. Properties Description Tables CI_DISP_PROF, CI_DISP_PROF_L Initial Data North America (NORTHAM) and Europe (EURO).
Guidelines for System Table Updates To Do Priority and Role New To Do Types released will be linked to the default To Do Role and set to the product assigned priority value initially. These initial settings can be overridden by the implementation. Properties Description Tables CI_ROLE(L), CI_TD_VAL_ROLE Initial Data F1_DFLT Development and Implementation System Tables This section defines the standards for the system tables that contain data for application development.
Guidelines for System Table Updates Algorithm Properties Description Tables CI_ALG, CI_ALG_L, CI_ALG_PARM, CI_ALG_VER Standard Data Fields Algorithm (ALG_CD) Customer Modification None Application Security Properties Description Tables SC_APP_SERVICE, SC_APP_SERVICE_L, CI_APP_SVC_ACC Standard Data Fields Application Service ID (APP_SVC_ID). Customer care and billing products prior to version 2.0 will continue to use CI as a prefix for the application service.
Guidelines for System Table Updates Business Object Properties Description Tables F1_BUS_OBJ, F1_BUS_OBJ_L, F1_BUS_OBJ_ALG, F1_BUS_OBJ_OPT, F1_BUS_OBJ_STATUS, F1_BUS_OBJ_STATUS_L, F1_BUS_OBJ_STATUS_ALG, F1_BUS_OBJ_STATUS_OPT, F1_BUS_OBJ_STATUS_RSN, F1_BUS_OBJ_STATUS_RSN_L, F1_BUS_OBJ_STATUS_RSN_CHAR F1_BUS_OBJ_TR_RULE, F1_BUS_OBJ_TR_RULE_L Standard Data Fields Business Object (BUS_OBJ_CD) Customer Modification Batch Control (BATCH_CD), Alert (BO_ALERT_FLG), Sequence (SORT_SEQ5), Status Reason (STATU
Guidelines for System Table Updates Properties Description Customer Modification Adhoc Characteristic Value Validation Rule (ADHOC_VAL_ALG_CD) on Characteristic Entity Table (CI_CHAR_ENTITY) Properties Description Tables F1_DATA_AREA, F1_DATA_AREA_L Standard Data Fields Data Area Code (DATA_AREA_CD) Customer Modification None Data Area Display Icon Properties Description Tables CI_DISP_ICON, CI_DISP_ICON_L Standard Data Fields Display Icon Code (DISP_ICON_CD) Customer Modification None
Guidelines for System Table Updates Properties Description Standard Data Fields Field Name (FIELD_NAME) • A lookup field name must have corresponding field metadata. The name of the lookup field column must be assigned to avoid conflicts among different products. If you follow the standards for database field names, a Customer Modification lookup field name will be automatically Customer Modification prefixed.
Guidelines for System Table Updates Managed Content Properties Description Tables F1_MANAG_CONTENT, F1_MANAG_CONTENT_L Standard Data Fields Managed Content (MANAG_CONTENT_CD) Customer Modification None Messages Properties Description Tables CI_MSG_CATEGORY, CI_MSG_CATEGORY_L, CI_MSG, CI_MSG_L C-10 Oracle Utilities Meter Data Management Database Administrator’s Guide
Guidelines for System Table Updates Properties Description Standard Data Fields Message Category (MESSAGE_CAT_NBR) • Messages are grouped in categories and each category has message numbers between 1 and 99999. A range of message categories is assigned to a product. You must use only the assigned category for your product.
Guidelines for System Table Updates Properties Description Customer Modification Override Description (DESCRLONG_OVRD), Message Text Override (MESSAGE_TEXT_OVRD) Meta Data - Table and Field Properties Description Tables CI_MD_TBL, CI_MD_TBL_FLD, CI_MD_TBL_L, CI_MD_TBL_FLD_L, CI_MD_FLD, CI_MD_FLD_L, F1_DB_OBJECTS_REPO Standard Data Fields Table Name (TBL_NAME) • Table names must match with the physical table name or view name in the database.
Guidelines for System Table Updates Meta Data - Constraints Properties Description Tables CI_MD_CONST, CI_MD_CONST_FLD Standard Data Fields Constraint Id (CONST_ID) • Index Name for Primary Constraints • Rnn for Foreign Key Constraints Where • Customer Modification nn: integer, 01 through 99 None Meta Data - Menu Menus can be extended to support multiple products by adding a new menu line to an existing menu.
Guidelines for System Table Updates Properties Description Standard Data Fields Program Component Id (PROG_COM_ID), Location Id (LOC_ID), Program Component Name (PROG_COM_NAME), Service Name (SVC_NAME), Navigation Key (NAVIGATION_KEY) Customer Modification User Exit Program Name (USER_EXIT_PGM_NAME) on Program Components Table (CI_MD_PRG_COM), Meta Data - Maintenance Object Properties Description Tables CI_MD_MO, CI_MD_MO_L, CI_MD_MO_TBL, CI_MD_MO_OPT, CI_MD_MO_ALG Standard Data Fields Maintenan
Guidelines for System Table Updates Navigation Option Properties Description Tables CI_NAV_OPT, CI_NAV_OPT_L, CI_NAV_OPT_CTXT, CI_NAV_OPT_USG, CI_MD_NAV Standard Data Fields Navigation Option Code (NAV_OPT_CD), Navigation Key (NAVIGATION_KEY) Customer Modification None Oracle Application Framework System Table Guide C-15
Guidelines for System Table Updates Portal and Zone Properties Description Tables CI_PORTAL, CI_PORTAL_L, CI_PORTAL_ZONE, CI_ZONE, CI_ZONE_L, CI_ZONE_PRM, CI_ZONE_HDL, CI_ZONE_HDL_L, CI_ZONE_HDL_PRM, CI_ZONE_HDL_PRM_L, CI_UI_ZONE Standard Data Fields Portal Code (PORTAL_CD), Zone Code (ZONE_CD), Zone Type Code (ZONE_HDL_CD) • A new Zone can be added to the Product owned Portal Pages. • The existing Zones cannot be removed from the Product owned Portal Pages.
Guidelines for System Table Updates Properties Description Tables F1_SCHEMA Standard Data Fields Schema Name (SCHEMA_NAME) Customer Modification None Properties Description Tables CI_SCR, CI_SCR_L, CI_SCR_CRT, CI_SCR_CRT_GRP, CI_SCR_CRT_GRP_L, CI_SCR_DA, CI_SCR_FLD_MAP, CI_SCR_PRMPT, CI_SCR_PRMPT_L, CI_SCR_STEP, CI_SCR_STEP_L Standard Data Fields Script (SCR_CD) Customer Modification None Properties Description Tables CI_TD_TYPE, CI_TD_TYPE_L, CI_TD_SRTKEY_TY, CI_TD_DRLKEY_TY, CI_TD_SRTK
Guidelines for System Table Updates XAI configuration Properties Description Tables CI_XAI_ADAPTER, CI_XAI_ADAPTER_L, CI_XAI_CLASS, CI_XAI_CLASS_L, CI_XAI_ENV_HNDL, CI_XAI_ENV_HNDL_L, CI_XAI_FORMAT, CI_XAI_FORMAT_L, CI_XAI_RCVR, CI_XAI_RCVR_L, CI_XAI_RCVR_CTX, CI_XAI_RCVR_RSP, CI_XAI_RCVR_RGRP, CI_XAI_SENDER, CI_XAI_SERNDER_L, CI_XAI_SNDR_CTX, CI_XAI_OPTION Standard Data Fields Adapter Id (XAI_ADAPTER_ID), Class Id (XAI_CLASS_ID), Envelope Handler Id (XAI_ENV_HNDL_ID), XAI Format Id (XAI_FORMAT_ID), R
Guidelines for System Table Updates Oracle Utilities Application Framework Only Tables All data of the tables in this group belong to the Oracle Utilities Application Framework. No data modification or addition is allowed for these tables by base product development and customer modification. When an environment is upgraded to the next release of the Oracle Utilities Application Framework, the upgrade process will refresh the data in these tables.
System Table List System Table List This section contains names of system tables, upgrade actions, and a brief description of tables. The upgrade actions are explained below. Keep (KP): The data in the table in the customer's database is kept untouched. No insert or delete is performed to this table by the upgrade process. The initial installation will add necessary data for the system Merge (MG): The non-base product data in the table in the database is kept untouched.
System Table List Table Name Upgrade Action Description CI_CURRENCY_CD KP Currency Code CI_CURRENCY_CD_L KP Currency Code Language CI_DB_INSTR KP DB Process Instruction CI_DB_INSTR_ALG KP DB Process Instruction Algorithm CI_DB_INSTR_L KP DB Process Instruction Language CI_DB_INST_OVRD KP DB Process Instruction Override CI_DB_PROC KP DB Process CI_DB_PROC_L KP DB Process Language CI_DISP_ICON MG Display Icon CI_DISP_ICON_L MG Display Icon Language CI_DISP_PROF KP Display P
System Table List Table Name Upgrade Action Description CI_MD_LOOKUP RF MD Lookup Field Value CI_MD_LOOKUP_F RF MD Lookup Field CI_MD_MENU MG Menu Information CI_MD_MENU_IMOD MG Menu Item Module Maint CI_MD_MENU_ITEM MG Menu Item CI_MD_MENU_ITEM_L MG Menu Item Language CI_MD_MENU_L MG Menu Language CI_MD_MENU_LINE MG Menu Line CI_MD_MENU_LINE_L MG Menu Line Language CI_MD_MENU_MOD MG Menu Product Components CI_MD_MO MG Maintenance Object CI_MD_MO_ALG MG Maintenance Obj
System Table List Table Name Upgrade Action Description CI_MD_SOCG_FLD MG Search Object Criteria Group Field CI_MD_SOCG_FLDAT MG Search Criteria Group Field Attribute CI_MD_SOCG_L MG Search Object Criteria Group Language CI_MD_SOCG_SORT MG Search Criteria Group Result Sort Order CI_MD_SO_L MG Search Object Language CI_MD_SO_RSFLD MG Search Object Result Field CI_MD_SO_RSFLDAT MG Search Object Result Field Attribute CI_MD_SRC_TYPE RF Source Type CI_MD_SRC_TYPE_L RF Source Type L
System Table List Table Name Upgrade Action Description CI_MSG_CATEGORY_L MG Message Category Language CI_MSG_L MG Message Language CI_NAV_OPT MG Navigation Option CI_NAV_OPT_CTXT MG Navigation Option Context CI_NAV_OPT_L MG Navigation Option Language CI_NAV_OPT_USG MG Navigation Option Usage CI_PORTAL MG Portal CI_PORTAL_L MG Portal Language CI_PORTAL_ZONE MG Portal Zone CI_SCR MG Script CI_SCR_CRT MG Script Criteria CI_SCR_CRT_GRP MG Script Criteria Group CI_SCR_CRT
System Table List Table Name Upgrade Action Description CI_XAI_ENV_HNDL MG XAI Envelope Handler CI_XAI_ENV_HNDL_L MG XAI Envelope Handler Language CI_XAI_EXECUTER RF XAI Executer CI_XAI_EXECUTER_L RF XAI Executer Language CI_XAI_FORMAT RF XAI Format CI_XAI_FORMAT_L RF XAI Format Language CI_XAI_IN_SVC MG XAI Inbound Service CI_XAI_IN_SVC_L MG XAI Inbound Service Language CI_XAI_JNDI_SVR KP XAI JNDI Server CI_XAI_JNDI_SVR_L KP XAI JNDI Server Language CI_XAI_OPTION KP XAI
System Table List Table Name Upgrade Action Description F1_BUS_OBJ_STATUS_AL G MG Business Object Status Algorithm F1_BUS_OBJ_STATUS_L MG Business Object Status Language F1_BUS_OBJ_STATUS_OP T MG Business Object Status Option F1_BUS_OBJ_STATUS_RS N MG Status Reason F1_BUS_OBJ_STATUS_RS N_CHAR KP Status Reason Characteristic F1_BUS_OBJ_STATUS_RS N_L MG Status Reason Language F1_BUS_OBJ_TR_RULE MG Business Object Transition Rule F1_BUS_OBJ_TR_RULE_L MG Business Object Transition Rul
System Table List Table Name Upgrade Action Description SC_USR_GRP_USR KP User Group User Oracle Application Framework System Table Guide C-27
System Table List C-28 Oracle Utilities Meter Data Management Database Administrator’s Guide
Appendix D Partitioning Recommendations for Oracle Utilities Meter Data Management This section specifies the partitioning and compression strategies recommended for an initial Oracle Utilities Meter Data Management database configuration on Exadata. It includes the following topics: • Partitioning Recommendations • Compression Recommendations Partitioning Recommendations In general, the recommendation is for a minimum of 'n' partitions for selective database objects, where 'n' is number of RAC nodes.
• D1_INIT_MSRMT_DATA_CHAR • D1_INIT_MSRMT_DATA_K • D1_INIT_MSRMT_DATA_LOG • D1_INIT_MSRMT_DATA_LOG_PARM D1_MSRMT CREATE TABLE D1_MSRMT ( MEASR_COMP_ID CHAR(12 BYTE) NOT NULL ENABLE, MSRMT_DTTM DATE NOT NULL ENABLE, BO_STATUS_CD CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE, MSRMT_COND_FLG CHAR(6 BYTE) DEFAULT ' ' NOT NULL ENABLE, MSRMT_USE_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE, MSRMT_LOCAL_DTTM DATE NOT NULL ENABLE, MSRMT_VAL NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE, ORIG_INIT_MSRMT_ID CHAR(14 BYTE
PARTITION P7 VALUES LESS THAN(TO_DATE('15/03/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')) ); CREATE UNIQUE INDEX D1T298P0 on D1_MSRMT (MEASR_COMP_ID, MSRMT_DTTM) TABLESPACE local COMPRESS 1; alter table D1_MSRMT ADD CONSTRAINT D1T298P0 PRIMARY KEY(MEASR_COMP_ID, MSRMT_DTTM) USING INDEX TABLESPACE ; Note: For implementations on Exadata the following D1T298S1 Index is not required: CREATE UNIQUE INDEX D1T298S1 on D1_MSRMT (MEASR_COMP_ID, MSRMT_DTTM, MSRMT_COND_FLG, MSRMT_USE_
D1_MSRMT_CHAR CREATE TABLE D1_MSRMT_CHAR ( MEASR_COMP_ID CHAR(12 BYTE) NOT NULL ENABLE, MSRMT_DTTM DATE NOT NULL ENABLE, CHAR_TYPE_CD CHAR(8 BYTE) NOT NULL ENABLE, SEQ_NUM NUMBER(3,0) NOT NULL ENABLE, CHAR_VAL CHAR(16 BYTE) DEFAULT ' ' NOT NULL ENABLE, ADHOC_CHAR_VAL VARCHAR2(254 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK1 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK2 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK3 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK4 VAR
D1_MSRMT_LOG CREATE TABLE D1_MSRMT_LOG ( MEASR_COMP_ID CHAR(12 BYTE), MSRMT_DTTM DATE, SEQNO NUMBER(5,0), ORIG_INIT_MSRMT_ID CHAR(14 BYTE) DEFAULT ' ' NOT NULL ENABLE, BUS_OBJ_CD CHAR(30 BYTE) DEFAULT ' ' NOT NULL ENABLE, BO_DATA_AREA CLOB, CHAR_TYPE_CD CHAR(8 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL CHAR(16 BYTE) DEFAULT ' ' NOT NULL ENABLE, ADHOC_CHAR_VAL VARCHAR2(254 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK1 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK2 VARCHAR2(50 BYTE) DEFAULT '
ALTER TABLE D1_MSRMT_LOG ADD CONSTRAINT D1T300P0 PRIMARY KEY (MEASR_COMP_ID, MSRMT_DTTM, SEQNO) USING INDEX TABLESPACE ; CREATE INDEX D1T300S1 ON D1_MSRMT_LOG ( CHAR_TYPE_CD, CHAR_VAL_FK1 ) TABLESPACE COMPRESS 1; CREATE INDEX D1T300S2 ON D1_MSRMT_LOG ( CHAR_TYPE_CD, CHAR_VAL ) TABLESPACE COMPRESS 1; CREATE INDEX D1T300S3 ON D1_MSRMT_LOG ( ORIG_INIT_MSRMT_ID) TABLESPACE local COMPRESS 1; D1_MSRMT_LOG_PARM CREATE TABLE D1_MSRMT_LOG_PARM (
); CREATE UNIQUE INDEX D1T301P0 ON D1_MSRMT_LOG_PARM ( MEASR_COMP_ID, MSRMT_DTTM, SEQNO, PARM_SEQ ) INDEX TABLESPACE local COMPRESS 1; ALTER TABLE D1_MSRMT_LOG_PARM ADD CONSTRAINT D1T301P0 PRIMARY KEY (MEASR_COMP_ID, MSRMT_DTTM, SEQNO, PARM_SEQ) USING INDEX TABLESPACE ; D1_INIT_MSRMT_DATA CREATE TABLE D1_INIT_MSRMT_DATA ( INIT_MSRMT_DATA_ID CHAR(14 BYTE) NOT NULL ENABLE, MEASR_COMP_ID CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE, D1_FROM_DTTM DATE, D1_TO_DTTM DATE, DATA_SRC_
PARTITION P2 VALUES LESS THAN(TO_DATE('01/01/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')), PARTITION P3 VALUES LESS THAN(TO_DATE('15/01/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')), PARTITION P4 VALUES LESS THAN(TO_DATE('01/02/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')), PARTITION P5 VALUES LESS THAN(TO_DATE('15/02/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')), PARTITION P6 VALUES LESS THAN(TO_DATE('01/03/2011 00:00:01','DD/MM/ YYYY HH24:MI:SS')), PARTITION P7 VALUES LESS THAN(TO_DATE('15/03/2011 00:00:01','DD/MM/ YYYY
CHAR_VAL_FK2 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL CHAR_VAL_FK3 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL CHAR_VAL_FK4 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL CHAR_VAL_FK5 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL SRCH_CHAR_VAL VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE) TABLESPACE ENABLE ROW MOVEMENT PARTITION BY RANGE (INIT_MSRMT_DATA_ID) (PARTITION PART1 values less than (12499999999999), PARTITION PART2 values less than (24999999999999), PARTITION PA
BO_STATUS_REASON_CD VARCHAR2(30 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_TYPE_CD CHAR(8 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL CHAR(16 BYTE) DEFAULT ' ' NOT NULL ENABLE, ADHOC_CHAR_VAL VARCHAR2(254 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK1 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK2 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK3 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK4 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE, CHAR_VAL_FK5 VARCHAR2(50 BYTE) DEFA
(PARTITION PART1 values less than (12499999999999), PARTITION PART2 values less than (24999999999999), PARTITION PART3 values less than (37499999999999), PARTITION PART4 values less than (49999999999999), PARTITION PART5 values less than (62499999999999), PARTITION PART6 values less than (74499999999999), PARTITION PART7 values less than (87499999999999), PARTITION PART8 values less than (maxvalue)) ; CREATE UNIQUE INDEX D1T307P0 ON D1_INIT_MSRMT_DATA_LOG_PARM ( INIT_MSRMT_DATA_ID, SEQNO, PARM_SEQ) TABLESPA
D-12 Oracle Utilities Meter Data Management Database Administrator’s Guide
Appendix E License and Copyright Notices License and Copyright notices for associated products: Third Party Products Notice concerning usage of ANTLR and Classycle [The BSD License] Copyright (c) 2010 Terence Parr All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
2. castor-1.3.1-core.jar 3. castor-1.3.1-xml.jar 4. castor-1.3.1-xml-schema.jar 5. cglib-2.2.jar 6. classycle.1.1.jar 7. commons-beanutils-core-1.8.1.jar 8. commons-cli-1.1.jar 9. commons-codec-1.4.jar 10. commons-collections-3.1.jar 11. commons-fileupload-1.2.1.jar 12. commons-httpclient-3.0.1.jar 13. commons-io-1.3.2.jar 14. commons-lang-2.2.jar 15. ehcache-1.2.3.jar 16. log4j-1.2.15.jar 17. qdox.1.6.1.jar 18. serializer-2.7.1.jar 19. stax2.jar 20. velocity.1.4.jar 21. wstx-asl-3.2.1.
"Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files. "Object" form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types.
NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License.
2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. Neither the name of the copyright holders nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Notice concerning usage of International Components for Unicode (ICU4J) COPYRIGHT AND PERMISSION NOTICE Copyright (c) 1995-2010 International Business Machines Corporation and others All rights reserved.
CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ Notice concerning usage of JCIP Annotations Attribution 2.
2. Fair Use Rights. Nothing in this license is intended to reduce, limit, or restrict any rights arising from fair use, first sale or other limitations on the exclusive rights of the copyright owner under copyright law or other applicable laws. 3. License Grant. Subject to the terms and conditions of this License, Licensor hereby grants You a worldwide, royalty-free, non-exclusive, perpetual (for the duration of the applicable copyright) license to exercise the rights in the Work as stated below: 1.
Work, upon notice from any Licensor You must, to the extent practicable, remove from the Derivative Work any credit as required by clause 4(b), as requested. 2.
2. Each time You distribute or publicly digitally perform a Derivative Work, Licensor offers to the recipient a license to the original Work on the same terms and conditions as the license granted to You under this License. 3.
THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Notice concerning usage of slf4j SLF4J source code and binaries are distributed under the MIT license. Copyright (c) 2004-2008 QOS.ch All rights reserved.
"Freely Available" means that no fee is charged for the item itself, though there may be fees involved in handling the item. It also means that recipients of the item may redistribute it under the same conditions they received it. 1.You may make and give away verbatim copies of the source form of the Standard Version of this Package without restriction, provided that you duplicate all of the original copyright notices and associated disclaimers. 2.
The End Notice concerning usage of Mime-Base64 Perl Module Copyright 1995-1999,2001-2004 Gisle Aas This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The standard version of the package that is used can be obtained from http://www.cpan.org. Specifically, the software can be obtained from the following link : http://search.cpan.
3.IBM would appreciate receiving a copy of derivative works of the Program that You create. You may provide to IBM such derivative works pursuant to the terms of this Agreement and the directions in the README file contained within the Program directory. You represent and warrant to IBM that You are the sole author of, and/or have full exclusive right, title and interest to any and all derivative works You provide to IBM.
COPYRIGHT The DBI module is Copyright (c) 1994-2004 Tim Bunce. Ireland. All rights reserved. This is distributed under the terms of the Artistic License. The standard version of the package that is used can be obtained from http://www.cpan.org. Specifically, the software can be obtained from the following link : http://search.cpan.
E-16 Oracle Utilities Meter Data Management Database Administrator’s Guide
