Search Results xle_le_sob_interface




Overview
Explore in AI Chat

Overview

The XLE_LE_SOB_INTERFACE table resides in the XLE schema, which is owned by the Legal Entity Configurator product within Oracle E-Business Suite. According to the documented ETRM metadata, this table is no longer used. It was historically intended to serve as a staging or interface structure for associating legal entities with sets of books during legal entity configuration. In both Oracle EBS 12.1.1 and 12.2.2, the table is retained in the schema as a legacy artifact but is no longer populated or referenced by the application's functional flows. Practitioners performing upgrades or data discovery exercises will still encounter the object in the data dictionary, and it is important to recognize it as deprecated rather than active.

From a data vault modeling perspective, the metadata classifies this object as standalone (heuristic, mined from its foreign key structure). This is a modeling suggestion only. Structurally, the table behaves like a link between two business entities — a legal entity and a set of books — with a degenerate surrogate key. Because no downstream dependencies were mined, treating it as an isolated link without satellite context is the most defensible interpretation.

Key Information Stored

The documented physical schema for XLE_LE_SOB_INTERFACE contains nine columns. The most significant are:

Distinguishing the surrogate key (LE_SOB_ID) from the business-key candidates (LEGAL_ENTITY_ID plus SET_OF_BOOKS_ID) is useful when interpreting the object's original intent, even though the table is presently dormant.

Common Use Cases and Queries

Because the table is no longer used, active functional queries against it are not expected. However, it may appear in the following scenarios:

  • Upgrade and migration audits — Verifying whether legacy interface data remains and should be discarded or archived. A representative query: SELECT COUNT(*) FROM xle.xle_le_sob_interface;
  • Structural discovery — Confirming that the object exists and carries no rows: SELECT * FROM xle.xle_le_sob_interface WHERE ROWNUM <= 10;
  • Impact and dependency analysis — Checking whether any custom code, concurrent program, or view references the table before dropping it: query DBA_DEPENDENCIES with REFERENCED_NAME = 'XLE_LE_SOB_INTERFACE'.
  • Data vault lineage reconstruction — Joining to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to establish legacy associations between legal entities and sets of books for historical reporting.

Related Objects

  • FV_LEGAL_ENTITIES — Referenced by the foreign key XLE_LE_SOB_INTERFACE.LEGAL_ENTITY_ID. Join column: xle_le_sob_interface.legal_entity_id = fv_legal_entities.legal_entity_id. This is the primary structural relationship documented.
  • XLE_LE_SOB_ASSOCIATIONS — The functional successor structure that records legal entity and ledger relationships in current releases.
  • XLE_LEGAL_ENTITIES — The XLE-owned master table holding legal entity definitions.
  • GL_LEDGERS / GL_SETS_OF_BOOKS — The eventual target of SET_OF_BOOKS_ID values in the 12.2.2 ledger model.
  • XLE_ENTITY_PROFILES — Frequently joined when resolving legal entity context in XLE reporting.

Customizations or reports that still reference XLE_LE_SOB_INTERFACE should be reviewed and redirected to the supported association tables during 12.2.2 remediation.