Sensus Data Quality Code Mapping With MDM Condition Codes
Last updated on JANUARY 07, 2018
Applies to:Oracle Utilities Meter Data Management - Version 126.96.36.199.0 and later
Oracle Utilities Smart Grid Gateway Adapter for Sensus RNI - Version 188.8.131.52.0 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.
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