8 Replies Latest reply: Mar 16, 2013 9:29 PM by igwe RSS

    Leave of absence replaced by lov

    igwe
      Hi everyone, for the SSHR absence management form, I am trying to limit the replaced by LOV to only people in my business group. It is picking everyone across the company which isn't what I was hoping for. Does anyone have a workaround for this?
      Many Thanks,
      Igwe
        • 1. Re: Leave of absence replaced by lov
          igwe
          Just to note, I already set the HR:Cross Business Groups profile option to No.
          This problem also comes up in the employee directory sshr function
          • 2. Re: Leave of absence replaced by lov
            Sanjay Singh
            Hi Igwe,

            This is an intended functionality, if you check the VO definition (oracle.apps.per.selfservice.absence.server.AbsenceReplacedByLovVO) it is intended to bring all the active employees in the company. I think the provided functionality is fine as in todays complex scenario employees may be linked across the world.
            If you still want to restrict it then it will be a simple VO extension where you can add the below condition in the standar VO definition

            AND paf.business_group_id = fnd_global.PER_BUSINESS_GROUP_ID

            Hope it helps.

            Thanks,
            Sanjay
            • 3. Re: Leave of absence replaced by lov
              igwe
              Thanks Sanjay. Unfortunately there are over 10,000 employees in the current organization so you can see how this is problematic. Will look into the VO extension. done it before
              • 4. Re: Leave of absence replaced by lov
                Asif Ali Khan
                Hi,

                To over come from this orcale provide a standard solution. Kindly follow the below steps to restrict the LOV.

                Step 1:- Go to Functional Developer
                Step2:-Query for the Object Name @Workflow Role LOV
                Step3:- Click on the name @ Workflow Role LOV

                Step4:- Create a New Instance Set
                Step5:-Provide the Name, Code & Description
                Step6:- In the Predicate Field, enter your restriction criteria. For an Example

                ********************************************************************
                &TABLE_ALIAS.USER_NAME IN (
                SELECT USER_NAME FROM FND_USER FU, PER_ALL_PEOPLE_F PAPF
                WHERE FU.EMPLOYEE_ID = PAPF.PERSON_ID
                AND PAPF.BUSINESS_GROUP_ID = HR_GENERAL.GET_BUSINESS_GROUP_ID
                AND (PAPF.CURRENT_EMPLOYEE_FLAG = 'Y' or PAPF.CURRENT_NPW_FLAG = 'Y') AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
                )
                ********************************************************************
                Once you click on Apply, your object Instance Set will be created.
                Step7:- Go to Functional Administrator
                Step8:- Create a Grant
                Step9:- In the data security, provide the object name @Workflow Role LOV
                Step10:- In the Object Data Context, select instance set. Provide your Instance set name as defined in the functional developer responsibility.
                Step11:- In the Object Parameters and Select Set, select @ Workflow Role LOV Permission Set in the Permission Set.


                Hope it will help you.

                Thanks
                Asif
                • 5. Re: Leave of absence replaced by lov
                  igwe
                  Looks like today is my lucky day.
                  Thanks very much Asif
                  • 6. Re: Leave of absence replaced by lov
                    igwe
                    Hi Asif, this doesn't seem to be working. could you look at my setup dump and tell me where I've gone wrong. The LOVs for absence replacement and employee directory still return data for everyone.

                    View Grant: XXKSA Employee Self Service Replaced By LOV

                    Delete Update



                    Name XXKSA Employee Self Service Replaced By LOV

                    Description

                    Effective From 15-Mar-2013

                    Effective To



                    Security Context


                    Grantee Type All Users

                    Grantee Everyone

                    Operating Unit

                    Responsibility KSA Employee Self Service





                    Data Security


                    Object Workflow Role LOV



                    Data Context


                    Type Instance Set

                    Name XXKSA Employee Directory Instance Set

                    Description Limits Employee Directory to KSA Employees



                    Predicate


                    &TABLE_ALIAS.USER_NAME IN (SELECT USER_NAME FROM FND_USER FU, PER_ALL_PEOPLE_F PAPF WHERE FU.EMPLOYEE_ID = PAPF.PERSON_ID AND PAPF.BUSINESS_GROUP_ID = 721 AND (PAPF.CURRENT_EMPLOYEE_FLAG = 'Y' or PAPF.CURRENT_NPW_FLAG = 'Y') AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE )







                    Instance Set Details


                    Parameter 1

                    Parameter 2

                    Parameter 3

                    Parameter 4

                    Parameter 5

                    Parameter 6

                    Parameter 7

                    Parameter 8

                    Parameter 9

                    Parameter 10









                    Set


                    Name Workflow Role LOV Permission Set

                    Code WF_ROLE_LOV_PSET

                    Description Permission Set to Restrict the Visibility of Roles
                    • 7. Re: Leave of absence replaced by lov
                      Asif Ali Khan
                      Hi,

                      Please update u mail id i will send u the screen short.

                      Regards
                      Asif
                      • 8. Re: Leave of absence replaced by lov
                        igwe
                        thanks asif
                        it's daibatzu at gmail.com