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.

Symptoms

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.

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.