Account Search - Unable to Search on Accounts

(Doc ID 1421219.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.
Form:IEXRCALL.FMB - IEX Startup Form

Symptoms

User is unable to search by account in the IEX search window.  The following errors appear.

FRM-41830 List of Values contains no entries
APP-IEX-240445 Query caused no records to be retrieved.

Even when putting a '%' in the window, and clicking on the '...', it brings up a full list of values, but when selecting a value, it doesn't return the record.

User can find the same account number in the IEXRCALL form without any issues.

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