Can any one suggest how reduce the timing for invoice validation in payables ?
Hi ,
Online invoice validation in oracle payables is taking around 20 seconds where as it should take around 5 seconds . Can any one suggest from the below log file
what can be done to reduce the timing .
Highest time consuming queries ..
SELECT APPLICATION_ID , LEDGER_ID
FROM
XLA_BAL_CONCURRENCY_CONTROL WHERE APPLICATION_ID = :B1 FOR UPDATE NOWAIT
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 1.61 1.61 5 216 25192 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 1.61 1.61 5 216 25192 0
BEGIN :1 := XLA_00200_AAD_S_000005_BC_PKG.CreateJournalEntries(:2,:3,:4,:5,:6
); END;
call count cpu elapsed disk query current rows