E1: 31: Extremely Slow Performance on P31226
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.
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
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