Hi,
Can anyone explain wat are hierarchy in Multi Org Structure?
Multi Org
-
kishanbussa
- Posts: 9
- Joined: Thu Jul 12, 2007 12:58 pm
- Location: India
-
amit_gupta
- Posts: 29
- Joined: Mon Jan 08, 2007 12:54 am
- Location: India
Hi,
I here by enclosed the complete structure of Multiorg do let me know if u have any issues
Multiple Organizations
Multiple organizations and their relationships are defined in a single installation of Oracle Applications. Multiple organizations can be characterized as:
1. Set of books
2. Business groups
3. Legal entities
4. Balancing entities
5. Operating units
6. Inventory organizations
Two Model Types
~~~~~~~~~~~~~~~
Human Resources Organization Model:
Multilevel organization hierarchies that are headed by a business group at the top of the hierarchy.
Accounting / Distribution / Materials Management Organization Model:
A multilevel company structure defining relationships among
* Sets of books -- financial reporting entity that uses a particular chart
of accounts, functions currency, and accounting calendar.
* Legal entities -- legal entities post to a set of book.
* Operating units -- operating units are part of a legal entity.
* Inventory organizations -- inventory organizations re part of an operating unit. They determine items available to order entry and purchasing.
Multi-org Setup
~~~~~~~~~~~~~~~
1. Define Organization Structure.
* This is a pen and paper process of setting up the organizations structure.
* Assign organization classification in the following order:
(1) legal entities, (2) operating units, and (3) inventory organizations.
2. Define Sets of Books.
* Use Define Set of Books window to enter a set of books.
* Responsibilities used to assign sets of books:
- Assets - Setup -> Financials -> General Ledger -> Set of Books
- General Ledger - Setup -> Set of Books -> Define
- Inventory - Setup -> Financials -> Books
- Payables - Setup -> Set of Books -> Define
- Purchasing Receivables - Setup -> Organizations -> Set of Books
- Receivables - Set Up -> Financials -> Books
- Government General Ledger - Setup -> Set of Books -> Define
3. Define Organizations.
* Use Define Organizations window to define organizations.
* Responsibilities used to assign organizations:
- Inventory - Setup -> Organizations -> Organizations
- Purchasing - Setup -> Organizations -> Organizations
- Order Entry / Shipping - Set Up -> Organizations -> Organization
- Projects - Setup > Human Resources -> Organizations -> Define
- Receivables - Set Up > System -> Organization
- Government Purchasing - Setup -> Organizations -> Organizations
- Government Receivables - Set Up -> System -> Organization
* Define Business Groups. (Optional)
- Define if you have multiple business groups or do not use default
business group.
- You must have at least one business group. Oracle Applications
supplies default business group, Setup business Group (fresh install).
- If you define business group next step must be to associate business
groups with a responsibility and verify the HR:Business Group profile
option. (See step 5.)
4. Define Organization Relationships.
* Use the Define Organization window to define organization relationships
by assigning classifications to each organization.
- Classification of an organization can be any combination in the
following order: (1) legal entities, (2) operating units, and
(3) inventory organizations.
- Legal entities must have a location specified.
(Zoom to Define Locations window.)
- A concurrent program automatically replicates seed data for each new
organization.
5. Define Responsibilities.
* Use the Define Responsibility window to define responsibilities for each
operating unit.
* Responsibilities used to assign responsibilities:
- System Administrator - Security -> Responsibility -> Define
* If you have multiple business group, you must associate each
responsibility with one and only one business group.
- Use the HR:Business Group system profile option to associate a
responsibility with a business group.
6. Set MO:Operating Unit Profile Option for Each Responsibility.
* MO:Operating Unit profile option must be set.
- System Administrator - Profile -> System
- Set profile option to appropriate operating unit id (ORG_ID).
* You must set the default operating unit setting MO:Operating Unit at the
site level.
7. Run Convert to Multiple Organization using Adadmin utility.
* Process replicates seed data to all operating units that have been
defined.
* This step is irreversible.
* Adadmin will fail if previous steps have not been completed.
* Concurrent managers must be down and no one should access the database.
* If adadmin fails during conversion and you are prompted to proceed as
if successful, never select Yes, as the conversion process has
already begun, and steps that may be missed during the conversion
process will need to be manually created and be difficult, costly and
timely to recreate.
8. Define Inventory Organization Security (Optional).
* Restricts manufacturing users to specific organizations.
9. Change Order Entry Profile Options (Optional).
* OE:Item Validation Organization profile option is set a responsibility
level if operating units have different item validation organizations.
10. Update Profile Options Specific to Operating Units.
* Set profile options at the responsibility level e.g.:
- AR:Receippt Batch Source
- AR:Transaction Batch Source
- OE:Item Validation Organization
- OE:Set of Books
- GL:Set of Books Sequential Numbering
* Responsibilities used to assign profile options:
System Administrator - Profile -> System.
* Refer to individual Oracle Financial Applications Products User's Guides
for specific information on profile options that need to be set.
11. Set up Oracle Applications Products.
* OE, PA, PO, AR and Sales Compensation must be set up for each operating
unit it they the product groups are to be used.
* FA, GL INV and the rest of the Oracle Manufacturing product do not need
to be set up for each operating unit.
12. Secure Balancing Segment Values by Legal Entity. (Optional)
* Use the Define Security Rule window to create rules that secure data
entry of balancing segment values for each legal entity.
- Security rule elements specify a range of values to be included or
excluded.
* Use the Assign Security Rules window to assign the same rule(s) to all
responsibilities associated with the legal entity's operating units.
* Define additional rules and assign them to all responsibilities associated
with relevant operating units.
13. Run the Setup Validation Report to Identify Setup Problems.
* Data for disabled fields on Enter Customer and Enter Supplier Window must
be deleted.
- Header information is shared across operating units and if you do not
choose to delete the data, you must edit the database manually.
* All responsibilities in one operating unit must share the same profile
option values and sequence numbering option.
Definitions
~~~~~~~~~~~
Set of Books:
-------------
A financial reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Oracle General Ledger secures transaction information (journal entries, balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
Operating Unit:
---------------
An organization that uses Order Entry, Oracle Payables, Oracle Purchasing, or Oracle Receivables. It may be a sales office, a division, or a department. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications; each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
Multi-Org Partitioned Objects:
------------------------------
Tables that contain Multi-Org data have the suffix _ALL in the table name.
These tables include a column called ORG_ID that partitions Multi-Org data by organization.
Every Multi-Org table has a corresponding view that partitions the table's data by operating unit. Multi-Org views partition data by including a DECODE of an RDBMS function called CLIENT_INFO. CLIENT_INFO is similar in operation to the function LANGUAGE, which returns the language of the current session, and is set by the security system to the operating unit designated for the responsibility.
SO_HEADERS_ALL,with its corresponding view SO_HEADERS, are examples of Multi-Org partitioned objects. For a complete list refer to the Multiple Organizations in Oracle Applications manual.
I here by enclosed the complete structure of Multiorg do let me know if u have any issues
Multiple Organizations
Multiple organizations and their relationships are defined in a single installation of Oracle Applications. Multiple organizations can be characterized as:
1. Set of books
2. Business groups
3. Legal entities
4. Balancing entities
5. Operating units
6. Inventory organizations
Two Model Types
~~~~~~~~~~~~~~~
Human Resources Organization Model:
Multilevel organization hierarchies that are headed by a business group at the top of the hierarchy.
Accounting / Distribution / Materials Management Organization Model:
A multilevel company structure defining relationships among
* Sets of books -- financial reporting entity that uses a particular chart
of accounts, functions currency, and accounting calendar.
* Legal entities -- legal entities post to a set of book.
* Operating units -- operating units are part of a legal entity.
* Inventory organizations -- inventory organizations re part of an operating unit. They determine items available to order entry and purchasing.
Multi-org Setup
~~~~~~~~~~~~~~~
1. Define Organization Structure.
* This is a pen and paper process of setting up the organizations structure.
* Assign organization classification in the following order:
(1) legal entities, (2) operating units, and (3) inventory organizations.
2. Define Sets of Books.
* Use Define Set of Books window to enter a set of books.
* Responsibilities used to assign sets of books:
- Assets - Setup -> Financials -> General Ledger -> Set of Books
- General Ledger - Setup -> Set of Books -> Define
- Inventory - Setup -> Financials -> Books
- Payables - Setup -> Set of Books -> Define
- Purchasing Receivables - Setup -> Organizations -> Set of Books
- Receivables - Set Up -> Financials -> Books
- Government General Ledger - Setup -> Set of Books -> Define
3. Define Organizations.
* Use Define Organizations window to define organizations.
* Responsibilities used to assign organizations:
- Inventory - Setup -> Organizations -> Organizations
- Purchasing - Setup -> Organizations -> Organizations
- Order Entry / Shipping - Set Up -> Organizations -> Organization
- Projects - Setup > Human Resources -> Organizations -> Define
- Receivables - Set Up > System -> Organization
- Government Purchasing - Setup -> Organizations -> Organizations
- Government Receivables - Set Up -> System -> Organization
* Define Business Groups. (Optional)
- Define if you have multiple business groups or do not use default
business group.
- You must have at least one business group. Oracle Applications
supplies default business group, Setup business Group (fresh install).
- If you define business group next step must be to associate business
groups with a responsibility and verify the HR:Business Group profile
option. (See step 5.)
4. Define Organization Relationships.
* Use the Define Organization window to define organization relationships
by assigning classifications to each organization.
- Classification of an organization can be any combination in the
following order: (1) legal entities, (2) operating units, and
(3) inventory organizations.
- Legal entities must have a location specified.
(Zoom to Define Locations window.)
- A concurrent program automatically replicates seed data for each new
organization.
5. Define Responsibilities.
* Use the Define Responsibility window to define responsibilities for each
operating unit.
* Responsibilities used to assign responsibilities:
- System Administrator - Security -> Responsibility -> Define
* If you have multiple business group, you must associate each
responsibility with one and only one business group.
- Use the HR:Business Group system profile option to associate a
responsibility with a business group.
6. Set MO:Operating Unit Profile Option for Each Responsibility.
* MO:Operating Unit profile option must be set.
- System Administrator - Profile -> System
- Set profile option to appropriate operating unit id (ORG_ID).
* You must set the default operating unit setting MO:Operating Unit at the
site level.
7. Run Convert to Multiple Organization using Adadmin utility.
* Process replicates seed data to all operating units that have been
defined.
* This step is irreversible.
* Adadmin will fail if previous steps have not been completed.
* Concurrent managers must be down and no one should access the database.
* If adadmin fails during conversion and you are prompted to proceed as
if successful, never select Yes, as the conversion process has
already begun, and steps that may be missed during the conversion
process will need to be manually created and be difficult, costly and
timely to recreate.
8. Define Inventory Organization Security (Optional).
* Restricts manufacturing users to specific organizations.
9. Change Order Entry Profile Options (Optional).
* OE:Item Validation Organization profile option is set a responsibility
level if operating units have different item validation organizations.
10. Update Profile Options Specific to Operating Units.
* Set profile options at the responsibility level e.g.:
- AR:Receippt Batch Source
- AR:Transaction Batch Source
- OE:Item Validation Organization
- OE:Set of Books
- GL:Set of Books Sequential Numbering
* Responsibilities used to assign profile options:
System Administrator - Profile -> System.
* Refer to individual Oracle Financial Applications Products User's Guides
for specific information on profile options that need to be set.
11. Set up Oracle Applications Products.
* OE, PA, PO, AR and Sales Compensation must be set up for each operating
unit it they the product groups are to be used.
* FA, GL INV and the rest of the Oracle Manufacturing product do not need
to be set up for each operating unit.
12. Secure Balancing Segment Values by Legal Entity. (Optional)
* Use the Define Security Rule window to create rules that secure data
entry of balancing segment values for each legal entity.
- Security rule elements specify a range of values to be included or
excluded.
* Use the Assign Security Rules window to assign the same rule(s) to all
responsibilities associated with the legal entity's operating units.
* Define additional rules and assign them to all responsibilities associated
with relevant operating units.
13. Run the Setup Validation Report to Identify Setup Problems.
* Data for disabled fields on Enter Customer and Enter Supplier Window must
be deleted.
- Header information is shared across operating units and if you do not
choose to delete the data, you must edit the database manually.
* All responsibilities in one operating unit must share the same profile
option values and sequence numbering option.
Definitions
~~~~~~~~~~~
Set of Books:
-------------
A financial reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Oracle General Ledger secures transaction information (journal entries, balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
Operating Unit:
---------------
An organization that uses Order Entry, Oracle Payables, Oracle Purchasing, or Oracle Receivables. It may be a sales office, a division, or a department. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications; each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
Multi-Org Partitioned Objects:
------------------------------
Tables that contain Multi-Org data have the suffix _ALL in the table name.
These tables include a column called ORG_ID that partitions Multi-Org data by organization.
Every Multi-Org table has a corresponding view that partitions the table's data by operating unit. Multi-Org views partition data by including a DECODE of an RDBMS function called CLIENT_INFO. CLIENT_INFO is similar in operation to the function LANGUAGE, which returns the language of the current session, and is set by the security system to the operating unit designated for the responsibility.
SO_HEADERS_ALL,with its corresponding view SO_HEADERS, are examples of Multi-Org partitioned objects. For a complete list refer to the Multiple Organizations in Oracle Applications manual.
-
panand-apps
- Posts: 3
- Joined: Sat Oct 18, 2008 11:10 am
- Location: India
Who is online
Users browsing this forum: Ahrefs [Bot] and 19 guests