Oracle Communities

Oracle Analytics and AI

Child Item

Need Employee Human resources Representative and HR Business Partner

Dear Expert,

Can someone help me to get the query or subject area where i can get employee Human resources Representative and HR Business Partner.

Example-

Employee is John and i wanted to know who is Human resources Representative and HR Business Partner for john.

Thank you!

Find more posts tagged with

OTBI

Fusion HCM Analytics

BIP Reports

OTBI (Oracle Transactional Business Intelligence)

Accepted answers

All comments

RVohra

Hi @jsmithA ,

Here are the few key tables that can help you to get the HR Rep and HR BP

per_all_people_f

per_person_names_f

per_asg_responsibilities

Hope it helps!

RVohra

It could be something like below …

SELECT

papf.person_number AS "EmpNumber",

ppnf.display_name AS "EmpName",

par.responsibility_name AS "RespName",

flv.meaning AS "RepRole",

prep_names.display_name AS "RepName"

FROM per_all_people_f papf JOIN per_person_names_f ppnf ON papf.person_id = ppnf.person_id

AND ppnf.name_type = 'GLOBAL' JOIN per_asg_responsibilities par ON papf.person_id = par.person_id LEFT JOIN fnd_lookup_values flv ON par.responsibility_type = flv.lookup_code AND flv.lookup_type = 'PER_RESPONSIBILITY_TYPES' AND flv.language = USERENV('LANG') JOIN per_person_names_f prep_names ON par.person_id = prep_names.person_id AND prep_names.name_type = 'GLOBAL' WHERE TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date AND TRUNC(SYSDATE) BETWEEN prep_names.effective_start_date AND prep_names.effective_end_date AND papf.person_number = '12345' — Change as per your requirement

jsmithA

Hi Rvohra,

Good Day!

We need who is employee hrbp and hr rep.

Please check my above request.

In person management when we search any person and click on Head phone icon we can see the all representative from where we need employee hrbp and hr rep .