R12: AP: Performance Issue with 1099 Invoice Exceptions Report (APXT7INE) (Doc ID 1503177.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Performance Issue With 1099 Invoice Exceptions Report (APXT7INE)

Symptoms

Users are experiencing performance issues when running 1099 Invoice Exceptions Report after upgrading to R12.1.3.

Steps to reproduce this issue:

1. Navigate to Payables Manager Responsibility

2. Submit concurrent request 1099 Invoice Exceptions Report

3. The request takes more than an hour to complete.

select AI.vendor_id, AID.type_1099
from   ap_invoices_all AI,
         ap_invoice_distributions_all AID
where AI.invoice_id = AID.invoice_id
and ai.invoice_id in ( select aip.invoice_id
                               from ap_invoice_payments aip,
                                       ap_checks ac
                               where ac.check_id = aip.check_id
                               and     AIP.accounting_date between (:p_start_date) and (:p_end_date)
                               and     nvl(ac.void_date,:p_end_date+1) not between (:p_start_date) and (:p_end_date))
and  TYPE_1099 is not null
and  TYPE_1099  =  'MISC4'  
and   AID.line_type_lookup_code  =  'AWT'
group by AI.vendor_id, AID.TYPE_1099
having sum(AID.amount)> 0

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1    218.03    8648.71    1222805    7556920          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3    218.03    8648.71    1222805    7556920          0           0

 

/*this query was added for bug 3361690  

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