My Oracle Support Banner

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

Last updated on JULY 23, 2020

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.
R12 Invoice Validation performance issue
***Checked for relevance on 19-Dec-2015***

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

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.