My Oracle Support Banner

E1: GRID: Query based on Personal Grid Format Displaying incorrect Description for Selected Columns in Tools Release 9.2.6.1 (Doc ID 2832415.1)

Last updated on MARCH 17, 2022

Applies to:

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

Symptoms

When creating a new query in Tools Release 9.2.6.1 using a personal grid format regardless of the order of the columns on the personal grid format the name of the columns selected on the query display the original order of the grid.

STEPS to duplicate.

  1. Sign on to E1 9.2.6.1 and fast path to P01012
  2. Select a personal format (in this case "cnc2" is the name of the personal format and has Search Type as the first column)
  3. Click on the Query Manager Icon to create a new query
  4. Select the first three columns from the grid (Sch Typ, Address Number, Alpha Name)
  5. Under the query manager the column added reads Address Number, Alpha Name and Long Address which are the original first three columns on the grid.

Below you can see how the new query is selecting the first three columns on the grid but the names of the columns on Query Manager do not match.

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
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.