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 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Autoinvoice report is experiencing a performance issue.

The problem SQL is listed below.

ARPT_SQL_FUNC_UTIL.get_lookup_meaning('AR_RECEIPT_HANDLING_OPTIONS','REFUND')

RECEIPT_HANDLING_OPTION
,receipt_number
,ab.NAME
,party.party_name
,cus.account_number
,cr.CURRENCY_CODE
,curr.name currency_name
,ra.amount_applied
,ra.comments
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 crh.CASH_RECEIPT_HISTORY_ID = ra.CASH_RECEIPT_HISTORY_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

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