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.
Following is the pictorial representation of multi org structure in oracle for a business
where ATC INDIA Limited is taken as example.
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
This comment has been removed by the author.
ReplyDelete