E1: 43: PO Receipts Inquiry (P43214) Performance Slow, Query Inefficient
(Doc ID 2446413.1)
Last updated on MAY 15, 2019
Applies to:JD Edwards EnterpriseOne Procurement and Subcontract Management - Version XE and later
Information in this document applies to any platform.
PO Receipts Inquiry (P43214)
PO Receipts Inquiry (P43214) searches through thousands of records never coming to an end before it times out.
Client’s PO Receipts (F43121) table contains > 1/2 million records at the time of the inquiry.
The issue can be reproduced at will with the following steps:
- Start PO Receipts Inquiry (P43214) Version.
- Order Type OP and G/L Date of today’s date is defaulted.
- Click Find.
- The program searches through thousands of records and times out before any records are returned to the grid.
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