ORA-01403 FRM-40502 In Organization Field When Narrowing Search
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
- Enter 'Comp%' in the Organization field, and click on the LOV '...'
- The list is returned, now add more characters to reduce the LOV further, like 'Computer%', and click find.
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