This discussion is archived
4 Replies Latest reply: Mar 14, 2011 12:41 AM by Gaurav Bhardwaj RSS

Advanced Benefits : How to use Person Selection Rule?

791471 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Hi Sriram

    Any luck on your issue ?

    Thanks,
    Gaurav

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points