Use a single installation of any Oracle Applications product to support any number of organizations, even if those organizations use different sets of books.
BusinessGroup (HRMS=>Workstructure=>Organization=Description)
Set of Books (GL=>Setup=>Financials=>Books=>Define)
Legal Entity
Operating Unit
Inventory Organization
Sub Inventory (Inventory=.Setup=>organizations=>SubInventories)
Stock Locations (Inventory=.Setup=>organizations=>Stock locatiors)
Items
Major Features
===============
1)Multiple Organizations in a Single Installation
2)Secure Access You can assign users to particular organizations.
This ensures accurate transactions in the correct operating unit.
3)Multiple Organizations Reporting You can set up your Oracle Applications implementation to allow reporting across operating units by setting up the top reporting level.
You can run your reports at the set of books level, legal entity level, or operating unit level
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.
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.
Legal Entity:
=============
A legal company for which you prepare fiscal or tax reports.
You assign tax identifiers and other legal entity information to this type of organization.
Operating unit:
===============
An organization that uses Oracle Cash Management, Order Management and Shipping Execution, 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.
Inventory Organization:
=======================
An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products.
Examples include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices.
The following applications secure information by inventory organization: Oracle Inventory, Bills of Material, Engineering, Work in Process,
Master Scheduling/MRP, Capacity, and Purchasing receiving functions.
Subinventory:
=============
Which is another organization inside of the Inventory oganization will be used to define the locations under these location items will be placed.
Multiorg Table:
===============
It is a table contains the data which is relted to multiple operating units all the multiorg table names will be end with '_ALL'. like PO_HEADER_ALL PO_LINES_ALL
AP_CHECKS_ALL and so on
Note: In all these tables we will find one common column called "ORG_ID" This column will be populated internally by the system as per the User Operating Unit ID
Client_Info:
===========
It is one the RDBMS vaiabel which contains the User Operating Unit value (ORG_ID)
Multiorg View:
=================
It is a view which is created based on the Multiorg table which contains the WHERE clause WHERE Org_ID = :Client_Info.
Note: While development of RICE Components we are suppose to Use Multiorg Views not Multi Org Tables. Because if we use
Multiorg tables we will get all the operating units data if we use multiorg view we will get the operating units data which is related for that perticular user .
1)What is the Diff between ORG_ID and ORGANIZATION_ID?
Ans)ORG_ID is at Operating Unit Level ORGANIZATION_ID is at Inventory Organization
level
No comments:
Post a Comment