Unable to post Timesheet Batches in K212 HRP Application.

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'