My Oracle Support Banner

Search By Device Base Zone (D2-360SRCDV) Returning Redundant Records (Doc ID 2741725.1)

Last updated on JANUARY 05, 2021

Applies to:

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

Symptoms

**Examples provided in this article do not represent real life personal/confidential information. Please use proper values to your business.**
**Disclaimer:** This KM article may include the following abbreviations:

MDM-Oracle Utilities Meter Data Management

 On : MDM 2.3.0.2.0 version, Environment

ACTUAL BEHAVIOR
---------------
Search by Device Base Zone (D2-360SRCDV) returning redundant records.

SQL 2 in base zone D2-360SRCDV returns redundant rows.

It retrieves previous Usage Subscription - Service Point records.

STEPS TO RECREATE
-----------------------
1) Go to Menu * 360 Search * Search by Device
2) Search for a device using the following information:
   a. Choose ‘Badge Number’ in the DEVICE IDENTIFIER TYPE drop down
   b. Enter % in the IDENTIFIER VALUE field
3) Click on Search
4) The search results is displaying multiple rows.

Cause

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
Symptoms
Cause
Solution
References


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