EAR9.2: Payment Worksheet Performance When Building a Worksheet With Ref Qual = ST, Customer ONLY (Doc ID 2079445.1)

Last updated on NOVEMBER 25, 2015

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-------------------
User is having Payment worksheet performance when building a worksheet with reference qual = ST, Customer ONLY and customer items are over 60

This happens when customers have large amounts of items on the specific statement 60 or more items.  The SQL that is created when selecting build runs for over 5 min and processing stops.


REPLICATION STEPS
---------------------
The issue can be reproduced at will with the following steps:
Accounts Receivable > Payments > Apply Payments > Create Worksheet

  1. Open a payment (select any payment)
  2. Click Clear button at bottom
  3. Enter customer 
  4. In Reference Criteria enter Customer Only for Restrict to drop down
  5. Enter ST for Qual Code
  6. Click on the Build button

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