My Oracle Support Banner

E1: GRID: Web Client Exception in Advanced Query When Decimal Format for the User is Different Than the Creator of the Query (Doc ID 2564637.1)

Last updated on DECEMBER 25, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


When the decimal format for the Advanced Query (AQ) user is different than the one setup for the user who created AQ, web client exception occurs and the query does not work correctly. The difference in decimal format can also be triggered by the difference in the Language Preference under user profile, which in turn causes the same exception in AQ.

Below errors are observed in the e1root log:

Also query looks incomplete when reviewing the query under Query Manager after the exception

Good Query Definition

Same Query Definition after exception - No right operand




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.