Performance Issues: Customer Account Details For Billing (Doc ID 1455388.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Customer account details screen is having performance issues when querying customers

Top query in tkprof:

  select count( distinct invoice_currency_code ),
                         sum(amount_due_remaining),
                           sum(acctd_amount_due_remaining)
                     from AR_PAYMENT_SCHEDULES_PMT_V  WHERE
  (BS_BATCH_SOURCE_NAME= :l_var1 ) and (CUSTOMER_ID=TO_NUMBER( :l_var2 ))

  call     count       cpu    elapsed       disk      query    current         rows
  ------- ------  -------- ---------- ---------- ---------- ----------   ----------
  Parse        1      0.02       0.01          0          0          0          0
  Execute      1      0.46       0.46          0          0          0         0
  Fetch        1    316.77    1933.11    1288898   19284839          0            1
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  total        3    317.25    1933.59    1288898   19284839          0