Transaction Workbench Performance Issue: Poor Performance When Applying Credit Memo to Invoice (Doc ID 468857.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

 

When trying to apply a Credit Memo to an invoice, it will take a long time for the list of values to show the list of open invoices. Review of TKPROF shows the following is the most expensive SQL:

 


call    count     cpu     elapsed     disk     query      current     rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse        1     0.00       0.00          0          0          0          0
Execute      1     1.71       1.40          1         80          0          0
Fetch        1    19.61      50.21     109000     987015          0          2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total        3    21.33      51.62     109001     987095          0          2

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms