The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Approve/Freeze Time Sheets without Time License

Highlighted
ArunKr
Super Collector

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
Occasional 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
HPE Expert

Re: Approve/Freeze Time Sheets without Time License

That should not be possible without Time Management license.

//Add this to "OnDomLoad" event