PO Approval process delays due to performance issue (Doc ID 1926590.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The Purchase Order (PO) Approval process is taking long time due to a performance issue that was shown in the database trace, like the following:

Expensive Query
---------------------------
DELETE FROM FND_DOCUMENTS_LONG_TEXT
WHERE
 MEDIA_ID IN (SELECT FD.MEDIA_ID FROM FND_DOCUMENTS_TL FDTL, FND_DOCUMENTS FD,
  FND_ATTACHED_DOCUMENTS FAD WHERE FDTL.DOCUMENT_ID = FD.DOCUMENT_ID AND
  FD.DOCUMENT_ID = FAD.DOCUMENT_ID AND FD.USAGE_TYPE = 'O' AND FD.DATATYPE_ID
  = 2 AND FAD.ENTITY_NAME = :B3 AND FAD.PK1_VALUE = :B2 AND FAD.PK2_VALUE =
  :B1 )


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 896.53 897.98 0 2088439 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 896.53 897.98 0 2088439 0 0

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