We deal with this all the time.  It's a duplicate record in your ESS Requests for Time Off for employee 3080 that was submitted more than once and all submitted transactions have been approved.... I have written a SQL Script to delete the duplicate transactions using SQL Management Studio... there is no other way to remove the duplicated transactions once they have become a past dated transaction.  We spent many countless hours working with Sage and our own troubleshooting in order to rectify this issue. When we sent our data to Sage, they could not duplicate the problem, however, it is still an issue in HRMS/ESS 2017 system and we manage it through manual deletions.

The duplicated transaction is not in the hattran table, hence why you can't find duplicates.   When ESS is processing time off and trying to commit the time taken from ESS to hattran is when the error occurs.  It encounters the duplicate transaction in the tTIME_OFF_REQUESTS table in ESS.

Hi Terry,

Would you be willing to share the SQL script?

Thanks

do you have an email address Howard?  I can send you my SQL

Thank you!  [email protected]  

Hi Terry,

I am experiencing the same issue.  Would it be possible to send me the information on how you fixed it?  My email address is [email protected].  I appreciate any help you can give me. :-)

Thanks,
Arlena

Hi Terry,

I am experiencing the same issue.  Would it be possible to send me the information on how you fixed it?  My email address is [email protected].  I appreciate any help you can give me. :-)

Thanks,
Arlena