My Oracle Support Banner

Viewing Purchase Order Details in iProcurement Causes Performance Issue (Doc ID 1605513.1)

Last updated on JULY 11, 2019

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to view PO details, the application takes two minutes to open.

EXPECTED BEHAVIOR
-----------------------
Expect to view PO details in less than two minutes to open.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into iProcurement
2. Click on Requisitions tab.
3. Query a requisition with a PO.
4. Click on the PO number hyperlink

SELECT NVL(SUM(AMOUNT), 0)
  FROM AP_INVOICE_LINES_ALL
WHERE (PO_HEADER_ID = :B2 AND PO_RELEASE_ID = :B1 AND :B1 IS NOT NULL)
  OR (PO_HEADER_ID = :B2 AND PO_RELEASE_ID IS NULL AND :B1 IS NULL)


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 9.43 100.15 128327 128327 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 9.43 100.16 128327 128327 0 1

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.