My Oracle Support Banner

E1: DB: QBE (Query By Example) Filtering on User ID Field Does not Return Any Records in Databrowser (Doc ID 2857822.1)

Last updated on MARCH 28, 2022

Applies to:

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

Symptoms

When trying to filter the records using the QBE for User ID column in some tables opened in databrowser, no records are returned even though the user can see records with those user IDs when reviewing the records without any filter criteria.

For example, when performing a find operation on F00165 opened in databrowser without any filters, user can see records for the specific User ID. When the user copy and paste the same User ID from the records into the QBE for the User ID column, no records are returned upon clicking Find  button. As per the corresponding jas debug log, database does not return any rows for the specific Select query.

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


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