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;

Check Cycle in Position Hierarchy

SQL> select empno     , mgr    , connect_by_iscycle  
          from scott.emp 
          connect by nocycle mgr  = prior empno  
          start with empno  = 7321