Applicant to Employee Query in Oracle HRMS

Query to find Applicant who are hired amd made employees.

SELECT DISTINCT papf.person_id, papf.full_name, pla.location_id,
                         pla.location_code, ppos.date_start doj,
                         xxpa.ROWID row_id
                   FROM per_all_people_f papf,
                         per_person_type_usages_f pptu_emp,
                        per_person_type_usages_f pptu_ex_apl,
                         per_person_types ppt_emp,
                         per_person_types ppt_ex_apl,
                         per_periods_of_service ppos
                   WHERE papf.person_id = pptu_emp.person_id
                     AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                                             AND papf.effective_end_date
                     AND TRUNC (SYSDATE) BETWEEN pptu_emp.effective_start_date
                                             AND pptu_emp.effective_end_date
                     AND TRUNC (SYSDATE)
                            BETWEEN pptu_ex_apl.effective_start_date
                                AND pptu_ex_apl.effective_end_date
                     AND ppt_emp.person_type_id = pptu_emp.person_type_id
                     AND papf.person_id = pptu_ex_apl.person_id
                     AND ppt_ex_apl.person_type_id =
                                                    pptu_ex_apl.person_type_id
                     AND ppt_emp.system_person_type = 'EMP'
                     AND ppt_ex_apl.system_person_type = 'EX_APL'
                     AND papf.person_id = ppos.person_id;

Query_Find Form in Oracle Apps

Link - http://erpschools.com/articles/query_find-form-in-oracle-apps

This is neatly explained steps.

Cheersss...
Sandip

Need steps to setup payslip in SSHR (UAE)

You need to run the following programs after prepayments to generate the payslip:

UAE Payment Output File

after that

UAE Payroll Archiver

Fields and Instructions in OAF Page Persanolization

Steps:
1. Go to Personalisation
2. Select the field.
3. Add CSS Class as OraDataText for flexfields and OraInstructionText for instructions.
4. Apply
5. Return to Application

Fields Readonly in OAF Page personalisation

Steps:
1. Go to Persanalization
2. Filter for Flex
3. Select the correct field
4. In the Segments, Add the Flexfield Segments like

LICENSE_REQUEST|Grade($RO$)|Job Title($RO$)|Department($RO$)|SBU($RO$)|Contact Number|Type of License

Cheersss...

Delete Position Hierarchy in Oracle HRMS

The Lowermost position should be deleted first

DECLARE
   ln_ovn   NUMBER := 1;
   CURSOR c
   IS
      SELECT     LPAD (' ', 5 * LEVEL) || has.NAME HIERARCHY, LEVEL,
                 hap.NAME parent_name, pse.parent_position_id,
                 has.NAME child_name, pse.subordinate_position_id,
                 pse.pos_structure_element_id, pse.object_version_number
            FROM (SELECT NAME, position_id
                    FROM hr_all_positions_f_tl
                   WHERE LANGUAGE = USERENV ('LANG')) hap,
                 (SELECT NAME, position_id
                    FROM hr_all_positions_f_tl
                   WHERE LANGUAGE = USERENV ('LANG')) has,
                 per_pos_structure_elements pse
           WHERE pse.business_group_id = 141
             AND hap.position_id = pse.parent_position_id
             AND has.position_id = pse.subordinate_position_id
      --start with pse.parent_position_id =
      CONNECT BY PRIOR pse.subordinate_position_id = pse.parent_position_id
             AND PRIOR pse.pos_structure_version_id =
                                                  pse.pos_structure_version_id
             AND PRIOR pse.business_group_id = pse.business_group_id
        ORDER BY 2 DESC, 4;
BEGIN
   FOR i IN c
   LOOP
      BEGIN
         ln_ovn := i.object_version_number;
         hr_pos_hierarchy_ele_api.delete_pos_hierarchy_ele
                   (p_validate                      => FALSE,
                    p_pos_structure_element_id      => i.pos_structure_element_id,
                    p_object_version_number         => ln_ovn,
                    p_hr_installed                  => 'I'
                   );
      EXCEPTION
         WHEN OTHERS
         THEN
            NULL;
      END;
   END LOOP;
END;

Create Position Hierarchy in Oracle HRMS

First Create the Hierarchy from Front End

DECLARE
   lo_pos_structure_element_id   NUMBER;
   lo_object_version_number      NUMBER;
BEGIN
   hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele
                  (p_validate                      => FALSE,
                   p_parent_position_id            => 16544,
                   p_pos_structure_version_id      => 62,
                   p_subordinate_position_id       => 16951,
                   p_business_group_id             => 141,
                   p_hr_installed                  => 'I',
                   p_effective_date                => '01-Jan-2000',
                   p_pos_structure_element_id      => lo_pos_structure_element_id,
                   p_object_version_number         => lo_object_version_number
                  );
END;