R12 AP: Invoice Validation Performance Issue (Doc ID 1276539.1)

Symptoms

Invoice validation is taking more than an hour to complete in R12 upgrade instance.

The following SQL statement is taking most of the time:

SELECT E.*
FROM
XLA_EVENTS E, XLA_TRANSACTION_ENTITIES T WHERE E.ENTITY_ID = T.ENTITY_ID AND
T.APPLICATION_ID = 200 AND T.ENTITY_CODE = :B2 AND T.SOURCE_ID_INT_1 = :B1
AND E.BUDGETARY_CONTROL_FLAG = 'Y' AND NOT EXISTS (SELECT 1 FROM
AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID = :B1 AND BC_EVENT_ID =
E.EVENT_ID)


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 348 0.18 0.10 0 0 0 0
Execute 4451 0.34 0.31 0 0 0 0
Fetch 4451 5076.14 5852.38 103361882 200219333 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9250 5076.66 5852.80 103361882 200219333 0 0

Changes

Cause

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