Results for “xle_entity_profiles”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XLE_ENTITY_PROFILES is the core registration table of the Legal Entity Configurator (XLE) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the general identifying information that classifies a Party as a Legal Entity. Every legal entity defined within EBS — the organizations used as the reporting, transacting, and accounting boundaries for subledger and General Ledger processing — has a corresponding row in this table. The object is owned by the XLE schema and is documented as VALID in ETRM 12.2.2, with a physical schema of 59 columns.

In Data Vault modeling terms, the metadata classifies XLE_ENTITY_PROFILES heuristically as standalone, meaning it is not joined to other tables through inherited parent foreign keys beyond its own referencing relationships. This suggests treating the table as a hub-like anchor for the Legal Entity business key, with descriptive and audit attributes behaving as satellite-style payload. The classification is a modeling suggestion only; the table physically functions as a master reference for the Legal Entity Configurator.

Key Information Stored

The surrogate primary key is LEGAL_ENTITY_ID, enforced by the unique index XLE_ENTITY_PROFILES_U1, which is the documented business-key candidate and the primary join column used throughout the application.

• LEGAL_ENTITY_ID — Surrogate primary key and unique business-key candidate; the identifier referenced by dependent XLE and subledger tables.
• PARTY_ID — Links the legal entity to the underlying trading party in the TCA party model.
• LEGAL_ENTITY_IDENTIFIER — The user-visible identifier (short name or code) by which the legal entity is recognized.
• NAME — The display name of the legal entity.
• GEOGRAPHY_ID — The geography or jurisdiction associated with the entity, driving tax and reporting context.
• TRANSACTING_ENTITY_FLAG — Indicates whether the entity may be used as a transacting entity on transactions.
• EFFECTIVE_FROM / EFFECTIVE_TO — Date-range columns controlling the validity period of the entity profile.
• TYPE_OF_COMPANY — Classifies the corporate nature of the entity.
• ACTIVITY_CODE / SUB_ACTIVITY_CODE — Further classification attributes for regulatory and reporting purposes.
• LE_INFORMATION_CONTEXT and LE_INFORMATION1–20 — Descriptive flexfield (DFF) context and attribute segments for customer-specific legal entity information.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–20 — Standard EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — Standard EBS audit and optimistic-locking columns.

Common Use Cases and Queries

XLE_ENTITY_PROFILES is queried whenever a legal entity must be resolved for subledger accounting, intercompany processing, or financial reporting. Typical scenarios include listing active transacting entities, retrieving the party behind a legal entity, and reporting on DFF-captured entity attributes.

• Resolve an entity by identifier: SELECT legal_entity_id, name FROM xle_entity_profiles WHERE legal_entity_identifier = :id;
• List currently effective transacting entities: SELECT legal_entity_id, name FROM xle_entity_profiles WHERE transacting_entity_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_to, SYSDATE);
• Join to the TCA party for party details using PARTY_ID.
• Report on TYPE_OF_COMPANY and ACTIVITY_CODE for corporate classification summaries.
• Extract DFF segments (LE_INFORMATION1–20) alongside the LE_INFORMATION_CONTEXT for custom analytics.

Related Objects

The documented foreign key shows that XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID references FV_LEGAL_ENTITIES, the federal financials legal entity view. In practice it also underpins several dependent XLE and downstream objects:

• FV_LEGAL_ENTITIES — Referenced via LEGAL_ENTITY_ID.
• XLE_ENTITY_PROFILES_VL / XLE_ENTITY_PROFILES_TL — Views and translation tables surfacing this base table.
• XLE_ENTITY_PROFILES_ATTRS — Additional entity attribute storage keyed by LEGAL_ENTITY_ID.
• XLE_ETB_PROFILES — Establishment profiles linked by LEGAL_ENTITY_ID.
• XLE_ASSOCIATIONS — Captures relationships between legal entities and other entities.
• XLE_REGISTRATIONS — Tax and regulatory registration records tied to the legal entity.

The Legal Entity Configurator APIs and the Accounting Setup Manager consume XLE_ENTITY_PROFILES as the authoritative source for entity definition throughout EBS.