Poor Performance In Transactions and Receipts Workbench
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms