EAP: Matching is looping at Step AP_MATCH.DelRec.Step01 causing performance issue
(Doc ID 2333819.1)
Last updated on FEBRUARY 01, 2019
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Having a performance issue with Matching. Matching is taking about 1 hour 50 minutes to process 630 Vouchers.
The Step that is taking the longest to run is Step AP_MATCH.DelRec.Step01, which keeps on looping for each Voucher. Even though the SQL's loop, the SQL's themselves don't take long to run. This SQL was called 354,526 times.
1. Create PO Vouchers
2. Run Matching
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