Select legEnt.name LE_NAME, hou.name BU_Name fromxle_entity_profiles legEnt, hr_operating_units houwhere 1=1and hou. DEFAULT_LEGAL_CONTEXT_ID(+) = legEnt.LEGAL_ENTITY_ID Oracle Apps R12 and Oracle Fusion Cloud eLearning videos published on Udemy with live meeting support. Please check www.oracleappstechnical.com As you can see, each company can have multiple legal entities. Then, multiple business units can be assigned to each LE. So, if you need to find the legal entity of the business unit, here is your request: If you are in a hurry to know the details of the legal entity (LE), the query is: Select LEGAL_ENTITY_ID, LEGAL_ENTITY_IDENTIFIER, NAME, xle_entity_profiles We`re sorry this article wasn`t helpful to you! Comments: I hope the article helped you. If yes, please rate the position. If not, leave a comment to let us know what we missed. By the way, here (India) or here (other geographies) are some unconventional tricks I`ve learned to improve BI report performance. Try them only if nothing else works.
a kind of SOS. Good blog, well derived, Thank you for sharing this information. Oracle Fusion HCM Online If you need to find the relationship of LE with other objects in Fusion, try these articles. LoV Fusion queries: LE, Business Unit, Inventory, SubinventoryBusiness Unit – LE – General Ledger/Set of Books Relationship Query But if you have a moment, let me give you some context. At a high level, Fusion`s business structure looks like this: ###We are looking for Oracle application professionals with 4-10 years of experience in PL-SQL, Workflow, OAF and XML Publisher, preferably in P2P modules for Gurugram, India. If you think you are meeting the bill, click here As you can see, an external connection has been used, which means that an LE can live without a BU attached to it.