Absent Member.. kruegke Absent Member..
Absent Member..

Script to Automate Timesheet Delegate Assignment.

Our PPM Administrators have a need to search / view all timesheets, but are unable to do that for any that remain "Unsubmitted" after a Pay Period Close.  The solution to this is to have these Admininstrators named as timsheet "delegates" for all time reporters in the system. Our problem is that we periodically have Administrative turnover, and so are looking for some way to automate this timesheet "delegate" (re-)assignment.  It would also be beneficial to automate the removal of the former Admininstrator(s) as delegates.


When we initially converted to PPM, our HP Suppot Partners had provided a script for this purpose, but tis script was somehow not retained.


If anyone has such a script, or perhaps another solution to this requirement, it would be greatly appreciated if that could be shared.


Thank you.


1 Reply
Established Member.. Utkarsh_Mishra
Established Member..

Re: Script to Automate Timesheet Delegate Assignment.

You can use this statement to add delegate from backend, similarly use update to populate end date once you need to delete (or you can simplye use delete based on delegate user_id and resource_id)


Get delegate to user id in variable - p_user_id
and Resource Id in - p_assigned_to

insert into rsc_resource_delegations (resource_delegation_id, version, delegated_to_user_id,                                    start_date, end_date, created_by, creation_date, last_updated_by, last_update_date, resource_id)
(rsc_resource_delegations_s.nextval, 0, p_user_id, null, null, 1, sysdate, 1, sysdate, p_assigned_to) ;


Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
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.