DESCRIPTION: Unable to post Timesheet Batches getting the below Error Message:
CAUSES: The Batch Number had an apostrophe in it.
SOLUTIONS: Run the below script to change the Batch Number by removing the apostrophe.
select * from EC_TIMESHEET_BATCH_CTRL
where BATCH_NO = 'EA''s'
and PAY_NUMBER = '2022xx'
update EC_TIMESHEET_BATCH_CTRL
set BATCH_NO = 'EA'
where BATCH_NO = 'EA''s'
and PAY_NUMBER = '2022xx
select * from EC_EMPLOYEE_TIMESHEETS
where EMP_GROUP_CODE = 'xxxxxx'
and PAY_NUMBER = '202213'
and BATCH_NO = 'EA''s'
update EC_EMPLOYEE_TIMESHEETS
set BATCH_NO = 'EA'
where EMP_GROUP_CODE = 'xxxxxx'
and PAY_NUMBER = '2022xx'
and BATCH_NO = 'EA''s'