Enterprises
An enterprise is a collection of legal entities sharing common control and management.Division
A business-oriented subdivision within an enterprise. Each division is organized to deliver products and services or address different markets.
Legal entity
An entity identified and given rights and responsibilities by commercial law through the registration with country's appropriate authority.
Business unit (Operating Unit in R12)
A unit of an enterprise that performs one or many business functions that can be rolled up in a management hierarchy.
Department (Inventory Organization in R12)
A division of a business enterprise dealing with a particular area of activity.
Tables
The Business Unit ID(BU ID) is stored in HR_ALL_ORGANIZATION_UNITS_F
and HR_ORGANIZATION_UNITS_F_TL table.
-HR_ALL_ORGANIZATION_UNITS_F: the primary table which holds all the organization IDs
-HR_ORGANIZATION_UNITS_F_TL: organization
Translation Table
You can query The Business Unit ID(BU ID) by following SQL query
Note:Update '&BU_NAME' to your Business Unit name.
(SQL)
select
hao.organization_id as bu_id,haot.name,hao.business_group_id
FROM
HR_ALL_ORGANIZATION_UNITS_F hao,
HR_ORGANIZATION_UNITS_F_TL haot
WHERE
hao.ORGANIZATION_ID = haot.ORGANIZATION_ID
AND hao.EFFECTIVE_START_DATE = haot.EFFECTIVE_START_DATE
AND hao.EFFECTIVE_END_DATE = haot.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN hao.EFFECTIVE_START_DATE AND hao.EFFECTIVE_END_DATE
AND haot.LANGUAGE='US'
AND haot.name like '&BU_NAME%'
Reference:
Fusion Global HR: The Table Name Where The Business Unit ID Is Stored (Doc ID 2155284.1)
Link: https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=103358566438068&id=2155284.1&_afrWindowMode=0&_adf.ctrl-state=32wybozs7_53
0 Comments