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:

Symptoms

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.

Error:
[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.

Changes

Cause

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