Role Delegation feature in HCM Cloud
- Jun 7, 2020
- 1 min read
Role Delegation functionality helps deputing responsibilities to some one else ('Proxy') for certain duration based on different business situations. Some of the know scenarios could be -
Delegator is going on leave for certain duration.
Delegator is on business travel for certain duration.
Delegator needs to following navigation - Navigator > Me > Roles and Delegations to perform delegation activity, below working screen -

HR can also delegate roles on behalf of Delegator to Proxy.
'Proxy' will receive extra function and data privileges from delegator, thus can perform all actions on those set of population delegator was having authority to do.
'Delegation Allowed' checkbox should be enabled while creating Data role and mapping security profiles to it, we can enable this check box later too.
This SQL query will pull up details of those roles which are delegated and other details related to it.
SELECT
B.role_name,
C.full_name as delegated_by,
D.full_name as delegated_to,
to_char(A.start_date,'DD-MM-YYYY') delg_start_date,
to_char(A.end_date,'DD-MM-YYYY') delg_end_date
FROM
per_delegated_roles A,
per_roles_dn_vl B,
per_person_names_f_v C,
per_person_names_f_v D
WHERE
A.role_id = B.role_id
and C.person_id = A.delegator_person_id
and D.person_id = A.proxy_person_id Additional details -
PER_USER_DELEGATION_MAX_DAYS, profile option to keep cap on maximum number of days delegation can be allowed.
PER_USER_DELEGATION_SEND_NOTIFICATIONS, profile option to send notification while creating, deleting delegation entries.


Role Delegation in HCM Cloud feels especially useful for real-world HR scenarios like leave or business travel, where temporary coverage is essential. The explanation that a Proxy receives both function and data privileges, scoped to the delegator’s authority, makes the security model clearer. I also liked the mention of enabling “Delegation Allowed” for the relevant data role and mapping security profiles. As a separate thought, I’ve relied on a web proxy like ProxyOrb to keep access stable when testing modern SPAs.
Hi , this is helpful, I have a requirement to pull Role and Approval Delegations in OTBI. Can you please let me know the Subject Area to pull these information in OTBI