The Oracle E-Business Suite Multiple Organizations Architecture (hereafter referred to as Multiple Organizations), provides support for multiple organizations in a single installation of Oracle E-Business Suite, with relationships you define. Multiple Organizations specifies how the different organizations interact, and how transactions flow between them. These organizations can be ledgers, business groups, legal entities, operating units, or inventory organizations.
When you run any Oracle E-Business Suite product in a Multiple Organizations environment, you first choose an organization, either implicitly (by choosing a responsibility), or explicitly (by selecting an operating unit when entering data in transaction entry pages, or by running reports). Inventory organizations can be selected in the Choose Organization window; each subsequent window and report displays information for the chosen organization only.
The following terms are fundamental to the Multiple Organizations architecture:
Note: For further details, see: Oracle E-Business Suite Multiple Organizations Implementation Guide, Oracle General Ledger Implementation Guide, and Oracle Financials Implementation Guide.
Tables that contain Multiple Organizations data can be identified by the suffix "_ALL" in the table name. These tables include a column called ORG_ID, which partitions Multiple Organizations data by organization..
Every Multiple Organizations table has a corresponding view that partitions the table's data by operating unit. Multiple Organizations views partition data by including a DECODE on the internal variable CLIENT_INFO. This variable is set by the security system to the operating unit designated for the responsibility. It operates is a similar way to the LANGUAGE variable, which returns the language of the current session.
Note: If accessing data from a Multiple Organizations partitioned object when CLIENT.INFO has not been set (for example, from SQL*Plus), you must use the _ALL table, not the view.
SO_HEADERS_ALL, with its corresponding view SO_HEADERS, is an example of a Multiple Organizations partitioned object.
When you install a production Oracle E-Business Suite system, the data model is identical whether you implement Multiple Organizations or not. The Multiple Organizations views used to partition data are incorporated into the normal install, and use predefined text. When you convert to Multiple Organizations, tables are renamed to use the "_ALL" suffix to denote that they now contain Multiple Organizations partitioned data.
In Release 12.2, the AD Administration utility is used for the initial conversion of seed data and transaction data to Multiple Organizations format. Note that the underlying data model is not changed. When you create a new operating unit, a concurrent program adds the appropriate seed data.
Note: For further details, see AD Administration, Oracle E-Business Suite Maintenance Guide.