My Oracle Support Banner

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.

Symptoms

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:

  1. Start PO Receipts Inquiry (P43214) Version.
  2. Order Type OP and G/L Date of today’s date is defaulted.
  3. Click Find.
  4. The program searches through thousands of records and times out before any records are returned to the grid.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.