EAP: Matching is looping at Step AP_MATCH.DelRec.Step01 causing performance issue
Last updated on NOVEMBER 29, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms