Wednesday 6 November 2013

What is multi org?

“Legal entity has more than one operating unit is called as multi org”.
Multiorg is nothing but under single oracle application implementation maintaining multiple organizations and multiple set of books.

Multiorg Structure:


Business Groups: The business groups represent the highest level in the organization structure like major divisions etc. business group secures human resources information for example when we request a list of employees we can see the employees assign to the business groups.

Set of books: It is a financial reporting entity uses a particular chart of accounts functional currency and accounting calendar. Oracle GL secures transaction information like general entries balances by set of books. When we assign to the oracle GL responsibilities there will be a set of books assignment. We can see the information for that set of book only. The navigation in that responsibility is
Setup _ Financials _ Books _ Define.

Legal Entities: It is a legal company for which we prepare physical or tax reports. We will assign tax identifiers and other legal information.

Operating Units: It is one of the organizations where exactly company is being sales, purchasing payments and receiving and so on. It may be sales office or a division or a department. At operating unit level PO, AP, AR, OM modules will be implemented.

Inventory Organization: It is an organization where we are going to maintain manufacturing information and items information. It captures inventory transactions, balances. Oracle inventory, WIP, BOM will be implemented at inventory organization level.

Sub Inventory: Sub inventory is nothing but stocks or goudons or warehouses, which will be define under inventory organization.

Locators: Stock Locators is nothing but the specific location inside the sub inventory where we will place the item.

Note:
·         Whenever we write a statement like SELECT * FROM OE_ORDER_HEADERS then it shows “NO ROWS RETURN” as an output.
·         Whenever we are working with the Multiorg views if we want to get the data from those views we have to set the ORG_ID of which Operating unit it is belongs by using the API (FND_CLIENT_INFO.SET_ORG_CONTEXT(ORG_ID)). Then we get the required information from the view.
·         We found the list of ORG_ID’s in the HR_OPERATING_UNITS.
·         To find the system is in Multiorg or not the query is:
EX: SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS;
O/p: Y-> If it is a Multiorg system otherwise it is N.

No comments:

Post a Comment