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 220.127.116.11.0 and later
Oracle Utilities Smart Grid Gateway Adapter for Sensus RNI - Version 18.104.22.168.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.
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