Posts

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
Post a Comment
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
Post a Comment
Read more

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

Image
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       SELECT  p apf.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_ty
Post a Comment
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
Post a Comment
Read more

Query to find TOWN_OF_BIRTH,REGION_OF_BIRTH,COUNTRY_OF_BIRTH,PERSON_NUMBER,DATE_OF_DEATH,BLOOD_TYPE,DATE_OF_BIRTH OF EMPLOYEE of Employee - Oracle Fusion HCM

Image
Fusion Queries Employee Details in Fusion HCM Oracle Fusion HCM :  TOWN_OF_BIRTH, REGION_OF_BIRTH, COUNTRY_OF_BIRTH, PERSON_NUMBER, DATE_OF_DEATH, BLOOD_TYPE, D ATE_OF_BIRTH   SELECT  papf.person_number,           pp.blood_type,           pp.date_of_birth dob,           pp.date_of_death,           pp.country_of_birth,           pp.region_of_birth,           pp.town_of_birth       FROM  per_all_people_f papf,  per_persons 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
Post a Comment
Read more

Employee Number - Oracle Fusion HCM

Image
Fusion Queries Employee Number - Oracle Fusion HCM 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
Post a Comment
Read more