My Oracle Support Banner

E1: GRID: Wildcard Search with QBE Does Not Return All Records When Unicode Set to N (Doc ID 2505671.1)

Last updated on NOVEMBER 22, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.


When on Microsoft SQl Server Database, QBE search for Grid Columns will not functioning correctly for (*) wildcard, if Unicode is set to N for the Datasource.
Some but not all available results will be returned.

Replication Steps
1. FastPath to a Search Browse Applicaiton Form (e.g. P41280)
2. Enter the following:
    a. Item Number = <09999
    b. Description = *AF
    c. Branch/Plant = * (all)
3. Click Find and observe not all expected records are returned.




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.