POST TO WIP: A query in the Stored Procedure PAC_PRC_POSTTOWIPS_SP performs full table scan so take a long to execute when there are many transactions. The query that takes most of the time is in 'PAC_PRC_POSTTOWIPS_SP' stored procedure. For about 1,870 records it take about 11 minutes to post.
Steps to Reproduce:
Expected Result: Expect transactions to get posted under 4 minutes.
Actual Result: It takes about 11 minutes for the Post To WIP procedure to complete.
Contact CA Technical Support for review and possible workaround in v13 or upgrade to v14.1.
When you open a case please provide the following for analysis so that we can confirm if you are running into this issue:
Release: ESPCLA99000-13.2-Clarity-Extended Support Plus