EAP: Matching is looping at Step AP_MATCH.DelRec.Step01 causing performance issue

(Doc ID 2333819.1)

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.

Symptoms

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.

STEPS
1. Create PO Vouchers
2. Run Matching

Changes

 

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