R12 AP: Payment Process Request Program Is Taking A Long Time To Run.
(Doc ID 1533188.1)
Last updated on JUNE 03, 2024
Applies to:
Oracle Payables - Version 12.0.6 and laterInformation in this document applies to any platform.
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
Expectation is around 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
........
.......
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |