My Oracle Support Banner

E1: 31: "Error ID 0003 Blanks Invalid" in Work Center Field (MCU) is Encountered When Using Query Manager Selection in Dispatch List (P31220) (Doc ID 2604292.1)

Last updated on JULY 21, 2020

Applies to:

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


When user creates a display query with Query Manager, in Dispatch List Inquiry (P31220), and this query includes the Work Center field (MCU), system throws a hard error 003-Blanks Invalid in form W31220B and highlights the field. No records are retrieved based on the specified filter.

The issue can be reproduced with the following steps:

1. Access application Dispatch List (P31220) and search for records by selecting WC = 200-201 and Requested Date from 9/24/2019 through 4/21/2020 for display sequence. All records meeting this criteria are retrieved and displayed in the form. In this way it is confirmed that there are records matching these parameters. Exit P31220.

2. To create a query, access Dispatch List (P31220) and via Query Manager sets it up to be used when selected, then adds the Work Center field (MCU) indicating a value equal to 200-201.   

3. Save the query, name it WORKC and exit the application.

4. Access Dispatch List Inquiry again and select the new query WORKC. Observe that as soon as WORKC is selected, the system gives hard error ID 0003-Blanks Invalid and highlights the Work Center Field (MCU) in the form header, causing that no records are retrieved and user cannot continue and is forced to exit the application.





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.