My Oracle Support Banner

Customer Key Search On Organization Phone\Email Not Returning Any Results (Doc ID 2502759.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.


When using the Customer Key search on the email or phone number of the organization, no records are returned.  The seeded view IEX_LM_CKEY_PARTY_V is referencing the wrong table, causing no records to be retrieved for certain scenarios.

APP-IEX-240445 Query caused no records to be retrieved

Steps to Reproduce:

Responsibility: Collections Agent
: Search

1. Collections Agent: Search > select Customer By = Customer Key
2. Enter phone or email criteria and [Search]
3. Only matching contact parties found. Organizations with email/phone not found

Expected behavior: ORGANIZATIONS, PERSONS, and PARTY_RELATIONSHIP type parties should be returned in search results when their email or phone matches search condition.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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