My Oracle Support Banner

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

Last updated on MARCH 11, 2019

Applies to:

Oracle Utilities Meter Data Management - Version and later
Oracle Utilities Smart Grid Gateway Adapter for Sensus RNI - Version and later
Information in this document applies to any platform.


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.