Impacted Customers CSV Export Includes Duplicates That are Not in the XML Export
Last updated on JANUARY 16, 2018
Applies to:Oracle Utilities Network Management System - Version 18.104.22.168 to 22.214.171.124 [Release 1.12]
Oracle Network Management for Utilities - DMS - Version 126.96.36.199 to 188.8.131.52 [Release 1.12]
Information in this document applies to any platform.
On : 184.108.40.206 version, Web Switching
The impacted customer list from Bi Publisher export in .csv format includes duplicates. The same plan exported in .xml does not have the same duplicates
Where a supply node has no customers attached or has all the customers excluded in SWMAN_DELETED_CUSTOMERS, the impacted customers CSV export from bi publisher includes the last customer from the previous supply node in a row for a supply node that has no customers.
If the data is exported as XML, the data is correct, in that the supply_node with no customers is included but has no customer child xml elements.
It is expected that the supply_node row with no customers should not exist in the csv output, or it should have empty data for the customer data.
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