Search Functionality Not Working Properly in DEFQ Forms -> Exact Case should be Provided
Last updated on NOVEMBER 03, 2017
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.
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