Performance Issue with Automatic Remittances Creation Program (API)
Last updated on JUNE 04, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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_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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms