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).
Want to give back to the society? (Do you have something which you think can be used by folks working on Oracle world wide?) Then Click here, share your email id and a brief description of the topic. And keep your photo and the content ready.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports. 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