My Oracle Support Banner

Search Query in Billing Care is Returning Duplicate Records (Doc ID 2397655.1)

Last updated on MARCH 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.17.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.17.0 version, Billing Care

ACTUAL BEHAVIOR
---------------
Billing Care search query is returning duplicate records due to which  number of unique records displayed is less than the pagination limit (or the range) specified.


STEPS
-----------------------
1. Login to Billing Care.
2. Search with Firstname or Lastname or Wild Characters.
3. Search records displayed is less than pagination limit. For example, if pagination limit was set to 20. Only 15 unique accounts are being displayed while the other 5 are duplicates.
4. Open CM pinlog and observe that duplicate records are returned in the pcm_op_search result.


Changes

 

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
Changes
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.