My Oracle Support Banner

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

Last updated on JUNE 30, 2021

Applies to:

Primavera Unifier Cloud Service - Version 19.12.1.0 to 19.12.3.0 [Release 19.12]
Primavera Unifier - Version 19.12.1.0 to 19.12.3.0 [Release 19.12]
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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