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.
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
- Open a payment (select any payment)
- Click Clear button at bottom
- Enter customer
- In Reference Criteria enter Customer Only for Restrict to drop down
- Enter ST for Qual Code
- Click on the Build button
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