4 Replies Latest reply: Mar 14, 2011 2:41 AM by Gaurav Bhardwaj RSS

    Advanced Benefits : How to use Person Selection Rule?

    791471
      Hi,

      For processing Open Enrollment we need to run"Participation Process:Scheduled" Concurrent Program for a set of 300 employees.How to create a person Selection Rule for this?

      thanks.
        • 1. Re: Advanced Benefits : How to use Person Selection Rule?
          Gaurav Bhardwaj
          Hi Sririam

          You need to create the PER_SELECTION_FUN (u can use any name) function which will take the context parameter 'Assignment ID' as input and will return N or Y. So you need to return Y for only those 300 employee and for rest you can return N.


          FORMULA TEXT:
          **********************************************************************/
          /*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
          /*=========== DATABASE ITEM DEFAULTS ENDS======================*/
          /*============ INPUT VALUES DEFAULT BEGIN ======================*/
          /*============== INPUT VALUES DEFAUT ENDS ======================*/
          /*================= INPUTS SECTION BEGIN ========================*/
          /*================== INPUTS SECTION ENDS ========================*/
          /*================ FORMULA SECTION BEGIN =======================*/
          l_ret = PER_SELECTION_FUN ( )
          return l_ret

          HTH
          Gaurav
          • 2. Re: Advanced Benefits : How to use Person Selection Rule?
            791471
            Hi,

            I created the Function with 'Assignment Id' as context.
            --------------------------------------------------------------------------------------------------
            create or replace FUNCTION test_load_runner
            (
            p_assignment_id IN NUMBER
            )
            RETURN VARCHAR2 IS
            cursor test_load
            is
            select 1
            from per_all_people_f
            where employee_number = '938114';

            --
            l_var varchar2(1);
            begin
            --
            open test_load ;
            fetch test_load into l_var ;
            if test_load%found
            then
            return 'Y' ;
            else
            return 'N';
            end if ;
            close test_load ;
            end ;
            --------------------------------------------------------------------------------------------------
            The function is having only one employee, but it is taking very long time as compared to entering Person Name parameter.


            Please let me know if there is an alternate for this.

            thanks.
            • 3. Re: Advanced Benefits : How to use Person Selection Rule?
              Gaurav Bhardwaj
              Okie.....then lets do this..

              FORMULA TEXT:
              **********************************************************************/
              /*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
              /*=========== DATABASE ITEM DEFAULTS ENDS======================*/
              /*============ INPUT VALUES DEFAULT BEGIN ======================*/
              /*============== INPUT VALUES DEFAUT ENDS ======================*/
              /*================= INPUTS SECTION BEGIN ========================*/
              /*================== INPUTS SECTION ENDS ========================*/
              /*================ FORMULA SECTION BEGIN =======================*/

              l_ret = PER_SELECTION_FUN ( hard code all your employee number here like '938114' )

              return l_ret

              Function will be -

              CREATE OR REPLACE FUNCTION test_load_runner (p_employee_number IN NUMBER)
              RETURN VARCHAR2
              IS

              BEGIN
              --

              RETURN 'Y';

              END;

              Lets try this and let me know if this does not resolve ur issue.

              Gaurav
              • 4. Re: Advanced Benefits : How to use Person Selection Rule?
                Gaurav Bhardwaj
                Hi Sriram

                Any luck on your issue ?

                Thanks,
                Gaurav