Project and Portfolio Management Practitioners Forum
cancel

Approve/Freeze Time Sheets without Time License

Highlighted
ArunKr
Respected Contributor.

Approve/Freeze Time Sheets without Time License

Is it possible to approve/freeze time sheets even without having Time License but having only the required access grants?

2 REPLIES
burakkaya28
Respected Contributor.

Re: Approve/Freeze Time Sheets without Time License

Hi,

The only way that I can give you is Updating timesheet status via Oracle DB. To update specific or group of timesheet, check the sql query below.

update tm_time_sheets 
set status_code = 6  -- {4: Approve, 6: Freeze}
where 1=1
and resource_id = '(select user_id from knta_users where username='[USERNAME_OF_USER]')' --You can use this filter to perform for a specific user
and description = 'Burak Kaya - 19.09.2016 - 25.09.2016' --Or you can use this filter to perform for a specific time sheet


Hope it would be helpful for you.

Best Regards,
Burak Kaya

CyCLoPs
Super Contributor.

Re: Approve/Freeze Time Sheets without Time License

That should not be possible without Time Management license.