Employee Number - Oracle Fusion HCM

Fusion Queries


Employee Number - Oracle Fusion HCM



hcm,oracle queries,oracle fusion, hcm queries, fusion queries, fusion hcm,employee number





SELECT 
person_number   

 FROM 
per_all_people_f  papf   

 WHERE 
TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date

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