1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Difference between Org_id ,organization_id and operating_unit

Discussion in 'General' started by robin, Mar 31, 2011.

  1. robin

    robin Forum Advisor

    Likes Received:
    Trophy Points:

    Can anyone please explain me the difference between these columns in oracle apps :

    Please explain with an example.I am confused with these terms.

    Thanks in Advance,
  2. Sadik

    Sadik Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Hi Robin,

    I presume you are looking at some table structure. Operating unit is a concept in Apps referring to it's multi-org structure. In the most basic of definitions, it is actually used for data security of financial transactions. But I am afraid, i am confusing you more than helping you, so I suggest you read some of the documents on Mult-Org present in our Documents section. There are many which would help you.
  3. johnsmith22

    johnsmith22 Guest

    For instance let us say you are having Inventory Store.
    You have Inventory Stores in two different countries like India and USA
    You have installed Oracle Apps single instance and entered all the suppliers information,customers data,tax rules etc.

    And your business requirement is like this, all the rules and the data corresponding to indian store shouldnt be applicable/available to american store and vice versa.

    So to meet the above requirements you will define two operating units one for india and one for USA.
    Now each operating unit will have an ID known as ORG ID.

    And we use ORG ID to secure our business data.

    Now to do transactions for indian operations you need to define one responsibility and attach indian ORG ID to this responsibility.By this an indian will not see any data/rules applicable to USA.

    Similarly you will define another responsibility for USA and attach USA's ORG ID to this responsibility so that an american will not see any data/rules corresponding to India.

    This is the concept of ORG ID.

    Now let us see what is Organization ID.

    Within India you have got various branches in different parts of the country in different states like AP,UP,MP etc.
    And the business requirement is like this in AP you will maintain stock of Rice,UP for Wheat and MP for Maize.
    To meet this business requirement you will define 3 Inventory Organizations under Indian Operating Unit to maintain the respective stocks of the states..

    Each Inventory Organization will have an Organization ID.

    This is the outline of the differences between ORG ID and Organization ID.
    tejas1, robin and Sadik like this.
  4. saurovroy

    saurovroy Active Member

    Likes Received:
    Trophy Points:
    Check org_organization_definitions table. This table gives a clear picture what is the organization_id and the operating unit associated with the organization_id.