Approved timesheets not posting - master KB of known issues

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After running the post timesheet job, you expect that any timesheet on an approved status gets posted.

However, there is a specific timesheet that is not being posted. Why?

Cause

Look at the bg-ca.log file to understand what the cause is as those can vary. 

Resolution

Table of Contents

• Known Issues
  • Errors
  • Locks
  • Settings
  • Other
• Additional troubleshooting steps

Known Issues

See the below list of known KB articles. If a solution is not found here, it's recommended to check further using self-service as this may not be an all-inclusive list. 

Errors

• Post timesheet error: "ORA-01400 ("CLARITY"."PPA_MATRIXCHECKOUT"."MATRIXKEY") "
• Post Timesheet error "ORA-01400 ("CLARITY"."NBI_PROJ_RES_RATES_AND_COSTSCP"."TEAM_ID")"
• Approved timesheet not posting: Error: "****POSTTIMESHEET: Couldn't post time entry..."
• Post Timesheet job is not posting approved timesheets - errors ORA-01483 / ORA-03106
• Approved timesheet not posting - Error: "Couldn't post adjustmented timesheet..."
• Timesheet stuck in 'Approved' status with error "ORA-01722: invalid number"

Locks

• Timesheet not posting: remains Approved with error "Lock ~prTimeEntry held by user..."
• Timesheet locked by a process - error TMA-0118 or TMA-0122

Settings

• Timesheets not posting when resource time settings are incorrect
• Timesheets not posting when settings are incorrect

Other

• Approved timesheets are not posting if they are future timesheets
• Approved timesheets are not posted / post timesheets job not completing

Additional troubleshooting steps

1. Check if the Post Timesheets job has completed. 
   
   Use the following query before, during, and after the Post Timesheets job run to check how many timesheets remain to be posted:
   select count(1)
from PRTIMESHEET
where prstatus = 3 --approved
2. Allow at least 5 minutes after the timesheet has been approved prior to running the job
3. Review the bg-ca.logs for any errors related to timesheets or the post timesheets job
4. If there is a custom timesheet process, make sure the conditions are met.

Additional Information

See also: Clarity frequently reported issues