Single OU verses Multiple OUs in Oracle

Advantages and constraints of single and multiple OU in Oracle, How to choose between Single OU or Multiple OU in Oracle, Difference between Single Operating Structure and Multiple Operating Unit Structure in Oracle.

Multiple Operating Unit Structure Advantages/Constraints  

• Easier to maintain the system

• System will not provide Trx/Entity segregation by Plants & Branches

• Faster configuration and data migration

• Limited Trx/Entity security by Plants & Branches achieved through –

• Order Management Order Types by Branches

• Processing Constraints to enforce Trx security for Branches

• Customer setups to default Order Trx Type and IO based on responsibility

• Use Oracle provided library to restrict access to the trx /entities

• Decentralized Accounting / Purchasing / Sales

• Extended Testing Activity 

Single OU 

• Patch application and version upgrade will be easier

• No decentralized Accounting /

• Purchase / Sales

• Uni-logon Enterprise-wide view of Transactional data

• No Intercompany accounting of payables and receivables invoices

• Transaction/Entity security by Plants & Branches and data integrity by organization entities

• Complex maintenance

• Debugging Data Error

• Version Upgrade

• Patch Application

• Order Management,

• Accounts Receivables reports by Branch

• Tedious Data Migration

• Automatic Inter-company transactions

• Multiple login required to view enterprise-wide transactional data