RAXAPR.rdf - Performance Issue For Autoinvoice In 11.5.10 (Doc ID 367549.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version to [Release 11.5.10]
Information in this document applies to any platform.


Autoinvoice report is experiencing a performance issue.

The problem SQL is listed below.


,curr.name currency_name
from ar_batches ab,
ar_cash_receipts cr,
ar_cash_receipt_history crh,
ar_receivable_applications ra,
hz_cust_accounts cus,
hz_parties party,
ra_batch_sources bs,
ar_payment_schedules ps,
fnd_currencies_vl curr,
fnd_concurrent_requests fcr
where cr.cash_receipt_id = ra.cash_receipt_id
and ra.applied_payment_schedule_id in (-1, -6)
and ra.display = 'Y'
and ra.request_id = :p_ai_request_id
and ab.BATCH_ID (+) = crh.BATCH_ID
and bs.batch_source_id = fcr.argument3
and fcr.request_id = ra.request_id
and cr.pay_from_customer = cus.cust_account_id
and cr.currency_code = curr.currency_code
and cus.party_id = party.party_id
and ps.payment_schedule_id = ra.applied_payment_schedule_id


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