Difference between org_id & organization_id??

[Rammi]

Hi Folks,

GoodDay, Please let me know the difference between org_id & organization_id. Iam always confused about that..

Regards,
Ram.

[arun1203]

Hi Ram[:)],

For instance let us say you are having <font color="red"><b>Inventory Store</b>.</font id="red">
You have Inventory Stores in two different countries like <b>India and USA</b>
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 <font color="red"><b>ORG ID</b>.</font id="red">

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 <font color="red"><b>Organization ID</b>.</font id="red">

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.

Hope now it is clear to you.

<font color="red"><b>Best Regards [:)],
Arun Reddy.
E-Mail:arunapps@gmail.com</b></font id="red">

[Rammi]

Hi Arun[:)],

Thanks a lot, your explanation is simply superb. Now i got better idea abot org_id & organization_id. I am very much thankful to you..

Regards,
Ram.

[admin]

and ORG_ID column is added in the tables after enabling multi org using adadmin.

Thanks Arun for such nice explanation.

[venket_apps]

hi sir
u r expalnation is excelent to under stand the problam

thanking U

[karthi_r]

All Organizations (BG, OU, IO etc) have organization ids. The Organization id of an OU is also called org_id

[niletra]

From which resonsiblity and what is the navigation for create
1)ORG_ID
2)ORGANIZATION_ID
IN R12

[rehan]

Thanks arun,

Nice Explanation.

Rehan