Performance - EBS (MOSC)

MOSC Banner

Can any one suggest how reduce the timing for invoice validation in payables ?

edited Nov 13, 2015 9:35AM in Performance - EBS (MOSC) 7 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center