My Oracle Support Banner

EAP: Matching is looping at Step AP_MATCH.DelRec.Step01 causing performance issue (Doc ID 2333819.1)

Last updated on OCTOBER 01, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.