My Oracle Support Banner

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.

[6997] No match found for the current search

Expected Behavior:
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.