top of page

Role Delegation feature in HCM Cloud

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.

1 comment

1 Yorum


Raghavendra M
Raghavendra M
19 Eyl 2021

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

Beğen
bottom of page