UDR with Query Filters Return No Results If Search Criteria Does Not Match Exact Case (Doc ID 2677283.1)

Last updated on DECEMBER 21, 2022

Applies to:

Symptoms

On : Unifier 19.12.1.2

ACTUAL BEHAVIOR
---------------


When users create a User Defined  Report (UDR)  using a data view and add query filters, when users run the report, unless users search for the exact data including the case, the report will return 0 rows. For example, if filtering on company name 'ABC' and the company name is 'Abc', the filter will return no results.

EXPECTED BEHAVIOR
-----------------------

The search should not be case sensitive.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to the Company Workspace tab then to User defined reports
2. Open problem report
3. Add in search criteria.  Using the example above, enter company name 'ABC'
4. Run report an no results are returned
5. Go back to search criteria and put in a criteria that matches the case exactly.  As explained in the example above, enter 'Abc'
6. Run the report again and receive results.

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.