Search Results xle_le_ou_interface




Overview
Explore in AI Chat

Overview

XLE_LE_OU_INTERFACE is a table in the XLE schema owned by the Legal Entity Configurator module of Oracle E-Business Suite. According to the ETRM documentation metadata (validated against 12.1.1 and 12.2.2), the object is flagged as VALID within the data dictionary, but its product description states explicitly that "This table is no longer used." The table therefore represents a historical or deprecated staging structure that once supported the association of legal entities with operating units during the Legal Entity Configurator setup flow. It is retained in the schema for backward compatibility and upgrade integrity, not for active transactional or configuration processing.

From a data modeling perspective, the metadata supplies a heuristic Data Vault classification of "standalone." This should be treated as a modeling suggestion rather than a normative designation: XLE_LE_OU_INTERFACE does not function as a traditional hub, link, or satellite because it carries no foreign-key relationships to other interface or staging tables beyond a single reference to FV_LEGAL_ENTITIES. Its role in any Data Vault design would be that of an isolated landing or staging structure rather than an integrated component of the enterprise model.

Key Information Stored

The documented physical schema contains eleven columns. The most significant are described below.

  • LE_OU_ID — Surrogate primary key for the table, enforced by the unique index XLE_LE_OU_INTERFACE_U1. This is the technical identifier for a legal entity operating unit interface record.
  • LEGAL_ENTITY_ID — Reference to the legal entity being associated with an operating unit; joins to FV_LEGAL_ENTITIES. Part of the composite unique index XLE_LE_OU_INTERFACE_U2.
  • SET_OF_BOOKS_ID — Identifier of the set of books (ledger) context in which the legal entity operating unit association applies. Also part of XLE_LE_OU_INTERFACE_U2.
  • ORGANIZATION_ID — Operating unit organization identifier. Together with LEGAL_ENTITY_ID and SET_OF_BOOKS_ID, this forms the business-key candidate enforced by XLE_LE_OU_INTERFACE_U2.
  • LE_SOB_ID — A secondary legal entity / set of books reference column, likely used as an internal denormalized link during interface processing.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE — Standard WHO columns capturing the creating user and timestamp of the interface row.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent update user, timestamp, and login session.

The surrogate key LE_OU_ID is distinct from the composite business-key candidate (LEGAL_ENTITY_ID, SET_OF_BOOKS_ID, ORGANIZATION_ID), which uniquely identifies the semantic association of a legal entity to an operating unit within a ledger.

Common Use Cases and Queries

Because the table is documented as no longer used, production queries against it are uncommon. Its principal relevance is in upgrade diagnostics, historical data investigations, and cleanup auditing. A typical retrospective query joins the interface rows to the master legal entity table:

  • SELECT i.le_ou_id, i.legal_entity_id, i.set_of_books_id, i.organization_id, f.legal_entity_name FROM xle_le_ou_interface i, fv_legal_entities f WHERE i.legal_entity_id = f.legal_entity_id;
  • Detecting orphaned or stale interface rows prior to a data purge.
  • Auditing which legal entity / operating unit combinations were staged by a given user, using CREATED_BY and CREATION_DATE.
  • Reconciliation during 12.1.1 to 12.2.2 upgrades, where legacy staging content may be referenced to validate migrated legal entity assignments.

Related Objects

The FK metadata documents a single outbound relationship from XLE_LE_OU_INTERFACE to FV_LEGAL_ENTITIES via LEGAL_ENTITY_ID. This is the most significant reference for join purposes.

  • FV_LEGAL_ENTITIES — Master legal entity definition; joined on LEGAL_ENTITY_ID.
  • XLE_LE_OU_INTERFACE_U1 — Unique index on LE_OU_ID, enforcing the surrogate primary key.
  • XLE_LE_OU_INTERFACE_U2 — Unique index on LEGAL_ENTITY_ID, SET_OF_BOOKS_ID, ORGANIZATION_ID, enforcing the composite business key.
  • XLE_ENTITY_PROFILES — The current authoritative legal entity profile table superseding this interface.
  • HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — Source of operating unit definitions referenced via ORGANIZATION_ID.
  • GL_SETS_OF_BOOKS / GL_LEDGERS — Ledger context referenced by SET_OF_BOOKS_ID.

These references establish the historical position of the interface table within the Legal Entity Configurator data flow, even though it is no longer an active participant in current processing.