Friends, do share your feedback on this topic :-
We can host multiple Oracle eBusiness suites on one Instance separated by security group. This is primarily aimed for Application service providers who host and maintain Oracle Apps for many SME clients on pay-per-use basis.
The business group represents the highest level in the organization structure. It secures human resources information. If you have multiple business groups, you must associate each responsibility to one and only one business group. You associate a business group with a responsibility via the HR:Business Group system profile option.
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.
Set the responsibility from which you define the organizations in the profile option HR: User Type to HR User, to get access to the Define Organizations window. Log in to the responsibility associated with the business group for which you are defining an organization. Define a legal entity. It is then automatically attached to the correct business group. Legal entity is 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.
An operating unit is associated with a legal entity. Information is secured by operating unit for applications viz: Order Management, Shipping Execution, Oracle Payables, Oracle Purchasing, Oracle Receivables and Oracle Cash Management. To run any of these applications, you choose a responsibility associated with an operating unit.
Inventory Organization is an organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products viz: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.
Navigate to Define Organization window. Enter a name for the organization.You can define all types of organizations viz manufacturing facility, warehouse, branch office etc. Choose a location where this organization exists.Enter what type(s) of organization is this, in organization classification viz:
GRE/Legal Entity : For a Legal Entity, click others and enter Accounting info like Set of Books.
Operating Unit : For an Operating Unit, enter Accounting Information like Legal Entity, Set of Books.
Inventory Organization : For an Inv Organization enter Accounting Information like Set of Books, Legal Entity & Operating Unit.
HR Organization : HR organizations represent the basic work structure of any enterprise. They usually represent the functional management, or reporting groups that exist within a business group. Click others and enter all such information .
ORG_INFORMATION1 ~ 20
All organizations are maintained in HR_ALL_ORGANIZATION_UNITS table and organization classifications like Legal entity or operating unit information are stored in HR_ORGANIZATION_INFORMATION table. There are 3 views provided based on these 2 tables to easily find out the Legal entity, Operating unit and Inventory organization viz:
The values in below profiles give you the desired data security as explained above. These values are set at site or responsibility level such that once you choose any responsibility, you are restricted to the data pertaining to the above profile value.
- HR:Business Group (PER_BUSINESS_GROUP_ID)- implies the business group you are currently attached with.
- MO: Operating Unit (ORG_ID)- implies your current operating unit.
where lower(name) like ‘%vision corporation%’
order by name
(select location_id from hr_all_organization_units ou
where od.organization_id=ou.organization_id) location_id,
from org_organization_definitions od
order by organization_code
The location_id found here is referenced in hr_locations table (described later), for detailed address information of this organization.