Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Introduction

Role delegation is the assignment of a role from one user, known as the delegator, to another user, known as the proxy. The delegation can be either for a specified period, such as a planned absence, or indefinite. You can delegate roles in the Roles and Approvals Delegated to Others section on the Manage User Account page. Select Navigator - About Me - My Account.

The proxy user can perform the tasks of the delegated role on the relevant data. For example, a line manager can manage absence records for his or her reports. If that manager delegates the line manager role, then the proxy can also manage the absence records of the delegator's reports. The delegator doesn't lose the role while it's delegated. The proxy user signs in using his or her own user name, but has additional function and data privileges from the delegated role.

Multiple users can delegate the same role to the same proxy for overlapping periods. If the proxy user already has the role, then it isn't provisioned again but the proxy can access the data associated with the delegated roles.

If the proxy is a line manager, then the proxy can access his or her own manager hierarchy in addition to those from other managers.

A single delegator can't delegate the same role to the same proxy more than once for overlapping periods.

Role Delegation ends automatically if the proxy user’s assignment is terminated.

Custom Report to find Delegated Roles along with Delegator and Proxy Details

Until now, we have tried to understand what is meant by Role Delegation and other specific details about the same. While delegation of roles is a very nice feature which might come handy for senior executives and other individuals holding important strategic positions where they need some one to assist them with the work overload when they go for a vacation or take personal time-off there does comes some added responsibility for the proxy users and so there at times is a need to have complete details around the same. Each time a feature such as Role Delegation is discussed we have some obvious questions which pops up in our mind like:

  1. Which Role was Delegated?

  2. Who was the Delegator?

  3. Who was the proxy?

  4. What is the Role Delegation Start Date?

  5. What is the Role Delegation End Date?

All such questions can be answered by developing a custom BIP Report. In this example, we would try to develop the same.

SQL Used

SELECT NAMED.DISPLAY_NAME DelegDisplayName

, NAMED.FULL_NAME DelegFullName

, APPLD.PERSON_NUMBER DelegPersonNumb

, NAME.DISPLAY_NAME ProxyDisplayName

, NAME.FULL_NAME ProxyFullName

, APPL.PERSON_NUMBER PersNumb

, USR.USERNAME UsrName

, ROLE.ROLE_COMMON_NAME RoleName

, DELG.START_DATE Delegate_Begin

, DELG.END_DATE Delegate_End

, DELG.CREATED_BY Delegate_CreatedBy

, DELG.CREATION_DATE Delegate_CreateDate

, DELG.LAST_UPDATED_BY Delegate_UpdtBy

, DELG.LAST_UPDATE_DATE Delegate_UpdtDate

, USR.HR_TERMINATED Proxy_HRTerm

, USR.SUSPENDED Proxy_Suspended

FROM PER_DELEGATED_ROLES DELG

, PER_USERS USR

, PER_ROLES_DN ROLE

, PER_ALL_PEOPLE_F APPL

, PER_PERSON_NAMES_F NAME

, PER_ALL_PEOPLE_F APPLD

, PER_PERSON_NAMES_F NAMED

WHERE DELG.PROXY_PERSON_ID = USR.PERSON_ID

AND DELG.ROLE_ID = ROLE.ROLE_ID

AND APPL.PERSON_ID = DELG.PROXY_PERSON_ID

AND TRUNC(SYSDATE) BETWEEN APPL.EFFECTIVE_START_DATE AND APPL.EFFECTIVE_END_DATE

AND NAME.PERSON_ID = DELG.PROXY_PERSON_ID

AND TRUNC(SYSDATE) BETWEEN NAME.EFFECTIVE_START_DATE AND NAME.EFFECTIVE_END_DATE

AND NAME.NAME_TYPE = 'GLOBAL'

AND APPLD.PERSON_ID = DELG.DELEGATOR_PERSON_ID

AND TRUNC(SYSDATE) BETWEEN APPLD.EFFECTIVE_START_DATE AND APPLD.EFFECTIVE_END_DATE

AND NAMED.PERSON_ID = DELG.DELEGATOR_PERSON_ID

AND TRUNC(SYSDATE) BETWEEN NAMED.EFFECTIVE_START_DATE AND NAMED.EFFECTIVE_END_DATE

AND NAMED.NAME_TYPE = 'GLOBAL'

ORDER BY NAMED.FULL_NAME, NAME.FULL_NAME

Once we map this SQL into a data model and prepare a report ( we would only selected specific data columns and not all columns from the SQL ) we get a report which appears as below:

 

From the above report we can conclude that a role named “25th_JULY_DATA” was delegated by Curtis Feitty(Person# 101) to Jessica Mullen(Person# 543) for the period of 26th July 2017 to 30th July 2017.

Similarly, one may run the same SQL query and get the complete list of all the roles which were delegated in a specific environment along with details like delegator, proxy, delegation start date, delegation end date.. etc.


Ashish Harbhajanka

Comments   

0 #1 hydroxy cloroquine 2021-08-08 11:17
chloraquine https://chloroquineorigin.com/# hydroxychloroqu ine sulfate 200 mg
Quote
0 #2 belsao 2022-05-06 21:13
who produces hydroxychloroqu ine win hydroxychloroqu ine clinical trial
Quote
0 #3 zpgljy 2022-05-07 20:15
hydroxy clore quinn chloroquine phosphate online
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner