- OracleApps Epicenter - http://www.oracleappshub.com -

Understanding Multi-Organization Structure in EBS(Technical) – Part II

The multiple organization support feature uses native database features to build a security layer on top of a single installation of Oracle Applications. This layer of security provides the necessary data partitioning; while at the same time minimizes the number of potentially destabilizing changes to the application code itself. The security layer is provided using database views, which allow access to the partitioned data without any changes to the applications code.

For ERP applications, data partitioning is performed by database views. These views reside in the APPS Oracle schema and derive the appropriate operating unit context from an RDBMS variable.

All applications code is run against the APPS schema. The Applications database architecture is now the same for a Multiple Organizations and non-Multiple Organizations implementation.

Multi Organization Tables

Applications with Partitioned tables

o Oracle Cash Management
o Oracle Order Management and Shipping Execution
o Oracle Payables
o Oracle Property Manager
o Oracle Projects
o Oracle Purchasing
o Oracle Release Management
o Oracle Receivables
o Oracle Sales Compensation
o Oracle Sales and Marketing
o Oracle Service
o European Localizations
o Latin America Localizations
o Regional Localizations

RDBMS Variable
A global variable exists in the Oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes are used to store the operating unit ID (or ORG_ID) for the Multiple Organization Support feature. The CLIENT_INFO context is derived from a profile option that the user sets for each responsibility as part of the Multi-Org setup steps.

select * from <table name>_ALL
where ORG_ID = SUBSTRB(USERENV('CLIENT_INFO'),1,10);

4 Comments (Open | Close)

4 Comments To "Understanding Multi-Organization Structure in EBS(Technical) – Part II"

#1 Pingback By “Business Group” in EBS On February 22, 2008 @ 12:22 am

[…] Understanding Multi-Organization Structure in EBS(Technical) – Part II […]

#2 Pingback By Quick notes Order 2 Cash Cycle On February 22, 2008 @ 1:08 am

[…] Understanding Multi-Organization Structure in EBS(Technical) – Part II […]

#3 Comment By Appani Yugandhar On April 13, 2008 @ 10:02 am

It is good.
Please prepare one more artical with more then one sob

#4 Pingback By 11i Setup for LE & OU On August 11, 2008 @ 12:39 am

[…] Understanding Multi-Organization Structure in EBS(Technical) – Part II […]