In reviewing the timesheet process instance, it is stuck and not moving to the next step to completion. Canceling the process instance is not working. What can be done to unlock the timesheet?
You see one of the below error messages when your process gets stuck attempting to process timesheets.
TMA-0122: One or more timesheets' status could not be changed because it is locked by a process when trying to run a user-defined timesheet approval process.
TMA-0118: This timesheet has been locked by the process engine. One or more timesheets cannot be edited, submitted, approved, or posted.
You (or the time approver) may also not see the employee's (or contractor's) timesheet in your Action Items to approve.
It is by design that records are locked by the process. Typically the process completes as intended and the lock is released as expected. However, sometimes a lock gets placed but never releases due to a process stoppage. The process is not able to resume and there is no way to release or unlock the records through the application, therefore causing the timesheet to get stuck.
All Clarity versions
select odf_locked_attributes.id, first_name, last_name, prstart, prstatus,
odf_locked_attributes.odf_pk, prtimesheet.prid timesheet
from odf_locked_attributes, prtimesheet, prtimeperiod, srm_resources
where object_code = 'timesheet'
and attribute_code = 'prstatus'
and odf_locked_attributes.odf_pk = prtimesheet.prid
and prtimesheet.prtimeperiodid = prtimeperiod.prid
and srm_resources.id = prtimesheet.prresourceid
and odf_locked_attributes.odf_pk = <internal id of the timesheet>
Support can review and query timesheets locked by the process engine. It will involve deleting record(s) from the single table (odf_locked_attributes). Any removals will need approval from you.