Query to find PERSON_NUMBER, TITLE, FIRST_NAME, MIDDLE_NAMES, LAST_NAME, DISPLAY_NAME,FULL_NAME, LIST_NAME, ORDER_NAME OF EMPLOYEE of Employee - Oracle Fusion HCM

Fusion Queries

Employee Details in Fusion HCM

Query to find Name details of an Employee

Oracle Fusion HCM : 

PERSON_NUMBER,          
TITLE,              
FIRST_NAME,         
MIDDLE_NAMES,          
LAST_NAME,          
DISPLAY_NAME,         
FULL_NAME,         
LIST_NAME,          
ORDER_NAME      


per_person_names_f,town_of_birth,region_of_birth,country_of_birth,person_number,date_of_death,blood_type,date_of_birth ,





SELECT 
papf.person_number,          
ppnf.title,                  -- Its code. Use hcm_lookups for meaning          
ppnf.first_name,         
ppnf.middle_names,          
ppnf.last_name,          
ppnf.display_name,         
ppnf.full_name,         
 ppnf.list_name,          
ppnf.order_name     

FROM 
per_all_people_f papf, 
per_person_names_f ppnf    

WHERE 
papf.person_id = ppnf.person_id(+) -- (+)to fetch if some data is not present in system          
AND 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 -- To get latest updated data          
AND ppnf.name_type = 'GLOBAL'          -- Depending uppon requirement 

ORDER BY person_number

Comments

Post a Comment

Popular posts from this blog

Query to find Address Details of Employee - Oracle Fusion HCM

Image
Fusion Queries Employee Details in Fusion HCM Query to find Address Details of Employee - Oracle Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER,           ADDRESS_TYPE,           ADDRESS_LINE_1,           ADDRESS_LINE_2,           ADDRESS_LINE_3,           ADDRESS_LINE_4,           BUILDING,           FLOOR_NUMBER,           TOWN_OR_CITY,           REGION_1,           REGION_2,           REGION_3,   COUNTRY,           POSTAL_CODE    SELECT  person_number,           ppauf.address_type,           paf.address_line_1,           paf.address_line_2,           paf.address_line_3,           paf.address_line_4,           paf.building,           paf.floor_number,           paf.town_or_city,           paf.region_1,           paf.region_2,           paf.region_3,   per_extract_utility.get_territory_name(paf.country)COUNTRY,           paf.postal_code      FROM  per_all_people_f papf,           per_person_addr_usages_f ppauf,           per_addresses_f paf     WHERE  papf.person_id = ppauf.perso
Read more

Query to find Email details of an Employee

Image
Fusion Queries Employee Details in Fusion HCM Query to find Email details of an Employee Oracle Fusion HCM :  PERSON_NUMBER,  EMAIL_TYPE,  EMAIL_ADDRESS    SELECT     papf.person_number,   pea.email_type,   pea.email_address         FROM per_all_people_f papf,   per_email_addresses pea        WHERE     papf.person_id = pea.person_id(+) -- (+)to fetch if some data is not present in system        AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                                    AND papf.effective_end_date   ORDER BY person_number
Read more

Query to find PERSON_NUMBER, PHONE_TYPE, PHONE_NUMBER, AREA_CODE, SEARCH_PHONE_NUMBER, COUNTRY_CODE_NUMBER OF EMPLOYEE of Employee - Oracle Fusion HCM

Image
Fusion Queries Employee Details in Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER , PHONE_TYPE,           PHONE_NUMBER,           AREA_CODE,           SEARCH_PHONE_NUMBER,           COUNTRY_CODE_NUMBER    SELECT  papf.person_number,          pp.PHONE_TYPE,           pp.PHONE_NUMBER,           pp.AREA_CODE,           pp.SEARCH_PHONE_NUMBER,           pp.COUNTRY_CODE_NUMBER      FROM  per_all_people_f papf,  per_phones pp     WHERE  papf.person_id = pp.person_id(+) --  to fetch if some data is not present in system           AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date   AND papf.effective_end_date  ORDER BY person_number
Read more