Absent Member.. shijub Absent Member..
Absent Member..
305 views

Cancel Unsubmitted and Pending Approval timesheet

Hi ,

 

How can we cancel the timesheet for the past period which are in Unsubmmited and Pending approval status, since we are in process to have these cleared and have them in Cancelled status.

 

Is there any ways we can have this cancelled.

 

Thanks in Advance.

 

0 Likes
2 Replies
Absent Member.. PPrasoon Absent Member..
Absent Member..

Re: Cancel Unsubmitted and Pending Approval timesheet

Yes, you can update the selected time sheets and lines in tm_time_sheets and tm_time_sheet_lines, columns  status_code and state in rwespective tables to 5. It would do.

 

-Parijat

0 Likes
Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..

Re: Cancel Unsubmitted and Pending Approval timesheet

I think below query should doi.

 

UPDATE tm_time_sheets
SET status_code      = 5
WHERE time_sheet_id IN
  (SELECT time_sheet_id
  FROM KTMG_TIME_SHEETS
  WHERE status_code IN ('ACTIVE','RELEASED')
  );

 

 

Please try this on DEV/QA first. It would cancel all lines which are unsubmitted or pending approval.

 

Thanks

Mohit

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.