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

The issue can be reproduced with the following steps:
1.Navigate to Payables Responsibility
2.Run Invoice Validation Concurrent Program
3.The Invoice Validation Concurrent Program is running for long time and this is causing performance issue.

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.