Setup and Implementation

Before beginning the setup, check that you have the following:

Setting Up a Multiple Organization Enterprise

This chapter describes how to implement your organizational structure within the Oracle Applications Multiple Organization model. Before beginning the implementation, be sure you are familiar with the terminology Oracle uses for its business organization model. For more information, see Overview.

These are the steps to follow when implementing the Multiple Organization support feature in Oracle Applications.

  1. Develop the Organization Structure
  2. Define Accounting Setups
  3. Assign Balancing Segment Values by Legal Entity (optional)
  4. Define Locations
  5. Define Business Groups (optional)
  6. Define Organizations
  7. Define Organization Relationships
  8. Define Responsibilities
  9. Associate Responsibilities with Business Groups
  10. Define Security Profile and Multiple Organizations (MO) Profile Options
  11. Run the Replicate Seed Data program
  12. Verify Order Management System Parameter Settings
  13. Set Application-Specific Profile Options Specific to Operating Units
  14. Define Inventory Organization Security (optional)
  15. Implement the Applications Products
  16. Run the Multiple Organizations Setup Validation Report (recommended)
  17. Implement Document Sequencing (optional)
  18. Set Conflict Domains (optional)
  19. Specify User-Level Multiple Organizations Preferences (optional)

Implementing Multiple Organization Support

This section describes the steps to implement Oracle E-Business Suite Multiple Organizations.

Step 1: Develop the Organization Structure

A successful implementation of Multiple Organization support in Oracle Applications depends primarily on defining your organizational structure in the multi-level hierarchy used by Oracle Applications. The levels are:

The Organization Structure Example in the figure below illustrates the organization structure.

For more information, see Overview.

For more information, see Organization Hierarchies, Oracle Human Resources Management Systems Enterprise and Workforce Management Guide.

Deciding on the Organization Structure

First, you need to decide on the organizations you will use in your multiple organizations implementation. The figure below shows a corporation with two business groups, three legal entities, four operating units, and five inventory organizations. This example organization structure is used throughout most of this chapter.

Organization Structure Example

The business groups are U.S. and U.K. The U.S. business group consists of two legal entities - Western Division and Eastern Operations. These legal entities are assigned to the same ledger (US Operations) because they share the same ledger currency, accounting flexfield structure, and calendar. The U.K. legal entity - UK Division - is assigned to a separate ledger (UK Operations) because its ledger currency is different from that of the U.S. legal entities.

The US Western Division legal entity consists of two operating units - Northwest Region and Southwest Region. The Northwest Region consists of two inventory organizations - Plant 1 and Plant 2. The Southwest Region has one inventory organization, named Plant 3. The US Eastern Operations legal entity is also an operating unit and inventory organization.

The UK Division legal entity has one operating unit, named UK Sales Office. The operating unit has one inventory organization, named UK Plant.

Step 2: Define Accounting Setups

Use the Accounting Setup Manager in Oracle General Ledger to define accounting setups that include the following common financial components:

To use multiple organizations, you must define an accounting setup with at least one legal entity, a primary ledger that will record the accounting for the legal entity, and an operating unit that is assigned to the primary ledger and a default legal context (legal entity). It is also recommended that balancing segment values be assigned to the legal entity to help you identify legal entity transactions during transaction processing and reporting and to take advantage of Intercompany Accounting.

Note: If your enterprise structure requires that you define a business group, you should define accounting setups before business groups.

The following table explains the ledger parameters for our example.

Ledger Name Ledger Short Name Ledger Currency Chart of Accounts Calendar Subledger Accounting Method
U.S. Operations US_Op USD Standard Standard Standard Accrual
U.K. Operations UK_Op GBP Standard Standard Standard Accrual

For more information, see Using Accounting Setup Manager, Oracle Financials Implementation Guide.

Step 3: Assign Balancing Segment Values by Legal Entity (optional)

Assign specific balancing segment values to legal entities using Accounting Setup Manager. This allows users to identify and secure transactions by legal entity. It also allows you to use Advanced Global Intercompany System to enter intercompany transactions between legal entities.

Organization Structure with Balancing Entity Example

The figure depicts a corporation with two business groups, three legal entities, four operating units, and five inventory organizations. Balancing entities are also shown. The business groups are U.S. and U.K. The U.S. business group consists of two legal entities - Western Division and Eastern Operations. These legal entities are assigned to the same ledger (US Operations). The Western Division is balancing entity 01 and balancing entity 04. Eastern Operations is balancing entity 02. The U.K. legal entity - UK Division - is assigned to a separate ledger (UK Operations) because its ledger currency is different from that of the U.S. legal entities. The UK Division is balancing entity 03. The US Western Division legal entity consists of two operating units - Northwest Region and Southwest Region. The Northwest Region consists of two inventory organizations - Plant 1 and Plant 2. The Southwest Region has one inventory organization, named Plant 3. The US Eastern Operations legal entity is also an operating unit and inventory organization. The UK Division legal entity has one operating unit, named UK Sales Office. The operating unit has one inventory organization, named UK Plant.

