Timesheets on a Returned status. Why?

Products

• Clarity PPM On Premise

Issue/Introduction

The business administrator inquired why there are timesheets in the 'Returned' status in Clarity PPM.

How can we know what happened?

 

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Resolution

1. Check if there are any processes on the 'timesheet' object that is active. If so, check the conditions of when a timesheet is returned.

2. Use the following queries to inquire with the users directly:

Go to the timesheet URL and obtain the (timesheet id, resource id, time period id)

--a
select * from prtimesheet
where prstatus = 2
and prresourceid = xxxx
and prtimeperiodid = yyyy

--b
select * from srm_resources where user_id in
(select prmodby from  prtimesheet where prstatus = 2
and prresourceid = xxxx
and prtimeperiodid = yyyy)