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.

Symptoms

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 ),
                               sum(amount_due_remaining),
                               sum(acctd_amount_due_remaining)
                      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

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