My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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***


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

Cuncurrent Program = Payment Process Request Program
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




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 
 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   
 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 


To view full details, 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 a vibrant support community of peers and Oracle experts.