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  

        

"Function not available to this responsibi​lity" Error While Clicking On Forms Personalis​ation

To resolve the issue:
1. Log in as the System Administrator
2. Navigate -> Profile -> System -> User
3. Select an appropriate level (i.e. Site, Application, Responsibility, User)
4. Query the following profile: Utilities: Diagnostics
5. Set option to Yes and commit
6. You must log off and log on again for the settings to take effect.
Then retest for your issue.

Ref - Metalink Note - 1263970.1

FNDLOAD Form Persanalizations and Menu in Oracle Applications

Create the director like xx_ldts under $FND_TOP/patch/115/import/
Menu
Download
[appldemo@demo XX_LDTS]$ FNDLOAD apps/xxx@xxx 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXX_COLL_SELF_SERV.ldt MENU  MENU_NAME="XXX_COLLEAGUE_DIRECT_ACCESS"

UPLOAD
[appltest@testappn1 XX_LDTS]$ FNDLOAD apps/xxxxx@test 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXX_COLL_SELF_SERV.ldt

Form Persanalization:
Download
FNDLOAD apps/xxxx@dev 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct PERWSDPO_07.ldt FND_FORM_CUSTOM_RULES function_name="PERWSDPO_07"

Upload:
FNDLOAD apps/xxxxx@test 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct xxxx.ldt

Delete Organization Information in Oracle HRMS

DECLARE
   ln_ovn   NUMBER := 1;
   CURSOR c
   IS
      SELECT org_information_id, object_version_number
        FROM hr_organization_information
       WHERE TRUNC (creation_date) = TRUNC (SYSDATE)
         AND org_information_context = 'XX_ORG_ROLES'
      UNION
      SELECT org_information_id, object_version_number
        FROM hr_organization_information
       WHERE org_information_context = 'XX_ORG_ROLES'
         AND TRUNC (creation_date) = '01-May-2012';
BEGIN
   FOR i IN c
   LOOP
      ln_ovn := i.object_version_number;
      hr_organization_api.delete_org_manager
                               (p_validate                   => FALSE,
                                p_org_information_id         => i.org_information_id,
                                p_object_version_number      => ln_ovn
                               );
   END LOOP;
END;