Time Sheet Line Approver Update Issue

[Suresh Reddy]

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

[Etienne_Canaud]

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

[Suresh Reddy]

Thanks for your reply Canaud.

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

Thanks,

Suresh

[Etienne_Canaud]

I don't think so, that's an ER.