Slow Performance While Query Release Shipments By Specific Item and Date Range in Purchase Order Summary Form

(Doc ID 1499912.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Purchasing - Version 11.5.10.2 and later
Information in this document applies to any platform.
FORM:POXPOVPO.FMB - Purchase Order Summary GUI

Symptoms

When searching for Release shipments in the Purchase Order Summary form it often takes over 8 minutes for the form to return data after entering Item number and Order date range.
  
Steps to reproduce:

1. Login to Purchasing responsibility
2. Navigate to Purchase Order  - Purchase Order Summary
3. Populate Item field
    Populate Date Ranges - Order Date start date
    Choose Shipments radio button
    Check 'View Releases' check box
    Hit Find
4. The result is retrieved after 8+ minutes

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