Poor Performance In Transactions and Receipts Workbench
(Doc ID 1455582.1)
Last updated on JULY 10, 2020
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!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.