In reviewing the timesheet process instance, it is stuck and not moving to the next step to completion.
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.
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
3. To find if there are any locked attributes for a specific timesheet, add the following to the end of the above query:
and odf_locked_attributes.odf_pk = <internal id of the timesheet>
4. The Support group can review and query timesheet locked by the process engine.
5. Any removals will need approval from the customer.
6. On Premise Customers: Provide a copy of the full bg-ca.log file