ORA-01403 FRM-40502 In Organization Field When Narrowing Search (Doc ID 2062536.1)

Last updated on OCTOBER 06, 2015

Applies to:

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

Symptoms

When searching in the Organization field in Advanced Collections, the following error occurs when adding additional characters and trying to narrow the search:

ORA-1403 no data found
FRM-40502 ORACLE error: unable to read list of values


Steps to Reproduce:

Responsibility: Collections Agent
Navigation
: Collections

  1. Enter 'Comp%' in the Organization field, and click on the LOV '...'
  2. The list is returned, now add more characters to reduce the LOV further, like 'Computer%', and click find.

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