Quick answer to get the relationship of Business Unit – Legal Entity – COA (Charts Of Accounts) Relationship:
select hou.name BU_NAME, hou.SHORT_CODE , le.NAME Legal_ENtity, led.NAME Ledger_Name
from hr_operating_units hou,
xla_gl_ledgers led,
Xle_entity_profiles le
where hou.default_legal_context_id = le.legal_entity_id
and led.ledger_id = hou.set_of_books_id
To get into a bit of details: every Business Unit is attached to a legal entity and a ledger. Ledger in other terms is also called “set of books”. Every ledger here has a unique Charts Of Accounts. This charts of accounts is nothing but a structure of accounts ( like 7 segment structure).
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...
Posts related to Business Unit – Legal Entity – COA ( Charts Of Accounts) Relationship:
Fusion LoV Queries: Legal Entity, Business Unit, Inventory, Sub Inventory
Legal Entity Query in Fusion
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