Very Slow Cash Requirements Payment Selection Run Times

Does anyone else seem to have an issue with Cash Requirements Payment Selection taking an unusually long time to complete? It might be partly due to volume but some of our check runs can take close to two hours to complete with the majority of that processing time due to Payment Selection.
Though volume could be a contributing factor I think it also is due to the initial set selection defined in the source LPL which uses only the fields below:
Vendor Group
Pay Group
Process Group
Company
Process Level
Payment Code
Every instance returned by that set is evaluated by multiple large rule blocks. For example that initial set selection could select a bucket of 30K open payments but the final selected payments when the job completes is 6k payments. It's possible there is some superfluous processing there that is slowing the process down.
The slow processing time might also be due to the manner in which the legacy Cobol was ported over to Java in the the Infor v11 code uplift; certain processes in Cobol are probably faster than Java and vice versa.
I'm considering putting in an enhancement request to have payment selection optimized, but am curious if other customers are experiencing similar issues.
Thanks!
Andy
Answers
-
Hey Andy, have you reached out to support? Has anyone captured the DBSessionDebug?
0 -
We are currently experiencing the same thing. We reset our personalization's and readded fields that do not show up on the personalization form. It looked like Infor has updated some of the business classes that are defaulted on this form.
I am still waiting to hear from users if this helped with the slow processing time.
0 -
Yes and yes. We actually had a call with support, including dev, to review latency issues and this area was discussed. It sounded as though there was a future dev roadmap item to optimize payment selection but with no specific timeline.
I'm thinking if more clients are experiencing the same issue an enhancement request can help increase the priority of any potential existing initiatives.0 -
We've experienced the same and would be excited to see an improvement in this area. Please let me know if you submit an enhancement request.
0 -
Likewise!
0 -
JR-3408947 has been reported for slow performance of Cash Requirements (don't know if it is for the exact scenario described above). Trying to find out when it will be fixed.
0 -
Were you able to find a status for JR-3408947 ?
0 -
Tentatively targeted for 2023.05 (with the standard disclaimer
)
0 -
Thanks Sandeep! Does the JR have any additional details?
0 -
Andy, not a whole lot of details. Identified some changes based on the session debug captured.
0
Categories
- All Categories
- 3 General Posts
- 6 Public Sector
- 5.8K Developer Community
- Migrated Forums
- Cloud Migration
- 5 Community News
- 2 User Groups
- 4 Featured Content
- Featured Developer
- Featured Public Sector
- 4 Featured Forums
- Featured Healthcare
- 2 Announcements
- Customer Bulletins
- In the Birst Space
- Legacy Blog Posts
- 132 RMS News
- Site News