Highlighted
Frequent Contributor.
Frequent Contributor.
61 views

Time Sheet Line Approver Update Issue

Hello Experts,

Good Day..

To Control Time Approers for a project, we have Checked the Project Setting as 'Time logged against this project must be approved by a project representative from the following group (Stakeholder)'.

In such case, When Stakeholder submits the timesheet for the project where he/she as the stakeholder, timesheet goes for self-approval, But ideally it should go to their manager.

To handle this, we have tried to update the resource approver details through back-end using below DML query.

UPDATE tm_users_time_approvers
SET TIME_APPROVER_USER_ID = (select TM_APPROVER_ID from rsc_resources
                                                                where resource_id = <<Stakeholder ID>>),
         TYPE = 'RSC_A',
        SOURCE = 'null'
WHERE APPROVER_TIME_SHEET_LINE_ID = <<Line ID>>
AND TYPE = 'TRUSTEE_A';

Even after updating from back-end and clearing cache, time sheet line doesn't reflects with the updated approver details. 

Kindly advise.

 

Thanks,

Suresh

0 Likes
3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Time Sheet Line Approver Update Issue

This approach won't work. Any manual changes in this table will be discarded when the timesheet line is saved or when the "Evaluate TM Approvers Service" runs.
You'd better submit an idea on PPM Idea Exchange: https://community.microfocus.com/t5/PPM-Idea-Exchange/idb-p/PPM_Ideas
0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Re: Time Sheet Line Approver Update Issue

Thanks for your reply Canaud.

Could you please advise, is there any alternate way to handle this scenario?

 

Thanks,

Suresh

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Time Sheet Line Approver Update Issue

I don't think so, that's an ER.
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.