If you need to further secure balancing segment values for each operating unit of a legal entity, you can define segment value security rules and assign them to all responsibilities associated with the relevant operating units. If, for example, you need to restrict the Northwest Region operating unit to balancing segment value 01 and the Southwest Region to balancing segment value 04, because you have two sets of users who process data for each of the legal entities, you can add rules as described in the following table.

Value Set Security Rule Type Element Low Element High Element
Division Northwest Include 01 01
Division Southwest Include 04 04

In addition to the previous rule assignments, you can assign the new rules to all responsibilities associated with the two operating units, as illustrated in the table below. When you assign multiple rules to the same responsibility, only the overlapping values of the rules are available to users of the responsibility.

Responsibilities Value Set Security Rule
All responsibilities for Northwest Region operating unit Division Northwest
All responsibilities for Southwest Region operating unit Division Southwest

Step 4: Define Locations

Use the Define Location window to define names and addresses for the locations you use within your enterprise. You define each location once only. This saves you time if you have multiple organizations with the same location. You should define locations for your legal entities and inventory organizations. Oracle Applications products use locations for requisitions, receiving, shipping, billing, and employee assignments.

Step 5: Define Business Groups (optional)

Note: This section applies to you if you have more than one business group, or if you do not choose to use the predefined business group provided by Oracle Applications.

Oracle Applications secures human resources information, including organization definition, by business group.

You must have at least one business group. For a fresh installation, Oracle Applications provides a predefined business group, Setup Business Group. You can define additional business groups as required for your enterprise. We recommend that you modify the predefined business group rather than defining a new one. If you define a new business group instead of modifying the predefined business group, you need to set the Business Group profile option at the responsibility level for the new business group. Oracle Human Resources automatically creates a security profile with the business group name when you define a new business group.

You should define all your business groups before defining any other type of organization.

Note: If you plan to implement HRMS, you should consider its organization requirements when defining the organization structure. When considering multiple business groups, employee data will have to be entered and maintained for every business group using responsibilities linked to each business group. Consult your HR specialist for more information on HR organization considerations.

To define additional business groups:

  1. Set the responsibility from which you define the organizations in the profile option HR: User Type to HR User, to get access to the Define Organizations window. This profile must be set for all responsibilities that use tables from Oracle Human Resources (for example, responsibilities used to define employees and organizations).
  2. Define all of your business groups at this step from a responsibility. Do not define any new organizations or organization hierarchies until you have associated each business group with a responsibility. You do this by setting the HR: Security Profile profile option for each responsibility. For more information, see Security Profiles, Oracle Human Resources Management Systems Configuring, Reporting, and System Administration Guide.
  3. After you have correctly associated your business groups with a responsibility, sign off and sign on again using the correct responsibility for the business group you want to define. For example, if you have a U.S. business group and a U.K. business group, select the responsibility attached to the U.S. business group to define the U.S. organization structure. Note: Oracle Human Resources automatically creates a view all security profile with the business group name. This enables you to view all records for your business group. Oracle Human Resources allows you to use a single responsibility security model by enabling the Security Group. This allows you to access more than one business group from a responsibility. You should not use the single responsibility model in Multiple Organization products.

Step 6: Define Organizations

Use the Define Organization window to define organizations, such as operating units and inventory organizations. You can also define operating units and assign them to a primary ledger and default legal context using Accounting Setup Manager in General Ledger.

Note: If you choose to define operating units using the Define Organization window, you can still view them in Accounting Setup Manager by querying the primary ledger of the operating unit.

You can perform this step and the next step (Define Organization Relationships) at the same time. The steps are presented separately to emphasize the difference between the organizational entity and the role it plays in your organizational structure.

To define operating units and inventory organizations:

  1. Log in using the responsibility associated with the business group.
  2. Define operating units.
  3. Define inventory organizations for each operating unit that will have an inventory organization. Note: Do not define the inventory parameters at this point.

If you have responsibilities for different business groups, switch responsibilities and define the organization structure.

The following table summarizes information about the different organizations for our example hierarchy.

