Search Query in Billing Care is Returning Duplicate Records
Last updated on MAY 18, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Billing Care
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.
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.
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