API to Delete EIT Structure

--select * from fnd_descr_flex_contexts  where descriptive_flex_context_code = 'XXHR_XXX_EDUCATION'-- EIT Details

--select *   from fnd_descr_flex_col_usage_vl where descriptive_flex_context_code = 'XXHR_XXX_EDUCATION' - EIT Column Details

DECLARE

   CURSOR c1

   IS

      SELECT *

        FROM fnd_descr_flex_contexts

       WHERE descriptive_flex_context_code = 'XXHR_XXX_EDUCATION';

BEGIN

   FOR i IN c1

   LOOP

      BEGIN

         fnd_flex_dsc_api.delete_context (

            appl_short_name   => 'PER',                                  -- HR

            flexfield_name    => i.descriptive_flexfield_name,

            context           => i.descriptive_flex_context_code);

         DBMS_OUTPUT.put_line (

               i.descriptive_flex_context_code

            || ' has been deleted Successfully!');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.put_line (

                  ' Inner Exception: '

               || i.descriptive_flex_context_code

               || ' - '

               || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line (' Main Exception: ' || SQLERRM);

END;

Workflow Process to Disable Multiple EIT/Self Service Transaction at one Go

Purpose: Restrict Employee to raise Multiple EIT Transaction at one go

 Probable Solution as said below

Step 1: Copy Seeded Workflow “Change Extra Information” and define yours

Step 2: Create Database Function 

CREATE OR REPLACE PROCEDURE xxhr_check_trans_raised (

   itemtype   IN            VARCHAR2,

   itemkey    IN            VARCHAR2,

   actid      IN            NUMBER,

   funmode    IN            VARCHAR2,

   result        OUT NOCOPY VARCHAR2)

IS

   l_cnt   NUMBER := 0;

BEGIN

   IF (funmode = 'RUN')

   THEN

      SELECT COUNT (*)

        INTO l_cnt

        FROM hr_api_transactions hat

       WHERE hat.item_key = itemkey;

     

      IF l_cnt = 1

      THEN

         result := 'COMPLETE:' || 'FAILURE';

      ELSE

         result := 'COMPLETE:' || 'SUCCESS';

      END IF;

   ELSIF (funmode = 'CANCEL')

   THEN

      NULL;

   END IF;

END xxhr_check_trans_raised;

Step 3: Alter the Workflow as show in the below screens

Step 3.1:  Create New Function in Workflow as shown in the below screen 

Step 3.2

Step 3.3: Alter the above-created workflow as shown below

How to Enable Search for Ex-Employees in Manager Self Service

The following setup can be configured in order to Enable Ex-Employee Search in Manager Self Service

Enable the below highlighted parameter for Manager SSHR Function

Function	HR_EIT_MGR_SS
User Function Name	Extra Information Types Mgr
Type	SSWA jsp function
Parameters	pCalledFrom=HR_EIT_SS&addBreadCrumb=Y&pEnableTerms=Y
OA HTML	OA.jsp?akRegionCode=HR_PERSON_TREE_TOP_SS&akRegionApplicationId=800

Reference Note ID: Terminated Employees are not Visible In Manager Self Service (Doc ID 1327613.1)

The Following points needs to be taken care off once the configuration has been completed (Oracle Bugs)

1            1)      Before Searching “Show table data when any condition is met.” Radio button needs to be              enabled

2           2)      Oracle does not allow Ex-Employee Search using Assignment Number, Either one needs to search via Last Name or Combination of First and Last Name

Query to Get Self Approved Leave Transaction from History

SELECT per.employee_number,

       per.full_name,

       paaf.supervisor_id,

       TO_CHAR (TO_DATE (pssh.information1, 'YYYY-MM-DD'), 'DD-MON-YYYY')

          date_start,

       TO_CHAR (TO_DATE (pssh.information2, 'YYYY-MM-DD'), 'DD-MON-YYYY')

          date_end,

       paat.name absence_type

  FROM pqh_ss_transaction_history psth,

       pqh_ss_step_history pssh,

       per_people_x per,

       per_assignments_x paaf,

       per_absence_attendance_types paat

 WHERE     process_name = 'HR_GENERIC_APPROVAL_PRC'

       AND psth.selected_person_id = per.person_id

       AND per.business_group_id = :l_business_group_id

       AND per.person_id = paaf.person_id

       AND paaf.assignment_type = 'E'

       AND paaf.assignment_status_type_id IN (1, 2)

       AND pssh.transaction_history_id = psth.transaction_history_id

       AND paat.absence_attendance_type_id = pssh.information5

       AND EXISTS

              (SELECT 'X'

                 FROM pqh_ss_approval_history psah, fnd_user fu

                WHERE     action = 'APPROVED'

                      AND fu.user_name = psah.user_name

                      AND fu.employee_id = psth.selected_person_id

                      AND psah.transaction_item_key = psth.item_key

                      AND TRUNC (psah.creation_date) = TRUNC (SYSDATE))