R12.2: AP/IBY: Performance Issue with Scheduled Payment Selection Report (APINVSEL) (Doc ID 2009443.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Payments - Version 12.2.2 to 12.2.5 [Release 12.2]
Oracle Payables - Version 12.2.2 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
Scheduled Payment Selection Report (APINVSEL) Running Longer

Symptoms

When a user submits Scheduled Payment Selection Report it takes long time to complete.

  

select  /*+ LEADING(asi) use_NL(asi, ai2, ai) index(ai AP_INVOICES_N2) */ distinct
      ai.payment_currency_code unused_credits_pmt_cur ,
      hr.name unused_credits_org_name,
      decode(sign(ps.amount_remaining),-1,
                            ps.amount_remaining,
                            0) amount_remaining,
      /* hz.party_name, Commented for bug#10382651  

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