Folks, here again I came up with an interesting difference between Org_id and Organization_id that has been mumbling often in heads of my fellow Oracle technical consultants. Also during an interview or in front of a client they get confused to what exactly is the difference between them.
The difference is not vast but still it is inevitable to possess knowledge about it.
Org_id (Operating Unit)
Imagine you are an owner of a big company whose branches are spread in three countries, India, USA and UAE. Only one Oracle Apps instance is available where all your data is stored. You want John of USA to see data of USA only, not India and UAE. And data and rules corresponding to US location should not be applied to transactions carried out at India location. Of course, Samir of India and Maqbool of UAE will be worried if they see US transactions on their screen, don’t you think?
In order to meet this requirement you will define three operating units, one for each location. Each operating unit will have a unique id for identification, which is called Org_Id. For transactional purpose you will define responsibility for each location and attach respective Org_Id to it. By doing this, John of USA will not see any data/rules applicable to India or UAE.
Organization_id (Inventory Organization Id)
In India operating unit you have offices at several locations like Mumbai, Pune, Gurgaon and Bangalore. Each of these locations will have their own inventory in which they will maintain their stocks. This inventory is called Organization_Id or Inventory_Org_Id in Oracle Apps.
So, one operating unit may have multiple inventory organizations but one inventory organization will have only one operating unit.
My posts will be short and simple as you could grab them in your free office time or in stringent time while you are working on something important. Moreover, I believe learning should be fun.
Put your comments below if you liked the above post.