Highlighted
Absent Member.. Absent Member..
Absent Member..
741 views

Open a cancelled timesheet

Jump to solution

Hi,

 

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

Any help is appreciated.

 

Regards

T.M.

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

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.

 

View solution in original post

4 Replies
Highlighted
Absent Member.
Absent Member.
Hi TM,

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

Regards,
Diana Campos
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

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.

 

View solution in original post

Highlighted
Absent Member.
Absent Member.
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;
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

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...

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.