What is ORG ID and Organization ID

ORG ID:

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 should not 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. Indian Employees 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 Americans will not see any data/rules corresponding to India.

 

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. 

---------------------------------------------------------------------------------------------------------

SELECT * FROM HR_OPERATING_UNITS ORDER BY 1;

SELECT organization_id,operating_unit,organization_name FROM ORG_ORGANIZATION_DEFINITIONS ORDER BY 2;