11i-Multi Org Overview & Setup

By: Sathish K Sr. ERP Consultant.

What is multi-org?
Multi-org is a server-side (applications and database) enhancement that enables multiple business units in an enterprise to use a single installation of oracle applications products while keeping transaction data separate and secure. The multi-org enhancement uses native database views to build a security layer on top of a single installation of oracle applications.

In oracle applications release 11i, the following products support multi-org capabilities
- Cash management. - Order management, shipping execution and release management. - Payables - Property manage - Projects - Purchasing - Receivables - Sales compensation - Sales and marketing - services

Multi Org Structure 11i

Business Group (BG)

Set Of Books (SOB)

(LE) Legal Entity

Operating Unit (OU)

Inventory Organization (IO)

What is a Business Group (BG)?

This is an organization that represents the consolidated enterprise, a major division, or an operation company and has no accounting impact. The business group partitions human resources information and the purchasing approval hierarchy .

What is Set of Books (SOB) ?

It is a financial reporting entity that shares the 3Cs : - A particular Chart of accounts (accounting flex field structure). - Functional Currency. - Financial accounting Calendar. General Ledger secures transaction information (journal entries, balances) by set of books. When you use General Ledger, you choose a responsibility that specifies a set of books. You then see information only for that Set of Books. You create Set of Books using the Set of Books window in General Ledger. You define all other types of organizations using the organizations window.

What is a Legal Entity (LE) ?

Represents a legal company for which you prepare fiscal or tax reports.

After defining a Business Group in the installation process (Note: you can define more Business Groups later) do the following steps:

Step 1: Design Organization Structure

Step 2: Define Location & Business Group Step 1: Define Set of Books (SOB) - 3Cs (Chart of accounts Calendar Currency). Step 2: Define Legal Entity (LE). Step 3: Define Operating Units (OU). Step 4: Define Inventory Organizations (IO). Step 5: Define a Responsibility or use an existing one. Step 6: Link the Responsibility with an application at the OU security level. Step 7: Run Request (Replicate Seed Data) to test the Operating Unit. Step 8: Create Profile (MO: Operating Unit) at the Responsibility level.

Step 1: Designing Organization Structure

Business Group ABC Corporation India

SOB - America

SOB- India

SOB - England

Legal Entity B Corporation

Legal Entity A Corporation

Legal Entity C Corporation

Operating Unit B1 Operations

Operating Unit A1 Operations

Operating Unit A2 Operations

Operating Unit C1 Operations

Inventory Org A10 Inventory

Inventory Org A20 Inventory

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Structure
Segment
Company

Value Set Name

ABC Corp Company

Security type
Non -Hierarchical Security Non -Hierarchical Security Non -Hierarchical Security Non -Hierarchical Security

List type
List of Values List of Values List of Values List of Values

Format type
Char 2

Maximum size

Uppercase only
Yes

Validation type
Independent

Branch

ABC Corp Branch

Char

Yes

Independent

Cost Centre

ABC Corp Cost Centre ABC Corp Account

Char

Yes

Independent

Account

Char

Yes

Independent

Activity

ABC Corp Activity

Non -Hierarchical Security

Non -Hierarchical Security Non -Hierarchical Security

List of Values
Pop list

Char

Yes

Independent

Future1

Future1

Char

Yes

Independent

Future2

Future2

Pop list

Char

Yes

Independent

