Automatic Remittances Performance Issue: Poor Performance of Automatic Remittance Process, Using Range Scan on AR_CASH_RECEIPTS_N1 (Doc ID 973993.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

Performance of Automatic Remittances master program is poor.

Review of TKPROF shows:


select cash_receipt_id,pay_from_customer,customer_site_use_id into l_cr_id,l_paying_customer_id,l_cust_site_id from ar_cash_receipts where selected_remittance_batch_id = p_batch_id and payment_trxn_extension_id = ls_response_rec_tab(i).Trxn_Extension_Id;

call    count  cpu      elapsed    disk       query      current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse        1     0.01       0.00          0          0          0          0
Execute  11166     2.91       2.75          0          2          0          0
Fetch    11166   898.22     892.39          0   91293216          0      11166
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total    22333   901.14     895.15          0   91293218          0      11166

Rows    Execution Plan
------- ---------------------------------------------------
0       SELECT STATEMENT MODE:
        ALL_ROWS 0 FILTER 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AR_CASH_RECEIPTS_ALL' (TABLE)
0       INDEX MODE: ANALYZED (RANGE SCAN) OF 'AR_CASH_RECEIPTS_N1' (INDEX)


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