Search Functionality Not Working Properly in DEFQ Forms -> Exact Case should be Provided

(Doc ID 2320863.1)

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

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

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