Search Functionality Not Working Properly in DEFQ Forms -> Exact Case should be Provided
(Doc ID 2320863.1)
Last updated on DECEMBER 13, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.
OFSAAI - Oracle Financial Services Analytical Applications Infrastructure
OFSAAI Forms Data Entry not filtering properly
Customs forms created with OFSAAI Forms designer, but in some case the search function is not working properly.
In case of varchar fields with lower case characters, the rows are not selected.
 No match found for the current search
Upper and lower case search should work properly and list all results.
Steps to Replicate:
1. Create a DEFQ form with column having list from secondary table.
2. Insert secondary table with lower case letters(ex: xyz)
3. Search the form with string like 'xyz'. It will not return the result as it searches with upper case XYZ.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document