| layout | default |
|---|---|
| title | XLE Legal Entities | Oracle EBS SQL Report |
| description | Legal entities, establishments, jurisdictions and registrations – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, XLE, Legal, Entities, xle_entity_profiles, xle_etb_profiles, hz_parties |
| permalink | /XLE%20Legal%20Entities/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Legal entities, establishments, jurisdictions and registrations
Jurisdiction Country, Legal Entity Name
xle_entity_profiles, xle_etb_profiles, hz_parties, xle_registrations, xle_jurisdictions_vl, hz_geographies, fnd_lookup_values_vl, hr_locations_all, fnd_territories_vl, hz_party_sites, hz_locations
ZX Party Tax Profiles, AR European Sales Listing, IBY Payment Process Request Details, CE Cleared Transactions, AR Customer Upload
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | XLE Legal Entities 24-Jul-2017 145303.xlsx |
| Blitz Report™ XML Import | XLE_Legal_Entities.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/xle-legal-entities/ |
The XLE Legal Entities report is a crucial master data and configuration audit tool for Oracle Legal Entity Configurator (XLE). It provides a comprehensive listing of all defined legal entities and their associated establishments, jurisdictions, and registrations within Oracle E-Business Suite. This report is indispensable for finance managers, legal teams, system administrators, and auditors to understand the core legal structure of an enterprise, ensure compliance with statutory and regulatory requirements, and maintain accurate records for financial reporting, tax management, and multi-organizational operations.
For global organizations, correctly defining and managing legal entities and their various registrations is fundamental for statutory compliance, financial reporting, and tax management. This presents several challenges:
- Complex Legal Structures: Managing a multitude of legal entities, each with its own establishments, jurisdictions, and registrations across different countries and regulatory environments, is inherently complex.
- Ensuring Statutory Compliance: Non-compliance with local legal entity registration requirements or jurisdictional rules can lead to significant penalties, fines, and legal issues. A consolidated view is essential for auditing this compliance.
- Fragmented Information: Details about legal entities, their physical establishments, the jurisdictions they operate in, and their specific registrations (e.g., tax IDs, company registration numbers) are often scattered across various forms in Oracle EBS.
- Impact on Financial Reporting: Legal entities are the foundation for financial consolidation and statutory reporting. Errors in their setup or their associated registrations can lead to incorrect financial statements and audit findings.
- Audit and Documentation: Maintaining accurate and up-to-date documentation of all legal entities and their complete legal footprint is a critical but often manual and laborious task for internal and external audits.
This report offers a powerful, consolidated, and auditable solution for analyzing legal entities and their complete legal footprint, bringing transparency and control to enterprise legal structures.
- Comprehensive Legal Entity Overview: It presents a detailed list of all
Legal Entities, their associatedEstablishments, theJurisdictionsin which they operate, and their keyRegistrations(e.g., tax registration numbers). This provides a holistic view of the legal structure. - Clear Compliance Audit Trail: By consolidating registration and jurisdictional information, the report empowers legal and finance teams to quickly verify compliance with local statutory requirements for each legal entity and establishment.
- Streamlined Configuration Audit: System administrators and auditors can use this report to quickly review and verify the setup of legal entities, ensuring they are correctly defined and linked to the relevant geographical and regulatory contexts.
- Enhanced Documentation: The report serves as a live, accurate source of documentation for the enterprise's legal structure, invaluable for system maintenance, global expansion projects, and demonstrating compliance during audits.
The report queries core Oracle Legal Entity Configurator (XLE) tables, integrating data from various related modules for comprehensive legal entity details.
- Primary Tables Involved:
xle_entity_profiles(the central table for defining legal entities).xle_etb_profiles(for establishments associated with legal entities).xle_registrations(for legal registrations like tax IDs).xle_jurisdictions_vl(for definitions of legal jurisdictions).hz_parties(for party information associated with legal entities).hz_geographies,fnd_territories_vl,hr_locations_all,hz_party_sites,hz_locations(for geographical and location context).
- Logical Relationships: The report selects legal entities from
xle_entity_profiles. It then performs joins toxle_etb_profilesto retrieve establishment details, toxle_registrationsfor all associated legal registrations, and toxle_jurisdictions_vlto identify the geographical and regulatory contexts in which the entity operates. Further joins to HR and CRM tables (hz_parties,hz_locations) enrich the output with detailed name and address information.
The report offers flexible parameters for targeted analysis of legal entities:
- Jurisdiction Country: Allows users to filter the report to legal entities operating within a specific country, which is useful for regional compliance audits.
- Legal Entity Name: Enables users to focus on a specific legal entity for detailed review of its establishments, jurisdictions, and registrations.
As a master data and configuration report, it is optimized for efficient retrieval of setup data.
- Low Data Volume: The underlying tables (
xle_entity_profiles,xle_etb_profiles,xle_registrations,xle_jurisdictions_vl) contain configuration data, which is typically a much smaller volume than transactional data, ensuring fast query execution. - Indexed Joins: The queries leverage standard Oracle indexes on
legal_entity_id,establishment_id,jurisdiction_id, andcountryfor efficient data retrieval across the various XLE and related tables.
1. What is the difference between an 'Legal Entity' and an 'Establishment' in this report? A 'Legal Entity' is the top-level legal organization. An 'Establishment' is a subdivision of a legal entity (e.g., a physical office, a branch). An establishment can be registered with a legal authority (e.g., for VAT or income tax) and is associated with a legal entity. This report shows both, providing a complete picture of your legal structure.
2. How does this report help ensure tax compliance for multi-national organizations?
By detailing the Jurisdictions and Registrations (including tax registration numbers) for each legal entity and establishment, the report provides a crucial audit trail. Tax managers can use it to verify that all entities are correctly registered in the countries where they operate and that the appropriate tax identifiers are recorded.
3. Can this report also show the operating units or inventory organizations associated with each legal entity?
This report focuses specifically on the legal entity and its direct establishments/registrations. For a view that links legal entities to their associated operating units and inventory organizations, you would typically use the related XLE Establishment and Legal Entity Associations report, which provides that specific level of detail.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics