You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Do you know how can I get the email of Reporting Manager from the Resource User Information section?

Accepted answer
45
Views
3
Comments
in Sales 3 comments

Summary:

Do you have an idea on how can I get the email of reporting manager in the resource user information section under Manage Users?

I am using the table jtf_rs_rep_managers_v in my Data Model however I am not getting the correct result.

Content (required):

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT

HzParties.PARTY_NUMBER,

HzParties.PARTY_NAME PERSON_NAME,

ResProfiles.EMAIL_ADDRESS,

HcmUsers.USERNAME,

rsrep.parent_org_name RESOURCE_ORGANIZATION,

rsrep.PARENT_RESOURCE_ID,

rsrep.manager_email_address,

pea.email_address hr_manager_email

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!