RACUST - Customer Interface Performance Issue Fetching Millions of Rows (Doc ID 1130873.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:RACUST - Customer Interface


Symptoms

RACUST - Customer interface is having performance issues

Sorted tkprof shows the following as the top query:

select decode(rsu.location,i.location,'w1,','') ,i.rowid
from
hz_cust_site_uses rsu ,hz_cust_accounts rca ,hz_cust_acct_sites rad ,
ra_customers_interface i ,ar_system_parameters syspa where
(((((((i.orig_system_address_ref is not null and i.insert_update_flag='I')
and i.orig_system_customer_ref=rca.orig_system_reference) and
rad.cust_acct_site_id=rsu.cust_acct_site_id) and rsu.site_use_code=
i.site_use_code) and rca.cust_account_id=rad.cust_account_id) and
i.request_id=:b0) and syspa.auto_site_numbering='N') group by rsu.location,
i.location,i.rowid


call    count   cpu      elapsed    disk       query      current    rows
------- ------  -------- ---------- ---------- ---------- ---------- ---------
Parse   1       0.00     0.00       0          8          0          0
Execute 1       0.01     0.01       0          15         0          0
Fetch   6792882 213.95   337.89     2396523    16438224   5803       6792881
------- ------  -------- ---------- ---------- ---------- ---------- ---------
total   6792884 213.97   337.91     2396523    16438247   5803       6792881

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