Poor Performance on Po Forms (Doc ID 2064403.1)

Last updated on OCTOBER 12, 2015

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.4 version, Purchase Order (PO)

Poor performance in the PO Inquiry Form when trying to select the Operating Unit and also opening the PO Summary Form.  Forms did not open after waiting 5+ minutes.

This issue was recently discovered during  upgrade from R12.1.3 to R12.2.4.
 
It takes several minutes to open Purchase Order form.
Plus, in the Find PO Form, when selecting an Operating Unit, it takes up to 5 minutes for the OU to return.
 
No workaround.
 

---- additional information  ---

several forms have this performance issue:
 -- to open:   PO form, PO Summary form, AutoCreate form, Requisition Summary form.
 -- to select OU:   PO form, PO Sumamry form

Purchasing > Purchase orders > Took 4.15 minutes for the form to open
Purchasing > Purchase Order Summary > Find PO Form > OU LOV > Took 4.46 minutes to select the OU
Purchasing > Auto Create Form > Took 4.16 minutes for the form to open
Purchasing  Requisitions > Requisition Summary > Took 4.25 minutes for the form to open
Payables > PO Inquiry > View Purchase Orders > Took 4.09 minutes to select the OU
Payables > Entry > Invoices > Invoice Batches > Took 2 seconds to open the form and 4 seconds to query a record
Payables Entry > Invoices > Invoices > Took 2 seconds to open the form and 6 seconds to query a record
 
 

STEPS TO REPRODUCE
---------------------------
The issue can be reproduced at will with the following steps:
Purchasing > Purchase Order Summary > Find PO Form > OU LOV > Took 4.46 minutes to select the OU

 

Changes

 Upgrade from R12.1.3 to R12.2.4

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