When attempting to post transactions into WIP, an error message is generated.
Steps to Reproduce:
- Login to the application as a Financial user
- Home, Post to WIP
- Click 'Apply' button
Expected Result: The transactions should be posted without this error message.
Actual Result: Post To WIP fails with Error 'REVMGR-20669:Error inserting matching records'.
We queried the PPA_WIP table and found 2 records for the same transaction ; only difference is in the 'batch' number. Then we queried the PPA_WIP_VALUES table to see if both transactions have the matching 5 records. Only one of the PPA_WIP records had matching 5 records. We removed the orphaned PPA_WIP record and the posting action was successful for the valid record.
This issue can be caused in a Microsoft SQL Server environment if the 'Post Transactions to Financials' job is interrupted due to Database problems such as out of space, transaction logs filling up or the job itself is interrupted. The job creates the header record and may be interrupted during the time that it needs to create the 5 matching records.
Orphan PPA_WIP record: The following query will show any record that is in PPA_WIP table, but no matching records in the PPA_WIP_VALUES table. No results indicate no problem.
from ppa_wip wip
where wip.transno not in (select transno from ppa_wip_values)
Incorrect Ratio of Records: Here is a query that shows there might be records in the PPA_WIP_VALUES table, but not all 5 records in the table.
For the application to function properly, there must be a 1:5 ratio between PPA_WIP and PPA_WIP_VALUES tables. No results indicate no problem.
select w.transno, count(*)
from ppa_wip w, ppa_wip_values v
where w.transno = v.transno
group by w.transno
having count(*) <> 5
Orphan PPA_WIP_VALUES records: The following query will show any records that are in the PPA_WIP_VALUES table, but no matching header record in the PPA_WIP_VALUES table. No results indicate no problem.
from ppa_wip_values wipval
where wipval.transno not in (select transno from ppa_wip)
If the issue arises again, review the data and check for the 1:5 record ratio to determine if there is a data corruption issue.
Contact CA Technical Support for assistance in resolving the data corruption issue.
In v14.3+, a new job 'Post to WIP' is now available and can be used to schedule financial transaction posting during non-peak hours.
Reference v14.3 Product Documentation for more details.