_____________________________________________________
Overview of Multiorg
_____________________________________________________
1. Need for Multiorg.
2. Parts of Multiorg.
3. Steps in defining the Multiorg.
4. Technical Impact of Multiorg.
5. Applications Secured by Diff Organization.
_____________________________________________________
1.Need for Multiorg
_____________________________________________________
/>In a single installation of Oracle Application product can support any number of organizations.
/>Secure access to data so that users can access only the information that is relevant to them.
/>Sell product from a legal entity that uses one set of books and ship them from another legal entity using a different set of books, and automatically record the appropriate inter company accounts payable and accounts receivable invoices
/>Support any number of legal entities within a single installation of Oracle Applications
_____________________________________________________
2.Parts of Multiorg
_____________________________________________________
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 (such as journal entries and 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 .
Business Group:
The business group represents the highest level in the organization structure, such as the consolidated enterprise, a major division, or an operation company. The business group secures human resources information. For example, when you request a list of employees, you see all employees assigned to the business group of which your organization is a part.
Legal Entity:
A legal company for which you prepare fiscal or tax reports. You assign tax identifies and other legal entity information to this type of organization.
Operating Unit:
An organization that uses Oracle Cash Management, Order Management and Shipping Executing, Oracle Payables, Oracle Purchasing, and 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.
Inventory Organizations
An Organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products
The following applications secure information by inventory organization: oracle inventory, bill of material, engineering, work in process, master scheduling/MRP, capacity, purchasing receiving functions.
______________________________________________________
3.Steps in defining the Multiorg
______________________________________________________
Step-1 Define Location
Step-2 Define New Business Group and add Location
Step-3 Add Business group to HR Security profile,MO security profile option at responsibility level and HR User type as HR user or payroll.
Step-4 Define New Set of books and add it to GL Sets of Books Name profile option at set of books level.
Step-5 Define Legal entity and add it to Sets of Books
Step-6 Define Operating Unit and add it to Legal entity
Step-7 Define workday calendar in Inventory
Step-7 Add the operating unit to MO Security profile at responsibity level.
Step-8 Define workday calendar.
Step-9 Run Replicate seed data Concurrent Program by giving operating unit name as parameter.
You can define Multi Org from Purchasing, Inventory and HRMS responsibilities.
One Parent organization can have multiple child organizations
______________________________________________________
4.Technical Impact of Multiorg
______________________________________________________
Table of Multiorg Setup
Business Group data will store in HR_ORGANIZATION_UNITS
Legal Entity data will store in HR_LEGAL_ENTITIES
Operating Unit data will store in HR_OPERATING_UNITS
Inventory data will store in MTL_PARAMETERS
Relations ships between this organizations are stored in will store in ORG_ORGANIZATION_DEFINITIONS
Design of Views and Table:
Multiple organizations in oracle applications is enabled by partitioning some database tables by operating unit . Other tables shared across operating units ( and thus across sets of books).
In the base tables all org will be stored but it is divided using specific column based on the organization. Each sob data is divided by sob_id , operating unit by org_id and inventory organization data by organization id.
All Operating specific tables end with ALL at the end of the table.
In oracle applications, data partitioning is performed by database views. These views reside in the apps oracle schema and drive the appropriate operating unit. Context form an RDBMS variable.
RDBMS Variable:
A global variable exits in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes used to store the operating unit id ( or org-id)for the multiple organization support feature. The client-info context is derived from a profile option that the user sets for each responsibility as part of the multi-org setup steps.
All Multiorg views are partitioned by org_id and org_id value will be stored in for CLIENT _INFO variable. It will in be initialized form profile option when run for applications.
When you query Multi org view from database it will not give any data because org_id will not be initialized we have to explicitly initialize it.
Example – Select * from PO_HEADERS_ALL
it will give all organizations po details.
Example – Select * from PO_HEADERS
will give specific po details for initialized org
Setting Up Client Info:
Begin
Fnd_Client_info.SetUp_Client_Info(resp_appl_id, resp_id, user_id, security_group_id) ;
End;
Setting Up Organization Context:
Begin
Fnd_Client_info.Set_Org_Context(org_id) ;
End;
___________________________________________________
5.Applications Secured by Diff Organization
___________________________________________________
Set Of Books:
General Ledger
Operating Unit:
Payables
Receivables
Project Accounting
Inventory Origination:
Inventory
BOM
WIP
_____________________________________________________
1. Need for Multiorg.
2. Parts of Multiorg.
3. Steps in defining the Multiorg.
4. Technical Impact of Multiorg.
5. Applications Secured by Diff Organization.
_____________________________________________________
1.Need for Multiorg
_____________________________________________________
/>In a single installation of Oracle Application product can support any number of organizations.
/>Secure access to data so that users can access only the information that is relevant to them.
/>Sell product from a legal entity that uses one set of books and ship them from another legal entity using a different set of books, and automatically record the appropriate inter company accounts payable and accounts receivable invoices
/>Support any number of legal entities within a single installation of Oracle Applications
_____________________________________________________
2.Parts of Multiorg
_____________________________________________________
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 (such as journal entries and 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 .
Business Group:
The business group represents the highest level in the organization structure, such as the consolidated enterprise, a major division, or an operation company. The business group secures human resources information. For example, when you request a list of employees, you see all employees assigned to the business group of which your organization is a part.
Legal Entity:
A legal company for which you prepare fiscal or tax reports. You assign tax identifies and other legal entity information to this type of organization.
Operating Unit:
An organization that uses Oracle Cash Management, Order Management and Shipping Executing, Oracle Payables, Oracle Purchasing, and 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.
Inventory Organizations
An Organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products
The following applications secure information by inventory organization: oracle inventory, bill of material, engineering, work in process, master scheduling/MRP, capacity, purchasing receiving functions.
______________________________________________________
3.Steps in defining the Multiorg
______________________________________________________
Step-1 Define Location
Step-2 Define New Business Group and add Location
Step-3 Add Business group to HR Security profile,MO security profile option at responsibility level and HR User type as HR user or payroll.
Step-4 Define New Set of books and add it to GL Sets of Books Name profile option at set of books level.
Step-5 Define Legal entity and add it to Sets of Books
Step-6 Define Operating Unit and add it to Legal entity
Step-7 Define workday calendar in Inventory
Step-7 Add the operating unit to MO Security profile at responsibity level.
Step-8 Define workday calendar.
Step-9 Run Replicate seed data Concurrent Program by giving operating unit name as parameter.
You can define Multi Org from Purchasing, Inventory and HRMS responsibilities.
One Parent organization can have multiple child organizations
______________________________________________________
4.Technical Impact of Multiorg
______________________________________________________
Table of Multiorg Setup
Business Group data will store in HR_ORGANIZATION_UNITS
Legal Entity data will store in HR_LEGAL_ENTITIES
Operating Unit data will store in HR_OPERATING_UNITS
Inventory data will store in MTL_PARAMETERS
Relations ships between this organizations are stored in will store in ORG_ORGANIZATION_DEFINITIONS
Design of Views and Table:
Multiple organizations in oracle applications is enabled by partitioning some database tables by operating unit . Other tables shared across operating units ( and thus across sets of books).
In the base tables all org will be stored but it is divided using specific column based on the organization. Each sob data is divided by sob_id , operating unit by org_id and inventory organization data by organization id.
All Operating specific tables end with ALL at the end of the table.
In oracle applications, data partitioning is performed by database views. These views reside in the apps oracle schema and drive the appropriate operating unit. Context form an RDBMS variable.
RDBMS Variable:
A global variable exits in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes used to store the operating unit id ( or org-id)for the multiple organization support feature. The client-info context is derived from a profile option that the user sets for each responsibility as part of the multi-org setup steps.
All Multiorg views are partitioned by org_id and org_id value will be stored in for CLIENT _INFO variable. It will in be initialized form profile option when run for applications.
When you query Multi org view from database it will not give any data because org_id will not be initialized we have to explicitly initialize it.
Example – Select * from PO_HEADERS_ALL
it will give all organizations po details.
Example – Select * from PO_HEADERS
will give specific po details for initialized org
Setting Up Client Info:
Begin
Fnd_Client_info.SetUp_Client_Info(resp_appl_id, resp_id, user_id, security_group_id) ;
End;
Setting Up Organization Context:
Begin
Fnd_Client_info.Set_Org_Context(org_id) ;
End;
___________________________________________________
5.Applications Secured by Diff Organization
___________________________________________________
Set Of Books:
General Ledger
Operating Unit:
Payables
Receivables
Project Accounting
Inventory Origination:
Inventory
BOM
WIP
No comments:
Post a Comment