Sensus Data Quality Code Mapping With MDM Condition Codes (Doc ID 2289066.1)

Last updated on AUGUST 01, 2017

Applies to:

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

Symptoms

Client have the requirement to map Sensus data quality code mapping with MDM condition codes as mentioned in the in the excel sheet embedded in the word document.
In Sheet 1, Column A have the Sensus Data quality codes, Column B is expected MDM condition code, Column C states whether to load the reads (1) or create exception (0)
Sheet 2 have MDM condition code mapping in the D6-IntStsCodeToCondMapLookup.

It appears OSB transforms the data quality codes into bit positions before loading into MDM.
For eg, N39 is tranformed into following bits - 5, 2, 1, 0
These bit positions are mapped in the D6-IntStsCodeToCondMapLookup extended lookup with the condition code in MDM and it appears the highest condition code are considered.

 

Changes

 

Cause

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