My Oracle Support Banner

E1: 41: Unable to Use Query Manager to Select Location field in Item Ledger Inquiry (P4111) to Retrieve All Records with a Specific Location (Doc ID 3007492.1)

Last updated on MARCH 04, 2024

Applies to:

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


It is not possible Using Query Manager to select the Location field in Item Ledger Inquiry (P4111) to retrieve all records with a specific predefined Location.

The issue was reproduced with the following steps:

  1. Start Item Ledger (P4111) Inquiry.
    1. Enter Item 230 and Branch 30 and click Find.
    2. Scroll to the Location field in the grid.
    3. There is no QBE field for querying the location in the grid.
  2. Click on the Manage Queries Button.
  3. In Query Manager, click on Additional Fields selection
    1. There is no Plus (+) sign on Location field in header. It is not available for selection.
    2. The Location field in Grid is not in the list of Additional fields selection. It is not available for selection.
    3. The Location field in the Item Ledger Inquiry (P4111) cannot be selected for a Custom Query that always displays a particular Location.




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.