IF you are in hurry to find out the legal entity (LE) details, query is:
select LEGAL_ENTITY_ID, LEGAL_ENTITY_IDENTIFIER, NAME
from xle_entity_profiles
In case you need to find the relationship of LE with other objects in Fusion, try out these posts.
Fusion LoV Queries: LE, Business Unit, Inventory, Sub Inventory
Business Unit – LE – Ledger/ set of Books Relationship Query
But if got a moment, let me give you some background. At a high level, this is how the enterprise structure looks like in Fusion:
As you can see that every enterprise can have multiple legal entities. And then each LE can have multiple Business Units attached. so if you need to find the legal entity of the Business Unit, here is your query:
select legEnt.name LE_NAME, hou.name BU_Name
from
xle_entity_profiles legEnt ,
hr_operating_units hou
where 1=1
and hou.DEFAULT_LEGAL_CONTEXT_ID(+) = legEnt.LEGAL_ENTITY_ID
As you can see an outer join has been used, means a LE can live without having a BU attached to it.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Related posts:
Fusion LoV Queries: LE, Business Unit, Inventory, Sub Inventory
Business Unit – Legal Entity – Ledger/ set of Books Relationship Query
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com