E1: 31: Extremely Slow Performance on P31226 (Doc ID 2056424.1)

Last updated on APRIL 07, 2017

Applies to:

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

Symptoms

E1 9.0 / P31226 Production Status

Tools Version 9.1

Performance issue with P31226 Production Status Inquiry

When searching on the Branch, Order Type, Date Range and Operation Status Range without item and or work center populated the system is extremely slow to respond and sometimes does not respond at all.
The F3112 has 2 million records so the system searches through all of them which maybe an index issue.

Expect to return data in a timely manor.

The issue can be reproduced at will with the following steps:
1. Selecting on Effective Date Range, Branch Plant, Operations Status Range and Work Order Type
2. No results after 2 million records are ran through

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