3 Replies Latest reply on Apr 29, 2015 9:20 AM by Bashar.

    Order of Operating Unit

    Sanjay Desai EBS

      Hi ,


      While creating a operating unit ,  new organization (OU) is created with random order.

      What is the logic behind it ?

      Anyone can share the knowledge ?


      Thanks in advance


        • 1. Re: Order of Operating Unit



          What do you mean by random order?

          Do you mean the org_id?




          • 2. Re: Order of Operating Unit
            Sanjay Desai EBS

            We are using R12.1.3,


            Our organization have so many group organizations.

            When we have created a new operating unit for each, the operating unit is created with ID (org_id)   -- 41, 42, 43, 44, 45,46, 141, 149, 280, 285, 372, 442, 542, 604, 605, 704, 784. --  that you can review the same in hr_operating_units (organization_id column) table.


            Now, you can see that there is no equal gap or specific logic to create a org_id. I want to know that.

            • 3. Re: Order of Operating Unit



              The org_id is generated from a database sequence.

              The sequence has a cache setting. When you generate one value, the number in the cache setting is allocated. When you close the session and enter a new session, you will start from the number after the allocated range.

              For example, assume that the cache value is 100.

              If you enter the form the define 5 organizations then they will have the org_id 1,2,3,4 and 5.

              If you close the form and come back later to define another 3 orgs, they will have the org_id 101,102 and 103.

              Moreover, the org_id is not only for hr orgs, other types of organizations will use the same sequence.


              You should not worry about these gaps because the users will not see them and you should not use them in any reporting tool.