Poor Performance In Transactions and Receipts Workbench
(Doc ID 1455582.1)
Last updated on JULY 31, 2017
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Poor performance in Transactions and Receipts workbench. Attempting to switch between screens and experiencing an extended wait time for routine queries.
Tkprof shows the following query causing the problem:
select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N6) */
count( distinct invoice_currency_code ),
from AR_PAYMENT_SCHEDULES_TRX2_V WHERE
(CUSTOMER_ID=TO_NUMBER( :l_var1 )) and (CUSTOMER_TRX_ID= :l_var2 )
Responsibility: Receivables Manager
Navigation: Receipts > Receipts
Exit form and query Customers > Account Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!