My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2021

Applies to:

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


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.

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




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

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