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: 

Open a cancelled timesheet

SOLVED
Go to solution
Highlighted
TurboMan
Member

Open a cancelled timesheet

Hi,

 

I wonder if there is any way of re-opening a cancelled timesheet?

Any help is appreciated.

 

Regards

T.M.

4 REPLIES
d4y4n4
Frequent Visitor

Re: Open a cancelled timesheet

Hi TM,

As far I know there is no way to reopen a cancelled timesheet.

Regards,
Diana Campos
TurboMan
Member
Solution

Re: Open a cancelled timesheet

I think I've found a solution.

 

I get the TIME_SHEET_ID with the following query.

1- select * from tm_time_sheets where description like '%time_sheet_description%';

;

2- select * from tm_time_sheet_lines where time_sheet_id=:TIME_SHEET_ID;

 

In the first query if you update the STATUS_CODE=1 (in my case it is 1)

and

In the second query if you update the STATE=1

 

The timesheet status gets changed from Canceled to Unsubmited.

 

d4y4n4
Frequent Visitor

Re: Open a cancelled timesheet

Hi TM,

Good job!

Also check the status of the time sheet lines (if any) and update the status of the lines

Example

update tm_time_sheets t set t.status_code = 1 where t.time_sheet_id in ();
update tm_time_sheet_lines l set l.state = 1 where l.time_sheet_id in ();
commit;
TurboMan
Member

Re: Open a cancelled timesheet

Thanks d4y4n4,

 

But I already done that. 

It works perfectly.

I wish there were a legitimate ORACLE package which does this kind of things.

Anyway...

 

//Add this to "OnDomLoad" event