REL12 AP: Payment Process Request Program Is Taking A Long Time To Run. (Doc ID 1533188.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Dec-2015***

Symptoms

Performance problem:
The Payment Process Request Program is taking longer than usual to run.

Cuncurrent Program = Payment Process Request Program
Concurrent Program Exe = AP_AUTOSELECT_PKG.SELECT_INVOICES
Conc Program Name = APXPBASL

This program used to complete in a few minutes, now it regularly takes over 25 mins.

Time process is running 18 to 55 minutes
 Customer expectation 2 to 4 minutes.

 

Due to the following costly SQLs

BEGIN

   AP_AUTOSELECT_PKG.SELECT_INVOICES(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4); 
 END;


And

SELECT   /*+ index(inv AP_INVOICES_N3) */          :p_checkrun_name           
                                   checkrun_name         ,:p_checkrun_id     
                                           checkrun_id         ,
 ps.invoice_id                                               invoice_id      
    ,payment_num                                                 payment_num 
         ,SYSDATE                                                     
 last_update_date         ,FND_GLOBAL.USER_ID                                
           last_updated_by             ,SYSDATE                              
                        creation_date         ,FND_GLOBAL.USER_ID            
                               created_by         ,NULL                      
                                   last_update_login         ,ai.vendor_id   
                                             vendor_id         ,
 ai.vendor_site_id                                          vendor_site_id   
       ,suppliers.segment1                                          
 vendor_num         ,decode(ai.invoice_type_lookup_code, 'PAYMENT REQUEST',  
                hzp.party_name, suppliers.vendor_name)               
 vendor_name         ,sites.vendor_site_code                                 
      vendor_site_code         ,decode(ai.invoice_type_lookup_code, 'PAYMENT 
........
.......


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