My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.