Search Results xle_etb_profiles




Overview
Explore in AI Chat

Overview

XLE_ETB_PROFILES is a table in the XLE schema (Legal Entity Configurator module) within Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores the general information that identifies a party (HZ_PARTIES) with the classification of Establishment. The table therefore acts as the profile repository through which an EBS establishment — the registered organizational unit associated with a legal entity — is registered, classified, and made available to downstream legal entity and transaction processing functions.

Under the heuristic Data Vault classification mined from the foreign-key structure, XLE_ETB_PROFILES is modeled as a standalone object rather than a strict hub, link, or satellite. The practical implication is that the table carries its own business identifier (ESTABLISHMENT_ID) while also holding descriptive and qualifying attributes, so it functions as a combined entity-plus-attribute store rather than being normalized into separate hub and satellite structures. It is populated and maintained through the Legal Entity Configurator user interface and related APIs rather than through direct DML.

Key Information Stored

The documented physical schema for release 12.2.2 shows 61 columns. The most significant are:

Note that ESTABLISHMENT_ID is documented as the unique key; the metadata does not document a separate surrogate primary-key column distinct from it.

Common Use Cases and Queries

The table is most frequently queried when reconciling legal entity and establishment hierarchies, when reporting establishment-level statutory data, or when tracing which party and legal entity an establishment belongs to. A representative join pattern is:

  • Join XLE_ETB_PROFILES to HZ_PARTIES on PARTY_ID to retrieve party name, party number, and party classification.
  • Join XLE_ETB_PROFILES to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to report the parent legal entity and its registration details.
  • Join XLE_ETB_PROFILES to PER_ESTABLISHMENTS on ESTABLISHMENT_ID to obtain the HR-style establishment definition used by payroll and organization reporting.

Typical filters include MAIN_ESTABLISHMENT_FLAG for identifying the primary establishment, EFFECTIVE_FROM/EFFECTIVE_TO for point-in-time reporting, and TYPE_OF_COMPANY, ACTIVITY_CODE, or SUB_ACTIVITY_CODE for classification-based extracts. Because the table is maintained through the Legal Entity Configurator, reporting queries should be treated as read-only and should account for effective dating and the ETB_INFORMATION flexfield context when decoding references.

Related Objects

The following objects are most significant in relation to XLE_ETB_PROFILES:

  • PER_ESTABLISHMENTS — referenced by XLE_ETB_PROFILES.ESTABLISHMENT_ID; supplies the establishment definition and its unique key.
  • FV_LEGAL_ENTITIES — referenced by XLE_ETB_PROFILES.LEGAL_ENTITY_ID; the owning legal entity.
  • HZ_PARTIES — the party that receives the Establishment classification, joined through PARTY_ID.
  • XLE_ETB_PROFILES_U1 — the unique index on ESTABLISHMENT_ID that enforces the business-key constraint.
  • HZ_PARTY_SITES and HZ_LOCATIONS — frequently joined through GEOGRAPHY_ID or party relationships to resolve establishment addresses.
  • XLE_ENTITY_PROFILES — the related legal-entity profile table in the same module, used alongside this table when reporting full legal entity structure.
  • XLE API layer (Legal Entity Configurator APIs) — the supported programmatic path for creating and updating establishment profiles rather than direct table inserts.