Table # 1A

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Value set (For Segment "Company) General Ledger Setup >Financials >Flex fields > Validation > Sets20

Complete the Setup for all Value sets of Accounting Flex field(AFF)with Value set name & Parameters as mentioned in Table # 1A in similar way.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) General Ledger Setup >Financials >Flex fields > Key > Segments Select the Application General Ledger Flex field Title Accounting Flex field

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Insert the new Record under Structures with following details:
Code
ABC CORP_ACCOUNTING_FLEX

Title
ABC Corp Accounting Flex

Description
ABC Corporation Accounting Flex field

View Name
ABC_CORP_ AFF

Select Period(.) from Segment Separator. SAVE. Click on Segments

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Insert the Following Records against each field:

Number

Name

Window Prompt

Column

Value Set

1 2 3 4 5 6 7

Company Branch Cost Centre Account Activity Future1 Future2

Company Branch Cost Centre Account Activity Future1 Future2

SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7

ABC Corp Company ABC Corp Branch ABC Corp Cost Centre ABC Corp Account ABC Corp Activity ABC Future1 ABC Future2

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Insert the Following Records against each field: Click on Open to capture additional Information for each segment.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Check the Security Enabled box. (otherwise the flex field security rules will not work.) Repeat the same step for All the segments.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Flex field Qualifiers Setup Flex field Qualifiers for Company, Branch, Department (Cost centre) and Account. Repeat the same step for All the segments.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Flex field Qualifiers Flex field Qualifiers Enabled for different segments:
Segment Name Company Branch Cost Centre Natural Account Segment Name Balancing Segment Intercompany Segment Cost Center Segment Account Description
This attribute is used to identify the balancing segment. This is typically the company segment. This attribute is used to identify the intercompany segment This attribute is used to identify the cost center segment. This attribute is used to identify the natural account segment.

Enabled Yes Yes Yes Yes

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Freeze & Compile N >> General Ledger Setup >Financials >Flex fields > Key > Segments Check -> Freeze Flex field definition & Allow Dynamic inserts Will get a warning message & Click OK. Select Compile. Click OK for Messages & Notes.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Setup for Accounting Flex Field(AFF) Check the request Status. N > View > Requests > Find

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets N > Setup > Financials > Flex fields > Key > Values Select Application -> General Ledger Title -> Accounting Flex field Structure -> ABC Corp Accounting Flex Select Find

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Company
Value 00 10 Description ABC Corporation India Total Company Enabled
Yes Yes

Parent

Qualifiers: Allow budgeting/Posting Yes Yes

Yes

No No

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Company Define : Child Ranges.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Branch
Value Description Enabled Parent Qualifiers: Allow budgeting/Posting Yes Yes Yes Yes Yes Yes Yes No No

00 01 02 99

Unspecified A1 Operations - Bangalore A2 Operations - Mysore Total Branch

Yes Yes Yes Yes

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Branch Define : Child Ranges.

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Cost Centre Repeat the same step as before for Cost Centre Segment with Values mentioned in below table.
Value 000 100 150 175 210 310 350 375 400 999 Description Balance Sheet Administration Finance Advertising Production Sales & Marketing European Sales American Sales Corporate Total Department Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Enabled No No No No No No No No No Yes Parent Qualifiers: Allow budgeting/Posting Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes No, No

Define Child Values:

From To Include

000

998

Child Values Only

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Cost Centre Repeat the same step as before for Cost Centre Segment with Values mentioned in below table.
Value 000 100 150 175 210 310 400 999 Description Balance Sheet Administration Finance Advertising Production Sales & Marketing Corporate Total Department Yes Yes Yes Yes Yes Yes Yes Yes Enabled No No No No No No No Yes Parent Qualifiers: Allow budgeting/Posting Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes No, No

Define Child Values:

From To Include 000 998

Child Values Only

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Account Repeat the same step as before for Account Segment with Values mentioned in below table.
Value
0000 Unspecified

Description
Yes

Enabled
No

Parent

Qualifiers: Allow budgeting/Posting

Yes Yes Expense No No

1000
1001 1002

Total Liabilities
Capital Account Retained Earnings

Yes Yes Yes Yes Yes Yes Yes

Yes
No No No No No No

No No Liability No No
Yes Yes Ownership No No Yes Yes Ownership No No Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No

1003
1004 1005 1006 1007 1008 1009 1010 1011 1012 1013

Sundry creditors
Rent payable Salary & wages payable Provision for depreciation Provision for bad debts Accrued Expenses Future dated Payment Inter Company Payables Payable - Suppliers Tax Payable Unearned Revenue

Yes
Yes Yes Yes Yes Yes Yes

No
No No No No No No

Yes Yes Liability No No

Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No Yes Yes Liability No No

Step 2 : Define Set Of Books (SOB)

Account Segment Values
Value Description 2000 Total Assets
2001 Sundry Asset
2002 Cash 2003 Building 2004 Vehicle 2005 Computers 2006 Machinery 2007 Cash Clearing A/C 2008 Proceeds of sale- Clearing 2009 Intercompany Receivables 2010 Depreciation Adjustments 2011 Asset Clearing Account 2012 Prepayments 2013 Other Recivables 2014 Unbilled Receivables 2015 Allowance for bad debt

Enabled Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Yes

Parent Yes
No No No No No No No No No No No No No No No

Qualifiers: Allow budgeting/Posting No No Asset No No

Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No Yes Yes Asset No No

3000 Total Revenue

3001 Sales - Training 3002 Rent Expense 3003 Realized Gain Account 3004 Unrealized Gain Account 3005 Sales - Consulting

Yes
No

No No Revenue No No
Yes Yes Revenue No No

No
No No No

Yes Yes Revenue No No

Yes Yes Revenue No No Yes Yes Revenue No No Yes Yes Revenue No No

Step 2 : Define Set Of Books (SOB)

Account Segment Values
Value Description
4000 Total Expenses
4001 Sales Expense 4002 Rent Expense 4003 Employee Headcount

Enabled
Yes Yes No No No No No No No No No No No No No

Parent

Qualifiers: Allow budgeting/Posting

No No Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No Yes Yes Expense No No

4004 Salary Expense

4005 Suspense Account 4006 Purchase Account 4007 Squre Feet 4008 Intercompany Account 4009 Bank Charges 4010 Freight 4011 Rounding 4012 Travelling Expense 4013 Bad debts 9999 Total Accounts

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Yes

Yes To

No No Revenue No No Include
Child Values Only Child Values Only Child Values Only Child Values Only

Define Child Values:

From 1000 2000 3000 4000 1999 2999 3999 4999

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Activity Repeat the same step as before for Activity Segment with Values mentioned in below table.
Value Description
0000 Unspecified 1000 Monitor 1001 Modem 1002 Keyboard 1003 GSM 1004 US24OPTX 1005 SIM Card 1006 Mobile

Enabled Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
No No No

Parent

No
No No No No No No No Yes

1007 Internet
1008 Fixed line 1009 Network Card 9999 Total Activity

Qualifiers: Allow budgeting/Posting Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes Yes, Yes No, No

Define Child Values:

From To Include 0000 9998

Child Values Only

Step 2 : Define Set Of Books (SOB)

Chart of Accounts: Filling Value sets -> For Segment Future 1 & Future2 Repeat the same step as before for Future1 Segment with Values mentioned in below table.
Value Description
000 Unspecified 999 Total Future1

Enabled Yes Yes

No Yes

Parent

Qualifiers: Allow budgeting/Posting Yes, Yes No, No

Repeat the same step as before for Future2 Segment with Values
Value Description
000 Unspecified 999 Total Future2

Enabled Yes Yes

No Yes

Parent

Qualifiers: Allow budgeting/Posting Yes, Yes No, No

Define Child Values:

From To Include 000 999

Child Values Only

Step 2 : Define Set Of Books (SOB)

Calendar : Calendar Type N > Setup > Financials > Calendars > Types
Period Type Periods Per Year Year Type
Calendar

Description
One Year Calendar with an adjusting period.

ABC Corp Period

13

Step 2 : Define Set Of Books (SOB)

Calendar : Accounting N > Setup > Financials > Calendars > Accounting
Prefix Type Year Qtr No. From To Name Adj. Period

APR MAY

ABC Corp Period ABC Corp Period

2009 2009

1 1

1 2

1-Apr-09 1-May-09

30-Apr-09 31-May-09

9-Apr 9-May

JUN
JUL AUG SEP OCT NOV DEC JAN FEB MAR

ABC Corp Period

ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period ABC Corp Period

2009
2009 2009 2009 2009 2009 2009 2010 2010 2010

1
2 2 2 3 3 3 4 4 4

3
4 5 6 7 8 9 10 11 12

1-Jun-09
1-Jul-09 1-Aug-09 1-Sep-09 1-Oct-09 1-Nov-09 1-Dec-09 1-Jan-10 1-Feb-10 1-Mar-10

30-Jun-09
31-Jul-09 31-Aug-09 30-Sep-09 31-Oct-09 30-Nov-09 31-Dec-09 31-Jan-10 28-Feb-10 31-Mar-10

9-Jun
9-Jul 9-Aug 9-Sep 9-Oct 9-Nov 9-Dec 10-Jan 10-Feb 10-Mar

ADJ

ABC Corp Period

2010

13

31-Mar-10

31-Mar-10

ADJ-10

Enable

Step 2 : Define Set Of Books (SOB)

Calendar : Accounting N > Setup > Financials > Calendars > Accounting - Save

Step 2 : Define Set Of Books (SOB)

Calendar : Check the concurrent requests N > view > request > Find

Step 2 : Define Set Of Books (SOB)

Currency: Define Currency N > Setup > Currencies > Define Enable the Currency by Checking the Check box