E1:31: Production History Inquiry P31227 Searches Through All Records Even If Filter Is Added (Doc ID 1911282.1)

Last updated on DECEMBER 24, 2015

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

E1 9.1 / P31227 Production History Inquiry

ACTUAL BEHAVIOR  
---------------
P31227 appears to search through all records (F31122?) even if a filter (i.e. branch plant, item number and From/Thru Date) is used.
The Fetching Data Rows message appears and then after several minutes, the data is displayed.  If the filter is only branch plant and work order number, the grid load is very quick.

EXPECTED BEHAVIOR
-----------------------
Expect the program to search based on filters (not entire data base table).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Access P31227 (fast path or menu).
2. Enter a branch plant, item number and From/Thru Dates.
3. Click Find.  Application begins processing and eventually returns the Fetching Data Rows message.  After several minutes, the grid is loaded with 23 rows (the data returned is correct).
4. Remove the Item Number filter and enter a work order number.  The grid is loaded immediately.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms