MDM v2.2.0.0.0 and 2.2.0.1.0 Demo Database Contains Field NEVER_RCVD_MSRMT_FLG on D1_SP_SNAP_DL and Database for New Installation Does Not (Doc ID 2279557.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.1.0 and later
Information in this document applies to any platform.

Goal

While preparing for Meter Data Management upgrade from 2.1.0.3 to 2.2.0.1.0 it was observed that there is a difference between the database created from the Demo Data provided with 2.2.0.1.0 and when using upgrade scripts for upgrading the database.


There is a difference in the D1_SP_SNAP_DL table the field NEVER_RCVD_MSRMT_FLG exists in the Demo Database for 2.2.0.1.0 but does not exist when upgrading 2.1.0.3.0 environment to 2.2.0.1.0 and also does not exist when using 2.2.0.1.0 scripts for new installation.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms