My Oracle Support Banner

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.


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
: 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.


To view full details, 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 a vibrant support community of peers and Oracle experts.