Initial Measurements

The usage data exported from the AMI head-end system as a file in Sensus RNI format is loaded into Oracle Utilities as Initial measurement data. The following OSB projects, delivered in the base product, help manage the usage processing:

  1. SGG-D6-USAGE-BASE contains components responsible for “actual” processing of incoming data. It should not be modified during configuration. This can be upgraded without affecting the customization and environment settings added to SGG-D6-USAGE-CM.

  2. SGG-D6-USAGE-CM allows for customization and simplifies future upgrades.

The runtime configuration settings for the SGG-D6-USAGE-CM project are stored in the xquery file EnvironmentSettings.xq. You can use this file to adjust initial measurement data processing. For example, if you want to load raw data you would specify “true” for the content of the populateRawIMD element.

The following table describes the elements included in the EnvironmentSettings.xq file:

Element

Description

Valid Values

populateRawIMD

Determines if the initial measurement data is populated as raw data.

true

false

callPreProcessing

Determines if the preprocessing proxy service is called.

true

false

callPostProcessing

Determines if the postprocessing proxy service is called.

true

false

destinationRootElementInterval

Holds the name of inbound web service for the interval IMD seeder.

destinationRootElementScalar

Holds the name of inbound web service for the scalar IMD seeder. In most cases it is the same as destinationRootElementInterval.

dateTimeInUTC

Indicates whether the Sensus RNI system is sending date/time information in UTC (true) or local time of the device (false). If not provided the default behavior will be local time of the device.

true

false

publishServices/service

Specifies the name of the business service within the OSB project used to publish data for external systems (such as Oracle DataRaker).

filterUsage

Determines if usage should be filtered.

true

false

useExternalTOU

Indicates whether or not an externally reference TOU period should be used when processing measurement data.

true

false

scalarExpanding

Defines the number of register reads to process in scalar payloads. When defined, Sensus payload processing uses this setting to ensure that all the scalar reads included in a payload will be processed.

Default value is 2.

Publishing Initial Measurement Data

The SGG adapter can be configured to publish initial measurement data for use in Oracle DataRaker or other external systems. This functionality is supported through a combination of OSB components and BPEL composites.

Enabling Initial Measurement Data Publishing

Publishing data is enabled by referencing a publisher business service in the publishServices/service element in the EnvironmentSettings.xq file as follows:
<publishServices>
  <service>[publisherBusinessService]</service>
</publishServices>

The following components provided with the SGG-D6-USAGE-CM OSB project are used in publishing measurement data to Oracle DataRaker:

  • The DataRakerBusinessService business service is used to send data to a pre-configured JMS queue (defined as an Endpoint URI), from which the data will be published. This is the business service that should be specified in the EnvironmentSettings.xq file.

  • The DataRakerServiceAccount service account is used to define and maintain the user name and password needed to access the JMS queue defined in the DataRakerBusinessService business service.

Configuring Initial Measurement Publishing Output

The SGGDRIntegration BPEL composite handles publishing the data to Oracle DataRaker or other systems. Initial measurement data is published in the “native” initial measurement data format (the format of the initial measurement seeder business object). This format includes normalized unit of measure and condition codes. See the Oracle Utilities Smart Grid Gateway Adapter Development Kit Administrative User Guide for more details about this format.

Note: Initial measurement data published through this feature is published prior to validation, estimation, and editing (VEE) processing. In addition, filtering cannot be applied to data published through this feature.

The following parameters can be used to configure details of how the data is provided to Oracle DataRaker, including the directory where files are posted for Oracle DataRaker to consume, number of records per file, polling frequency, etc. These parameters are defined during installation. See the Oracle Utilities Smart Grid Gateway Installation Guide for more details about defining values for these parameters.

Parameter

Description

Default Value

SGG_​DR_​INT_​QUEUE

JNDI name of queue to publish SGG payloads.

This is the JMS queue defined in the DataRakerBusinessService business service. This should NOT be changed.

DataRakerQueue

SOA_​DR_​PUBLISH_​SIZE

The number of records (SGG payloads) to accumulate in a published file.

100

SOA_​DR_​FILE_​SIZE

The maximum file size for the accumulated (SGG payloads) file in kilobytes.

524288

SOA_​DR_​ELAPSED_​TIME

The period of time in second which, when exceeded, causes a new outgoing file to be created.

600

SOA_​DR_​POLLING_​FREQ

The polling frequency in seconds of the staging directory for new files.

60

SOA_​DR_​STAGING_​DIR

Mount point/directory for the staging directory for accumulated SGG payload files.

This is used internally and should NOT be changed.

/spl/sploutput/staging

SOA_​DR_​INTEGRATION_​DIR

Mount point/directory from which Oracle DataRaker will consume the converted XML files.

/spl/sploutput/int

Filtering Initial Measurement Data

The SGG adapter can be configured to filter initial measurement data passed into SGG and the Oracle Utilities Meter Data Management application. Filtering data is enabled by setting the <filterUsage> element in the EnvironmentSettings.xq file to “true” as follows:
<filterUsage>true</filterUsage>

When filtering is enabled, only measurements whose <externalUOM> matches one of the values defined in the Sensus UOM Code to Standard UOM Mapping extendable lookup (D6-HeadendUOMLookup) are passed into the system for processing.

Processing Large Input Files

In some environments, the OSB project may begin processing a large input file before it has been completely copied to the input directory. To prevent this, configure the MinimumAge property in the “InboundProxyService” proxy service for the project. The MinimumAge property specifies the minimum age of files to be retrieved, based on the last modified time stamp. This enables large files to be completely copied to the input directory before they are retrieved for processing.

Prioritized Initial Measurement Processing

The SGG adapter prioritizes processing of initial measurements created from smart meter commands and/or completion events by setting the Execution Method flag in these types of initial measurements to “Real Time” (D1RT). In addition, initial measurements received with the Execution Method flag set to “Real Time” will be processed in real time rather than via batch processing. See Initial Measurement Data Prioritization in the Oracle Utilities Meter Data Management / Smart Grid Gateway Business User Guide for more information.