1 2 Previous Next 16 Replies Latest reply: Dec 16, 2013 4:12 PM by user589333 RSS

    How do you limit user access to specific organizations within Projects in R12?

    user589333

      Our main objective for projects security is to have the ability to limit our users to specific organizations within our hierarchies. We currently have multiple business units with multiple hierarchies. As it stands now in 11i we can limit user access to any level and below within a hierarchy using the projects security function. We were told, by Oracle support, that this functionality was a mistake and has been deprecated in R12. An example of how our structure is setup and how we need to limit users follows:

       

      Top Level Company Organization

           Corporate Structure (Consists of multiple departments)

                Corporate Department 1

                Corporate Department 2

           Region 1

                Region 1 Division 1

                Region 1 Division 2

                Region 1 Branch 1

                Region 1 Branch 2

           Region 2

                Region 2 Division 1

                Region 2 Division 2

                Region 2 Branch

       

       

      We have users ranging from VPs to division managers that need access to only the projects they are responsible for within their location.

       

      Operations VP (Access to whole Hierarchy)

       

           Corporate Department 1 Manger (Access to just Corporate Department 1)

           Corporate Department 2 Manger (Access to just Corporate Department 2)

       

           Region 1 Manager (Access to all of Region 1)

                Region 1 Division 1 Manager (Access to just Region 1 Division 1)

                Region 1 Division 2 Manager (Access to just Region 1 Division 2)

                Region 1 Branch 1 Manager (Access to just Region 1 Branch 1)

                Region 1 Branch 2 Manager (Access to just Region 1 Branch 2)

       

           Region 2 Manager (Access to all of Region 2)

                Region 2 Division 1 Manager (Access to just Region 2 Division 1)

                Region 2 Division 2 Manager (Access to just Region 2 Division 2)

                Region 2 Branch 1 Manager (Access to just Region 2 Branch 1)

       

      We also have cases where some managers may need to access to a mix of the organizations within any given hierarchy.

        1 2 Previous Next