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
- 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!