Organization Name Operating Unit Inventory Organization?
Western Division
Eastern Operations Yes Yes
U.K. Division
Northwest Region Yes
Southwest Region Yes
U.K. Sales Office Yes
Plant 1 Yes
Plant 2 Yes
Plant 3 Yes
U.K. Plant Yes

For more information, see Define Organization, Oracle Human Resources Management Systems Enterprise and Workforce Management Guide.

Step 7: Define Organization Relationships

Use the Define Organization window to define organization relationships by assigning classifications to each organization. The attributes of certain classifications relate organizations and the roles they play. You can classify an organization as any combination of legal entity, operating unit, and inventory organization. Specify your organization classifications in the following order:

  1. Operating units Attach the operating units to the correct ledger and a default legal context (legal entity).
  2. Inventory organizations Attach the inventory organizations to the correct operating unit, legal entity, and ledger.

If you have more than one business group, change to the responsibility associated with the other business group and continue defining your organization classification.

The table below shows the information you must enter for each organization classification.

Classification Information Type Required Attributes
Business Group Business group information if Human Resources is installed. Otherwise, None. Short Name, Employee/Applicant Numbering, Key Flexfield Structures, Default Legislation Code, and Currency
Operating Unit Operating Unit Information Primary Ledger, Default Legal Context
Inventory Organization Accounting Information Primary Ledger, Legal Entity, Operating Unit

Special Considerations for Inventory Organizations

All the inventory organizations in the above chart have been set up with the minimal amount of information to enable them in the Multiple Organizations environment. This minimal amount is detailed in the table below.

If you plan to implement Oracle Inventory, you must follow the setup procedures for that product.

For more information, see Overview of Setting Up, Oracle Inventory User's Guide.

For a standalone Oracle Purchasing installation (without Oracle Inventory), specify the information shown in the following table:

Sequence Additional Organization Information Required Information
1 Accounting information Primary Ledger, legal entity, operating unit
2 Receiving information Three-character organization code, prefix serial (no dummy)
3 Inventory information All required accounts

Location: You must specify a location for an organization classified as an inventory organization. You can assign any location that is not assigned to a different inventory organization, or you can assign a location that is linked to the current inventory organization.

Receiving Information: When you select the Receiving Information type, you navigate to the Receiving Options window. Use the Receiving Options window to define options that govern receipts in your system. You cannot receive items into an inventory organization until you specify receiving options for the organization.

Inventory Information: When you select the Inventory Information type, you navigate to the Organization Parameter window. You must define the control options and account defaults for one inventory organization, the item master organization. Then you can easily assign items to other inventory organizations without recreating all the item information. Use the Organization Parameter window to assign inventory organizations to the item master. The item master organization uses itself as the item master.

There is no functional or technical difference between the item master organization and other inventory organizations. However, we recommend that you limit the item master to just an item definition organization. If you set up new inventory organizations in the future, you can assign the new items to only the item master and the new inventory organization.

Note: You can navigate to the Receiving Options window and Organization Parameter window from the Define Organization window if you use one of the following predefined responsibilities: Purchasing Super User, Inventory, Inventory Item, Project Billing User, Project Costing Super User, Sales and Marketing Super User, and Territory Administrator.

Step 8: Define Responsibilities

Use the Define Responsibility window to define responsibilities for each operating unit by application. When you sign on to Oracle Applications, the responsibility you choose determines the data, forms, menus, reports, and concurrent programs you can access.

You should consider using naming conventions for the responsibility names in a Multiple Organization environment. It is a good idea to use abbreviations of the business function and the organization name to uniquely identify the purpose of the responsibility, for example, Payables Manager Northwest or Western Receivables Super User.

For more information, see Define Responsibility, Oracle Applications System Administrator's Guide - Security.

Step 9: Associate Responsibilities with Business Groups (optional)

If you have multiple business groups, you must associate each responsibility to one and only one business group. You associate a business group with a responsibility using the HR: Business Group system profile option. If you are upgrading to Multiple Organizations, you must also associate previously created responsibilities to the appropriate business group.

Note: This section applies to you if you have multiple business groups, or if you do not choose to use the default business group provided by Oracle Applications.

Step 10: Define Security Profile and Multiple Organizations (MO) Profile Options

Multiple Organizations provides the following security profiles which enables users to access, process, and report data in multiple operating units from a single responsibility:

The decision to use the Security Profile or the Global Security Profile depends on your HR implementation and how you want to partition the data. If you want users to access operating units across business groups, then define Global Security Profiles. Otherwise, use the standard Security Profile.

