Your Amazon Purchase Today

Tuesday, 8 March 2016

Oracle Multi-org structure In Oracle


Multi-org structure in Oracle


Multi-org structure in Oracle


In this post we will see what is multi org structure in oracle and will discuss this with detailed example.


Prior to the introduction of concept - Multi-Org structure in oracle, all of the Operating Unit or a business unit required a separate-separate Oracle instances. There was no possibility of One-to-many relationships between Sets of Books, Legal Entities, and Operating Units within one Oracle environment. 


Introduction of Oracle Multi-org structure In Oracle


Multi-org architecture in oracle is an application server-side enhancement which allowed multiple operating units and it's relationships to be defined in a single installation of Oracle Applications. This ensured that the data across each operation unit is separate and secure. 

In Oracle Multi-org structure user is allowed to logically partition its application data into one database. This type of organization called an Operating Unit , whose purpose is to secure your application data. It now supports multiple organizations of the enterprise in a single database application. It provided additional security to the data of different organizations in the enterprise.


Multi org structure means set-up of multiple business groups under one application installation.

Following is the pictorial representation of multi org structure in oracle for a business


where ATC INDIA Limited is taken as example.

Oracle Multi-org structure

Business group

Where business org (ATC INDIA) is the top most level. It typically manages human resources level info across various locations .

Ledger

ledger consists of '4 c'  i.e Calendar , currency, cart of accounts and SLA(subledger accounting)
As currency, calendar changes from country to country we require ledger to maintain them.

Legal Entity 

Legal entity is setup to maintain Govt. taxation, TAN, PAN information. labor laws and rules 

Operating Unit 

It handles sales and distribution operations.

Inventory Org  

Inventory org is the physical location where the items are kept. It maintains Items information 


                                                                                                                                      

Oracle Multi-org structure |Oracle application multi org structure | Multi org structure in oracle

1 comment:

Popular Posts