Search Query in Billing Care is Returning Duplicate Records

(Doc ID 2397655.1)

Last updated on MAY 18, 2018

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

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