Search Results xle_le_interface




Overview
Explore in AI Chat

Overview

XLE_LE_INTERFACE is a table owned by the XLE schema, which is the database schema for the Legal Entity Configurator product in Oracle E-Business Suite. The table was intended as a staging and interface structure for importing or migrating legal entity definitions into the E-Business Suite legal entity model. In the context of Oracle EBS 12.1.1 and 12.2.2, XLE_LE_INTERFACE is documented as no longer used. Oracle ETRM explicitly marks the object as valid at the dictionary level but functionally obsolete, meaning it may still be present in the database, but no current application flow, concurrent program, or API writes to or reads from it.

Because the table is obsolete, it should be treated as a legacy artifact only. ETRM's heuristic Data Vault classification, mined from the foreign key structure, identifies XLE_LE_INTERFACE as a standalone object. In Data Vault modeling terms this suggests it does not participate in the downstream hub-and-link graph of the live legal entity model; it contains no outbound links to dependent satellites and should not be modeled as a hub, link, or satellite in a target data warehouse. Its only documented relationship is a reference from LEGAL_ENTITY_ID to FV_LEGAL_ENTITIES.

Key Information Stored

The documented physical schema for XLE_LE_INTERFACE in ETRM 12.2.2 contains 17 columns. The most significant are listed below.

  • LEGAL_ENTITY_ID — The legal entity identifier and the only documented business-key candidate. It is enforced by the unique index XLE_LE_INTERFACE_U1 and is the column that references FV_LEGAL_ENTITIES.
  • PARTY_ID — The identifier of the trading party or organization associated with the legal entity being interfaced.
  • NAME — The legal entity name as supplied by the source system or staging process.
  • GEOGRAPHY_ID — Reference to the geography or jurisdiction associated with the legal entity.
  • LOCATION_ID — Reference to the location record for the legal entity's registered address.
  • REGISTRATION_NUMBER — The external registration or incorporation number of the legal entity.
  • LEGAL_ENTITY_IDENTIFIER — An additional identifier used to match the incoming legal entity against an existing record.
  • SOURCE — Indicates the source system or process that populated the interface row.
  • REVIEWED_FLAG — Flag indicating whether the staged row has been reviewed for migration.
  • MIGRATE_FLAG — Flag indicating whether the row is eligible for migration to the live legal entity model.
  • DO_NOT_MIGRATE_ALLOWED — Control flag governing whether the row may be excluded from migration.
  • LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard EBS audit columns recording the last modifying user, date, and login.
  • CREATION_DATE / CREATED_BY — Standard EBS audit columns recording row creation.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by EBS to detect concurrent updates.

No surrogate primary key beyond LEGAL_ENTITY_ID is documented; the unique index XLE_LE_INTERFACE_U1 on LEGAL_ENTITY_ID serves as the business-key candidate.

Common Use Cases and Queries

Because the table is obsolete, there is no supported functional use case in 12.1.1 or 12.2.2. The realistic scenarios are limited to historical investigation, data archaeology, and pre-upgrade cleanup.

  • Determining whether legacy staging data remains before an upgrade or schema cleanup:

    SELECT COUNT(*) FROM xle.xle_le_interface;

  • Reconciling staged legal entities against the live legal entity table:

    SELECT i.legal_entity_id, i.name, f.legal_entity_id
    FROM xle.xle_le_interface i, fv.fv_legal_entities f
    WHERE i.legal_entity_id = f.legal_entity_id;

  • Identifying rows flagged for migration but never processed:

    SELECT legal_entity_id, name, migrate_flag, reviewed_flag
    FROM xle.xle_le_interface
    WHERE migrate_flag = 'Y' AND reviewed_flag = 'N';

  • Archiving or purging obsolete interface rows as part of a data retention exercise.

No reporting view or concurrent program in current EBS releases depends on this table, so these queries are investigative only.

Related Objects

  • FV_LEGAL_ENTITIES — The single documented foreign key target, joined on LEGAL_ENTITY_ID.
  • XLE_LE_ENTITY — The primary live storage table for legal entity definitions; the successor to the interface staging concept.
  • XLE_ENTITY_PROFILES — The primary entity profile table referenced by legal entities.
  • XLE_ETB_PROFILES — Establishments, Tax and Bank profile data associated with legal entities.
  • HZ_PARTIES — The parties model that underpins PARTY_ID references.
  • HZ_LOCATIONS — The location model underlying LOCATION_ID.
  • FND_GLOBAL — Supplies the user and login context referenced by the audit columns.