My Oracle Support Banner

E1: 30: Wild Card ( * ) Value Set for Consuming Location Field (Alias: TLOC) in Kanban Master Revisions (P3016) Triggers Error ID 3138 - 'Invalid Location' (Doc ID 2858844.1)

Last updated on JUNE 16, 2022

Applies to:

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

Symptoms

When doing an open search in Kanban Master Revisions (P3016), the system displays all records for all existing Kanban IDs created for all items, all Consuming and / or Supplying Branch plants and all Consuming and / or Supplying Locations.
If searching for a specific Item and Consuming Branch Plant and the field Consuming Location is defined as " * - generic value", the system returns the correct records.
If searching for a specific Item (Alias: UITM), Consuming Branch Plant (MMCU) and Consuming Location (Alias: TLOC), P3016 displays correct Kanban IDs defined for this unique combination of search criteria.
However, if deleting the value defined in the Consuming Location and change it to " * - generic value" and then doing another find in P3016 with a specific Item Number and specific Consuming Branch Plant, the system triggers error ID 3138 - 'Invalid Location'.
This error occurs after a Tools Release upgrade (to 9.2.5.4.) and only if having the flags 'Location Control' and 'Warehouse Control' activated in Branch/Plant Constants - P41001.

The issue can be reproduced at will with the following steps:

  1. P41001 - Set the flags 'Location Control' and 'Warehouse Control' to ON
  2. Log out from JDE and log back into JDE
  3. P4100 - Define 2 different locations: e.g. CONSUME and SUPPLY
  4. P4101 / P41026 - Find a purchase component (Stk Ty = P, Ln Ty = S) that has Kanban IDs created
  5. P410124 - Make sure the component has the above secondary locations defined
  6. P3016 - Do a Find without entering any search criteria. The system displays the records for all Kanban IDs created for various items, (Consuming and Supplying) B/Ps and (Consuming and Supplying) Locations
  7. P3016 - In Kanban Master screen, do a search for a specific item (e.g. above purchased item that has the locations CONSUME and SUPPLY defined correctly)
  8. P3016 - Search for the above specific Item Number and Consuming B/P; note that Consuming Location field is set to * = generic value (all values)
  9. P3016 - Search for the above specific Item Number, Consuming B/P and a specific Consuming Location (e.g. CONSUME). All Kanban IDs that meet the search criteria are displayed correctly.
  10. P3016 - Remove the previous value from the Consuming Location and add a the generic value - * - all values. Error ID 3138 - 'Invalid Location' is triggered, although the specific Item Number and Consuming B/P values are not changed. The same search has been performed at step 8 and the system did not trigger any error.

Changes

Upgrade to Tools Release 9.2.5.4.

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.