After you define your security profiles and run the Security List Maintenance program, you can assign them to responsibilities or users using the MO: Security Profile profile option. If you set the MO: Security Profile profile option, you can also set the MO: Default Operating Unit profile option to specify a default operating unit.

Note: If the MO: Security Profile is set, then the MO: Operating Unit profile is ignored.

Note: If you are using Journal Tax in General Ledger to enter taxable journal entries, you must set the MO: Operating Unit profile option for General Ledger responsibilities. General Ledger derives the correct tax codes based on the tax setup for the operating unit that is specified in the MO: Operating Unit profile option.

You must set either the MO: Operating Unit or MO: Security Profile profile option for each application responsibility to use Multiple Organizations context sensitive applications.

When you connect to the Oracle Applications, you sign on by entering your user name and password. Then, you choose a responsibility that is available to your user. After you choose your responsibility, there is an initialization routine that reads the values for all profile options assigned to that responsibility. Oracle Applications allows you to see only the information for those operating units that are assigned to your responsibility.

When drilling down on balances from Oracle General Ledger, General Ledger ignores the operating unit profile setting to allow you to drill down to your subledger details, regardless of which operating unit originated the transaction.

Note: If you upgraded from Release 11i to Release 12 and you plan to have a single responsibility access multiple operating units, you may need to modify existing segment value security rules. This only applies to companies that use a single, global chart of accounts where different ranges of values, such as accounts or departments, are reserved for specific operating units. For example, if you have departments 100-300 reserved for Operating Unit 1 and departments 500-800 reserved for Operating Unit 2, users may need to modify segment value security rules if a single application responsibility will now be entering data for both Operating Unit 1 and Operating Unit 2.

Multiple Organizations Profile Options

When implementing multiple organizations for Oracle Applications, you must set values for each profile option to specify how each product in Oracle Applications controls access to and processes data.

See: Setting User Profile Options, Oracle Applications System Administrator's Guide - Maintenance.

The following are the Oracle Applications multiple organizations profile options and are grouped under the Access Control profile option category:

Profile Option Category and Profile Options Descriptions

This section describes profile options by category.

The table in this section provides profile option information as follows:

The key for the each table is:

Access Control Category

The table below lists the profile options that controls the access to the various organizations, across products in Oracle Applications.

Access Control
Profile Option Default User Access System Administration: Site System Administration: Application System Administration: Responsibility System Administration: User
MO: Default Operating Unit Update Update Update Update Update
MO: Operating Unit No Access Update Update Update Update
MO: Security Profile No Access Update Update Update Update

MO: Default Operating Unit

Use this profile option to specify a default operating unit from the list of operating units assigned to your application responsibility through the MO: Operating Unit or MO: Security Profile.

Note: If the MO: Operating Unit is set or you are assigned only one operating unit in the MO: Security Profile profile option, then the single operating unit becomes your default operating unit.

MO: Operating Unit

Assign this profile option to an application responsibility to provide a user with this responsibility access to one operating unit.

MO: Security Profile

Assign this profile option to an application responsibility to provide a user with this responsibility access to multiple operating units.

Step 11: Run the Replicate Seed Data Program

A multiple organizations enterprise requires the ability to replicate the seed data to multiple operating units. Use the Replicate Seed Data program to replicate the seed data. The seed data is replicated in the following events:

The seed data replication program operates in two modes:

Step 12: Verify Order Management System Parameter Settings

If you have different item validation organizations for each operating unit, verify the correct setting for each operating unit in the Order Management system parameter window.

For more information, see Enabling Parameters, Oracle Order Management User's Guide.

Step 13: Set Application-Specific Profile Options Specific to Operating Units

Some profile options, including AR: Receipt Batch Source and AR: Transaction Batch Source, reference data that is secured by operating unit. You must set these profile options at the responsibility level. You should choose a value corresponding to the operating unit of the responsibility.

The following profile options need to be set for each responsibility for each operating unit wherever applicable:

Step 14: Define Inventory Organization Security (optional)

With inventory organization security you can restrict inventory organization access to specific responsibilities. You may want to restrict your manufacturing users to certain organizations according to your organizational hierarchy. This feature has the following characteristics:

Step 15: Implement the Applications Products

After the steps above are complete, go into each operating unit and set up the Oracle Applications products. The following products must be set up for each operating unit:

Note: This list is not a complete list. Please refer to the product-specific guides if operating unit setup is required.

Oracle Assets, Oracle General Ledger, Oracle Inventory, and Oracle Manufacturing products are set up once for the installation only, not for each operating unit. To setup the products, follow the instructions in the specific user guides.

Define Operating Units

The following setup data must be set up for each operating unit:

Cash Management

Order Management