Performance Issue with Automatic Remittances Creation Program (API) (Doc ID 2270031.1)

Last updated on JUNE 04, 2017

Applies to:

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

Symptoms

Performance Issue with AUTOREMAPI: Automatic Remittances Creation Program (API)


Poor Performing SQL:
UPDATE /*+ index(R) */ ar_cash_receipts R SET selected_remittance_batch_id =
:u_batch_id,REMIT_BANK_ACCT_USE_ID =
:u_remit_bank_account_id, last_update_date = sysdate, .........
WHERE selected_remittance_batch_id is null AND cash_receipt_id IN ( SELECT
/*+ LEADING(rma2, rma1,cr,crh1) */ cr.cash_receipt_id FROM
ar_cash_receipt_history crh1,
  ar_cash_receipts cr,
  ar_payment_schedules ps,
  ar_receipt_classes rclass,
  ar_receipt_methods rm,
  ar_receipt_method_accounts rma1,
  ar_receipt_method_accounts rma2
.........


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