Search Results xle_le_bsv_interface




Overview
Explore in AI Chat

Overview

XLE_LE_BSV_INTERFACE is a table within the XLE schema (Legal Entity Configurator) in Oracle E-Business Suite 12.1.1 and 12.2.2. Per Oracle's Electronic Technical Reference Manual (ETRM), the table is documented with an explicit status of "This table is no longer used." Its presence in the data dictionary persists because shipped EBS schemas retain legacy objects for backward compatibility, upgrade integrity, and dependent object compilation, even after functional retirement. The table is therefore best understood as a deprecated staging or interface artifact associated with the historical association between legal entities, sets of books, and balancing segment values (BSVs). It holds 12 documented columns and is classified as VALID at the database object level.

The heuristic Data Vault classification mined from foreign key structure is standalone, meaning that the table neither functions as a hub, link, nor satellite within any currently active integration model. The single documented foreign key targets FV_LEGAL_ENTITIES, which is itself a compatibility view rather than a base entity table; this reinforces the interpretation that XLE_LE_BSV_INTERFACE is an obsolete interface construct rather than an operational entity store.

Key Information Stored

The primary surrogate key is LE_BSV_ID, enforced by unique index XLE_LE_BSV_INTERFACE_U1, which makes it the single-column business-key candidate and the most reliable identifier for any surviving rows.

  • LE_BSV_ID — Surrogate primary key uniquely identifying each row.
  • LE_SOB_ID — Identifier linking the legal entity to its associated set of books at the interface level.
  • LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the legal entity the balancing segment value applies to.
  • SET_OF_BOOKS_ID — The set of books context for the balancing segment association.
  • BALANCING_SEGMENT_VALUE — The balancing segment value assigned to the legal entity within the given set of books.
  • BSV_FLEX_VALUE_SET_ID — Identifies the flex value set from which the balancing segment value is drawn.
  • OBJECT_VERSION_NUMBER — Optimistic locking column, standard on EBS interface and OA Framework-managed tables.

The composite unique index XLE_LE_BSV_INTERFACE_U2 (LEGAL_ENTITY_ID, SET_OF_BOOKS_ID, BALANCING_SEGMENT_VALUE) documents the intended business rule: one balancing segment value per legal entity per set of books. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard audit who-columns maintained by EBS concurrent and form-based processes.

Common Use Cases and Queries

Because the object is retired, practical use cases are limited to migration validation, historical data auditing, and cleanup scripts. A typical diagnostic query confirms whether the table still contains rows before a patch or upgrade:

  • Row count validation: SELECT COUNT(*) FROM XLE.XLE_LE_BSV_INTERFACE; to determine whether legacy staging data remains.
  • Historical attribution: SELECT LEGAL_ENTITY_ID, SET_OF_BOOKS_ID, BALANCING_SEGMENT_VALUE FROM XLE.XLE_LE_BSV_INTERFACE WHERE LEGAL_ENTITY_ID = :le_id; to compare against current configurations in XLE_ENTITY_PROFILES and XLE_LE_BSV_ASSIGNMENTS.
  • Integrity review: joining the composite key back to the legal entity to assess orphaned records, useful prior to schema cleanup.

No current ETRM implementation guidance directs developers to write to or read from this table; all new development should target the active XLE configuration tables instead.

Related Objects

Related objects are derived from the documented foreign key and from the logical model the table once served:

  • FV_LEGAL_ENTITIES — Referenced by LEGAL_ENTITY_ID; the compatibility view exposing legal entity data.
  • XLE_ENTITY_PROFILES — Current store of legal entity definitions used in place of the retired interface.
  • XLE_LE_BSV_ASSIGNMENTS — Active table managing legal entity to balancing segment value assignments.
  • XLE_REGISTRATIONS — Links legal entities to sets of books and ledgers in current configurations.
  • FND_FLEX_VALUES / FND_ID_FLEX_SEGMENTS — Supply the flex value set context referenced by BSV_FLEX_VALUE_SET_ID.

Collectively, these objects represent the modern successor path for the functionality XLE_LE_BSV_INTERFACE once supported, confirming its status as a dormant, upgrade-retained interface table.