My Oracle Support Banner

WS: 31/41/42/43/46: Data Selection Will Not Accept Right Justified Location Field (LOCN) with Blank 1st Character (Doc ID 2580809.1)

Last updated on DECEMBER 24, 2020

Applies to:

JD Edwards World Procurement - Version A9.4 and later
JD Edwards World Shop Floor Management - Version A9.4 and later
JD Edwards World Sales Order Management - Version A9.4 and later
JD Edwards World Warehouse Management - Version A9.4 and later
JD Edwards World Inventory Management - Version A9.4 and later
Information in this document applies to any platform.

Symptoms

On: A9.4 and above

For a branch where the locations are formatted with the first location segment defined as 'Right Justified' and where the location values begin with a blank space, Dream Writer Data Selections within Manufacturing and Distribution that include the 'Location' field, left justifies the location fields LOCN - Location, TLOC - To Location and FLOC - From Location when data selecting on specific locations.

Location settings reside in Branch/Plant Constants (2/G4141) on page 2 (P410012) as follows:

For example, if you have a location '_A001' (first character is blank), when first entered into the data selection of Create Tasks (P46471), the location is displayed with the first character being a blank space as expected.  However, upon pressing enter or F5 to update, the value in the location field is left justified which removes the blank space. Instead of having location '_A001', you now see 'A001' (no leading blank space) resulting in this being an invalid location.  Because of this, the fields R2FLOC - From Location and R2TLOC - To Location, cannot be used as data selection criteria in a branch with locations defined where the first location segment is Right Justified and the locations have a blank space as the first character.


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.