[Fusion] Understanding Legal Entities and Business Units in Oracle Fusion

🔹 What is a Legal Entity?

Think of a Legal Entity as a real, registered company.

It’s the organization that has legal rights and responsibilities.
It can enter into contracts, own assets, pay taxes, and sue or be sued.
Examples:
- "ABC Pvt Ltd" registered in India
- "XYZ Inc" registered in the USA

In Oracle Fusion, a Legal Entity is used to handle legal and statutory requirements like tax reporting, financial statements, etc.

👉 In real life: If you run a registered business, that business is your legal entity.

🔹 What is a Business Unit (BU)?

A Business Unit is like a department or branch within the legal entity that performs day-to-day operations.

It’s where business happens: sales, procurement, invoicing, etc.
It’s not a separate company, but a part of the legal entity.
You can have multiple BUs under one legal entity.

Examples:

"Sales BU – India"
"Procurement BU – USA"

In Oracle Fusion, a Business Unit helps to organize business activities like managing orders, invoices, and suppliers.

👉 In real life: If your company has a sales team, a finance team, and a purchasing team, you can set them up as separate BUs.

🔄 Relationship Between Legal Entity and Business Unit:

A Legal Entity owns one or more Business Units.
Each Business Unit works under the umbrella of a Legal Entity.
Think of the Legal Entity as the "parent company" and Business Units as its "branches".

Here’s a useful SQL query that fetches Business Units for a Legal Entity:

SELECT 
    xep.name AS LE_NAME, 
    hou.name AS BU_NAME
FROM 
    xle_entity_profiles xep,
    hr_operating_units hou
WHERE 
    hou.DEFAULT_LEGAL_CONTEXT_ID(+) = xep.LEGAL_ENTITY_ID;

XLE_ENTITY_PROFILES: This table holds the definitions of all Legal Entities in the system.

HR_OPERATING_UNITS: This table stores data about the Operating Units (or Business Units in Fusion terms).

The Cool Fox